PREVIEW / stock_5min / 2024-01-25
file: by_date/stock_5min/2024/2024-01-25.parquet size: 6.6 MB rows: 396,111 symbols: 1,160
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-25 04:00:00 | AAPL | Stock | 194.0 | 194.0 | 193.8 | 193.8 | 2298.0 |
| 2024-01-25 04:05:00 | AAPL | Stock | 193.69 | 193.77 | 193.68 | 193.7 | 1706.0 |
| 2024-01-25 04:10:00 | AAPL | Stock | 193.71 | 193.71 | 193.71 | 193.71 | 187.0 |
| 2024-01-25 04:15:00 | AAPL | Stock | 193.7 | 193.77 | 193.63 | 193.63 | 681.0 |
| 2024-01-25 04:20:00 | AAPL | Stock | 193.57 | 193.58 | 193.54 | 193.54 | 975.0 |
| 2024-01-25 04:25:00 | AAPL | Stock | 193.55 | 193.55 | 193.42 | 193.42 | 308.0 |
| 2024-01-25 04:30:00 | AAPL | Stock | 193.45 | 193.62 | 193.45 | 193.5 | 4102.0 |
| 2024-01-25 04:35:00 | AAPL | Stock | 193.54 | 193.55 | 193.5 | 193.5 | 1550.0 |
| 2024-01-25 04:40:00 | AAPL | Stock | 193.54 | 193.54 | 193.54 | 193.54 | 100.0 |
| 2024-01-25 04:45:00 | AAPL | Stock | 193.58 | 193.6 | 193.5 | 193.5 | 639.0 |
| 2024-01-25 04:50:00 | AAPL | Stock | 193.57 | 193.63 | 193.57 | 193.63 | 673.0 |
| 2024-01-25 04:55:00 | AAPL | Stock | 193.76 | 193.79 | 193.66 | 193.66 | 849.0 |
| 2024-01-25 05:00:00 | AAPL | Stock | 193.57 | 193.59 | 193.57 | 193.59 | 350.0 |
| 2024-01-25 05:05:00 | AAPL | Stock | 193.58 | 193.58 | 193.5 | 193.55 | 1358.0 |
| 2024-01-25 05:10:00 | AAPL | Stock | 193.57 | 193.6 | 193.57 | 193.57 | 1405.0 |
| 2024-01-25 05:15:00 | AAPL | Stock | 193.64 | 193.64 | 193.62 | 193.62 | 893.0 |
| 2024-01-25 05:20:00 | AAPL | Stock | 193.65 | 193.65 | 193.65 | 193.65 | 124.0 |
| 2024-01-25 05:25:00 | AAPL | Stock | 193.71 | 193.71 | 193.67 | 193.67 | 424.0 |
| 2024-01-25 05:30:00 | AAPL | Stock | 193.62 | 193.62 | 193.6 | 193.6 | 375.0 |
| 2024-01-25 05:35:00 | AAPL | Stock | 193.62 | 193.63 | 193.62 | 193.63 | 350.0 |
| 2024-01-25 05:40:00 | AAPL | Stock | 193.65 | 193.65 | 193.65 | 193.65 | 100.0 |
| 2024-01-25 05:50:00 | AAPL | Stock | 193.62 | 193.62 | 193.62 | 193.62 | 100.0 |
| 2024-01-25 05:55:00 | AAPL | Stock | 193.63 | 193.64 | 193.63 | 193.64 | 1147.0 |
| 2024-01-25 06:15:00 | AAPL | Stock | 193.6 | 193.6 | 193.56 | 193.56 | 1700.0 |
| 2024-01-25 06:20:00 | AAPL | Stock | 193.53 | 193.59 | 193.53 | 193.59 | 549.0 |
| 2024-01-25 06:25:00 | AAPL | Stock | 193.59 | 193.59 | 193.59 | 193.59 | 183.0 |
| 2024-01-25 06:30:00 | AAPL | Stock | 193.59 | 193.75 | 193.55 | 193.75 | 3627.0 |
| 2024-01-25 06:35:00 | AAPL | Stock | 193.72 | 193.77 | 193.7 | 193.7 | 1602.0 |
| 2024-01-25 06:45:00 | AAPL | Stock | 193.69 | 193.69 | 193.69 | 193.69 | 100.0 |
| 2024-01-25 06:50:00 | AAPL | Stock | 193.78 | 193.81 | 193.78 | 193.81 | 571.0 |
| 2024-01-25 06:55:00 | AAPL | Stock | 193.9 | 194.0 | 193.9 | 193.99 | 1793.0 |
| 2024-01-25 07:00:00 | AAPL | Stock | 194.0 | 194.29 | 193.91 | 194.29 | 4048.0 |
| 2024-01-25 07:05:00 | AAPL | Stock | 194.4 | 194.5 | 194.32 | 194.32 | 6845.0 |
| 2024-01-25 07:10:00 | AAPL | Stock | 194.32 | 194.32 | 194.22 | 194.22 | 1865.0 |
| 2024-01-25 07:15:00 | AAPL | Stock | 194.06 | 194.06 | 193.97 | 193.97 | 3081.0 |
| 2024-01-25 07:20:00 | AAPL | Stock | 193.92 | 194.01 | 193.92 | 194.0 | 5176.0 |
| 2024-01-25 07:25:00 | AAPL | Stock | 193.97 | 194.21 | 193.97 | 194.13 | 3651.0 |
| 2024-01-25 07:30:00 | AAPL | Stock | 194.11 | 194.11 | 194.1 | 194.1 | 1811.0 |
| 2024-01-25 07:35:00 | AAPL | Stock | 194.07 | 194.15 | 194.07 | 194.15 | 681.0 |
| 2024-01-25 07:40:00 | AAPL | Stock | 194.12 | 194.12 | 194.11 | 194.11 | 1780.0 |
| 2024-01-25 07:45:00 | AAPL | Stock | 194.17 | 194.17 | 194.08 | 194.08 | 1497.0 |
| 2024-01-25 07:50:00 | AAPL | Stock | 194.05 | 194.05 | 193.96 | 193.96 | 729.0 |
| 2024-01-25 07:55:00 | AAPL | Stock | 193.92 | 193.94 | 193.89 | 193.94 | 2496.0 |
| 2024-01-25 08:00:00 | AAPL | Stock | 194.23 | 194.5 | 193.6095 | 193.85 | 50668.0 |
| 2024-01-25 08:05:00 | AAPL | Stock | 193.92 | 193.99 | 193.8203 | 193.85 | 6189.0 |
| 2024-01-25 08:10:00 | AAPL | Stock | 193.87 | 193.9 | 193.87 | 193.9 | 1024.0 |
| 2024-01-25 08:15:00 | AAPL | Stock | 193.9 | 194.23 | 193.9 | 194.031 | 8922.0 |
| 2024-01-25 08:20:00 | AAPL | Stock | 194.23 | 194.23 | 194.0533 | 194.23 | 1825.0 |
| 2024-01-25 08:25:00 | AAPL | Stock | 194.23 | 194.25 | 194.05 | 194.05 | 7347.0 |
| 2024-01-25 08:30:00 | AAPL | Stock | 194.01 | 194.75 | 193.88 | 194.64 | 25620.0 |
> showing 50 of 396,111 rows — these rows as CSV