PREVIEW / stock_5min / 2022-11-18
file: by_date/stock_5min/2022/2022-11-18.parquet size: 6.7 MB rows: 409,950 symbols: 2,090
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2022-11-18 04:00:00 | AAPL | Stock | 150.17 | 150.69 | 150.17 | 150.5 | 4409.0 |
| 2022-11-18 04:05:00 | AAPL | Stock | 150.6 | 150.84 | 150.6 | 150.75 | 3039.0 |
| 2022-11-18 04:10:00 | AAPL | Stock | 150.61 | 150.64 | 150.61 | 150.61 | 1192.0 |
| 2022-11-18 04:15:00 | AAPL | Stock | 150.7 | 150.83 | 150.7 | 150.8 | 2163.0 |
| 2022-11-18 04:20:00 | AAPL | Stock | 150.8 | 150.83 | 150.8 | 150.8 | 1494.0 |
| 2022-11-18 04:25:00 | AAPL | Stock | 150.78 | 151.0 | 150.77 | 151.0 | 7322.0 |
| 2022-11-18 04:30:00 | AAPL | Stock | 151.01 | 151.08 | 151.01 | 151.05 | 603.0 |
| 2022-11-18 04:35:00 | AAPL | Stock | 151.12 | 151.2 | 151.12 | 151.2 | 2019.0 |
| 2022-11-18 04:40:00 | AAPL | Stock | 151.19 | 151.22 | 151.16 | 151.2 | 2138.0 |
| 2022-11-18 04:45:00 | AAPL | Stock | 151.15 | 151.15 | 151.07 | 151.07 | 1626.0 |
| 2022-11-18 04:50:00 | AAPL | Stock | 151.02 | 151.02 | 150.87 | 150.87 | 10367.0 |
| 2022-11-18 04:55:00 | AAPL | Stock | 150.83 | 150.85 | 150.8 | 150.8 | 1966.0 |
| 2022-11-18 05:00:00 | AAPL | Stock | 150.81 | 150.81 | 150.73 | 150.76 | 10594.0 |
| 2022-11-18 05:05:00 | AAPL | Stock | 150.92 | 150.92 | 150.92 | 150.92 | 800.0 |
| 2022-11-18 05:10:00 | AAPL | Stock | 150.97 | 151.1 | 150.97 | 151.1 | 1205.0 |
| 2022-11-18 05:15:00 | AAPL | Stock | 151.26 | 151.35 | 151.2 | 151.23 | 1500.0 |
| 2022-11-18 05:20:00 | AAPL | Stock | 151.23 | 151.23 | 150.8 | 150.94 | 5711.0 |
| 2022-11-18 05:30:00 | AAPL | Stock | 151.0 | 151.01 | 151.0 | 151.0 | 359.0 |
| 2022-11-18 05:35:00 | AAPL | Stock | 151.15 | 151.4 | 151.15 | 151.4 | 1248.0 |
| 2022-11-18 05:40:00 | AAPL | Stock | 151.4 | 151.5 | 151.35 | 151.35 | 2033.0 |
| 2022-11-18 05:45:00 | AAPL | Stock | 151.36 | 151.4 | 151.36 | 151.4 | 819.0 |
| 2022-11-18 05:50:00 | AAPL | Stock | 151.48 | 151.68 | 151.48 | 151.64 | 3818.0 |
| 2022-11-18 05:55:00 | AAPL | Stock | 151.6 | 151.66 | 151.58 | 151.6 | 3100.0 |
| 2022-11-18 06:00:00 | AAPL | Stock | 151.5 | 151.58 | 151.28 | 151.4 | 10325.0 |
| 2022-11-18 06:05:00 | AAPL | Stock | 151.38 | 151.38 | 151.38 | 151.38 | 560.0 |
| 2022-11-18 06:10:00 | AAPL | Stock | 151.41 | 151.41 | 151.41 | 151.41 | 156.0 |
| 2022-11-18 06:20:00 | AAPL | Stock | 151.4 | 151.4 | 151.4 | 151.4 | 100.0 |
| 2022-11-18 06:25:00 | AAPL | Stock | 151.33 | 151.38 | 151.29 | 151.38 | 940.0 |
| 2022-11-18 06:30:00 | AAPL | Stock | 151.39 | 151.45 | 151.39 | 151.45 | 225.0 |
| 2022-11-18 06:35:00 | AAPL | Stock | 151.37 | 151.39 | 151.3 | 151.39 | 10740.0 |
| 2022-11-18 06:40:00 | AAPL | Stock | 151.38 | 151.38 | 151.34 | 151.34 | 1050.0 |
| 2022-11-18 06:50:00 | AAPL | Stock | 151.36 | 151.38 | 151.36 | 151.37 | 6324.0 |
| 2022-11-18 06:55:00 | AAPL | Stock | 151.3 | 151.3 | 151.3 | 151.3 | 1350.0 |
| 2022-11-18 07:00:00 | AAPL | Stock | 151.31 | 151.85 | 151.29 | 151.83 | 21751.0 |
| 2022-11-18 07:05:00 | AAPL | Stock | 151.83 | 151.85 | 151.71 | 151.85 | 6228.0 |
| 2022-11-18 07:10:00 | AAPL | Stock | 151.85 | 152.07 | 151.79 | 151.79 | 15826.0 |
| 2022-11-18 07:15:00 | AAPL | Stock | 151.85 | 152.03 | 151.85 | 151.95 | 8270.0 |
| 2022-11-18 07:20:00 | AAPL | Stock | 151.94 | 151.94 | 151.52 | 151.52 | 9348.0 |
| 2022-11-18 07:25:00 | AAPL | Stock | 151.71 | 151.71 | 151.71 | 151.71 | 750.0 |
| 2022-11-18 07:30:00 | AAPL | Stock | 151.82 | 151.83 | 151.76 | 151.76 | 9280.0 |
| 2022-11-18 07:35:00 | AAPL | Stock | 151.77 | 151.77 | 151.66 | 151.74 | 5359.0 |
| 2022-11-18 07:40:00 | AAPL | Stock | 151.69 | 151.69 | 151.67 | 151.69 | 1300.0 |
| 2022-11-18 07:45:00 | AAPL | Stock | 151.7 | 151.71 | 151.69 | 151.71 | 1195.0 |
| 2022-11-18 07:50:00 | AAPL | Stock | 151.75 | 151.75 | 151.6 | 151.62 | 5848.0 |
| 2022-11-18 07:55:00 | AAPL | Stock | 151.61 | 151.66 | 151.53 | 151.55 | 11952.0 |
| 2022-11-18 08:00:00 | AAPL | Stock | 151.57 | 152.0885 | 151.3 | 151.74 | 42062.0 |
| 2022-11-18 08:05:00 | AAPL | Stock | 151.75 | 151.95 | 151.75 | 151.85 | 20882.0 |
| 2022-11-18 08:10:00 | AAPL | Stock | 151.89 | 151.99 | 151.8 | 151.87 | 9570.0 |
| 2022-11-18 08:15:00 | AAPL | Stock | 151.8731 | 151.96 | 151.8731 | 151.96 | 7501.0 |
| 2022-11-18 08:20:00 | AAPL | Stock | 151.93 | 151.95 | 151.83 | 151.9 | 7833.0 |
> showing 50 of 409,950 rows — these rows as CSV