PREVIEW / stock_5min / 2024-01-05
file: by_date/stock_5min/2024/2024-01-05.parquet size: 6.6 MB rows: 399,779 symbols: 1,169
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 |
|---|---|---|---|---|---|---|---|
| 2024-01-05 04:00:00 | AAPL | Stock | 181.79 | 181.79 | 181.25 | 181.44 | 1281.0 |
| 2024-01-05 04:05:00 | AAPL | Stock | 181.2 | 181.35 | 181.11 | 181.32 | 4397.0 |
| 2024-01-05 04:10:00 | AAPL | Stock | 181.35 | 181.36 | 181.32 | 181.32 | 1280.0 |
| 2024-01-05 04:15:00 | AAPL | Stock | 181.31 | 181.31 | 181.17 | 181.17 | 604.0 |
| 2024-01-05 04:20:00 | AAPL | Stock | 181.27 | 181.27 | 181.1 | 181.26 | 6788.0 |
| 2024-01-05 04:25:00 | AAPL | Stock | 181.2 | 181.2 | 181.09 | 181.2 | 3603.0 |
| 2024-01-05 04:30:00 | AAPL | Stock | 181.05 | 181.05 | 181.05 | 181.05 | 465.0 |
| 2024-01-05 04:35:00 | AAPL | Stock | 181.07 | 181.07 | 181.01 | 181.01 | 1687.0 |
| 2024-01-05 04:40:00 | AAPL | Stock | 180.9 | 180.9 | 180.9 | 180.9 | 269.0 |
| 2024-01-05 04:45:00 | AAPL | Stock | 180.91 | 180.91 | 180.87 | 180.87 | 639.0 |
| 2024-01-05 04:50:00 | AAPL | Stock | 180.84 | 180.85 | 180.83 | 180.83 | 1306.0 |
| 2024-01-05 04:55:00 | AAPL | Stock | 180.8 | 180.8 | 180.8 | 180.8 | 815.0 |
| 2024-01-05 05:00:00 | AAPL | Stock | 180.71 | 180.71 | 180.71 | 180.71 | 100.0 |
| 2024-01-05 05:05:00 | AAPL | Stock | 180.71 | 180.71 | 180.71 | 180.71 | 150.0 |
| 2024-01-05 05:15:00 | AAPL | Stock | 180.8 | 180.8 | 180.8 | 180.8 | 100.0 |
| 2024-01-05 05:20:00 | AAPL | Stock | 180.73 | 180.73 | 180.59 | 180.6 | 993.0 |
| 2024-01-05 05:25:00 | AAPL | Stock | 180.6 | 180.6 | 180.45 | 180.45 | 4235.0 |
| 2024-01-05 05:30:00 | AAPL | Stock | 180.65 | 180.65 | 180.65 | 180.65 | 671.0 |
| 2024-01-05 05:35:00 | AAPL | Stock | 180.6 | 180.65 | 180.6 | 180.65 | 299.0 |
| 2024-01-05 05:40:00 | AAPL | Stock | 180.64 | 180.68 | 180.59 | 180.63 | 5282.0 |
| 2024-01-05 05:45:00 | AAPL | Stock | 180.73 | 180.73 | 180.73 | 180.73 | 271.0 |
| 2024-01-05 05:50:00 | AAPL | Stock | 180.63 | 180.63 | 180.63 | 180.63 | 530.0 |
| 2024-01-05 05:55:00 | AAPL | Stock | 180.6 | 180.68 | 180.58 | 180.6 | 3955.0 |
| 2024-01-05 06:00:00 | AAPL | Stock | 180.63 | 180.65 | 180.63 | 180.65 | 1008.0 |
| 2024-01-05 06:10:00 | AAPL | Stock | 180.59 | 180.59 | 180.52 | 180.52 | 226.0 |
| 2024-01-05 06:15:00 | AAPL | Stock | 180.54 | 180.54 | 180.47 | 180.47 | 715.0 |
| 2024-01-05 06:20:00 | AAPL | Stock | 180.46 | 180.46 | 180.2 | 180.2 | 7632.0 |
| 2024-01-05 06:25:00 | AAPL | Stock | 180.23 | 180.38 | 180.23 | 180.38 | 4185.0 |
| 2024-01-05 06:30:00 | AAPL | Stock | 180.38 | 180.46 | 180.33 | 180.33 | 1876.0 |
| 2024-01-05 06:35:00 | AAPL | Stock | 180.3 | 180.3 | 180.28 | 180.28 | 1310.0 |
| 2024-01-05 06:40:00 | AAPL | Stock | 180.25 | 180.33 | 180.25 | 180.33 | 397.0 |
| 2024-01-05 06:45:00 | AAPL | Stock | 180.35 | 180.51 | 180.35 | 180.51 | 2245.0 |
| 2024-01-05 06:50:00 | AAPL | Stock | 180.5 | 180.75 | 180.5 | 180.75 | 3725.0 |
| 2024-01-05 07:00:00 | AAPL | Stock | 180.72 | 181.06 | 180.63 | 181.0 | 30645.0 |
| 2024-01-05 07:05:00 | AAPL | Stock | 181.0 | 181.0 | 180.78 | 180.78 | 3618.0 |
| 2024-01-05 07:10:00 | AAPL | Stock | 180.77 | 180.77 | 180.73 | 180.73 | 938.0 |
| 2024-01-05 07:15:00 | AAPL | Stock | 180.82 | 180.82 | 180.81 | 180.81 | 1216.0 |
| 2024-01-05 07:20:00 | AAPL | Stock | 180.84 | 180.84 | 180.81 | 180.81 | 880.0 |
| 2024-01-05 07:25:00 | AAPL | Stock | 180.8 | 180.81 | 180.8 | 180.81 | 599.0 |
| 2024-01-05 07:30:00 | AAPL | Stock | 180.82 | 180.82 | 180.77 | 180.77 | 2434.0 |
| 2024-01-05 07:35:00 | AAPL | Stock | 180.77 | 180.8 | 180.77 | 180.8 | 1871.0 |
| 2024-01-05 07:40:00 | AAPL | Stock | 180.81 | 180.81 | 180.79 | 180.79 | 497.0 |
| 2024-01-05 07:45:00 | AAPL | Stock | 180.8 | 180.8 | 180.7 | 180.7 | 3257.0 |
| 2024-01-05 07:50:00 | AAPL | Stock | 180.64 | 180.69 | 180.64 | 180.69 | 1708.0 |
| 2024-01-05 07:55:00 | AAPL | Stock | 180.69 | 180.69 | 180.55 | 180.55 | 5650.0 |
| 2024-01-05 08:00:00 | AAPL | Stock | 181.01 | 181.92 | 180.2917 | 180.39 | 63836.0 |
| 2024-01-05 08:05:00 | AAPL | Stock | 180.5182 | 180.52 | 180.3 | 180.35 | 22519.0 |
| 2024-01-05 08:10:00 | AAPL | Stock | 180.35 | 180.44 | 180.25 | 180.3 | 21862.0 |
| 2024-01-05 08:15:00 | AAPL | Stock | 180.3 | 180.75 | 180.29 | 180.7 | 21953.0 |
| 2024-01-05 08:20:00 | AAPL | Stock | 180.68 | 180.79 | 180.68 | 180.77 | 14696.0 |
> showing 50 of 399,779 rows — these rows as CSV