PREVIEW / stock_5min / 2024-08-14
file: by_date/stock_5min/2024/2024-08-14.parquet size: 6.4 MB rows: 391,174 symbols: 852
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-08-14 04:00:00 | AAPL | Stock | 221.28 | 221.4 | 220.9 | 221.0 | 8185.0 |
| 2024-08-14 04:05:00 | AAPL | Stock | 220.92 | 221.13 | 220.92 | 220.92 | 3965.0 |
| 2024-08-14 04:10:00 | AAPL | Stock | 220.93 | 220.98 | 220.88 | 220.98 | 1005.0 |
| 2024-08-14 04:15:00 | AAPL | Stock | 220.9 | 220.9 | 220.77 | 220.77 | 563.0 |
| 2024-08-14 04:20:00 | AAPL | Stock | 220.92 | 221.02 | 220.92 | 221.02 | 1061.0 |
| 2024-08-14 04:25:00 | AAPL | Stock | 220.99 | 221.08 | 220.99 | 221.07 | 1640.0 |
| 2024-08-14 04:30:00 | AAPL | Stock | 221.14 | 221.15 | 221.09 | 221.09 | 1059.0 |
| 2024-08-14 04:35:00 | AAPL | Stock | 221.16 | 221.17 | 221.0 | 221.13 | 710.0 |
| 2024-08-14 04:45:00 | AAPL | Stock | 221.03 | 221.13 | 221.03 | 221.13 | 410.0 |
| 2024-08-14 04:50:00 | AAPL | Stock | 221.17 | 221.18 | 221.08 | 221.16 | 600.0 |
| 2024-08-14 04:55:00 | AAPL | Stock | 221.07 | 221.07 | 221.07 | 221.07 | 100.0 |
| 2024-08-14 05:00:00 | AAPL | Stock | 221.19 | 221.19 | 221.18 | 221.18 | 642.0 |
| 2024-08-14 05:05:00 | AAPL | Stock | 221.19 | 221.2 | 221.15 | 221.15 | 1070.0 |
| 2024-08-14 05:15:00 | AAPL | Stock | 221.12 | 221.2 | 221.12 | 221.2 | 324.0 |
| 2024-08-14 05:20:00 | AAPL | Stock | 221.33 | 221.4 | 221.33 | 221.4 | 589.0 |
| 2024-08-14 05:25:00 | AAPL | Stock | 221.5 | 221.59 | 221.49 | 221.58 | 2286.0 |
| 2024-08-14 05:30:00 | AAPL | Stock | 221.63 | 221.7 | 221.61 | 221.61 | 400.0 |
| 2024-08-14 05:35:00 | AAPL | Stock | 221.63 | 221.63 | 221.63 | 221.63 | 100.0 |
| 2024-08-14 05:40:00 | AAPL | Stock | 221.62 | 221.62 | 221.57 | 221.61 | 600.0 |
| 2024-08-14 05:45:00 | AAPL | Stock | 221.61 | 221.61 | 221.6 | 221.6 | 201.0 |
| 2024-08-14 05:50:00 | AAPL | Stock | 221.64 | 221.69 | 221.6 | 221.6 | 1075.0 |
| 2024-08-14 05:55:00 | AAPL | Stock | 221.61 | 221.61 | 221.61 | 221.61 | 150.0 |
| 2024-08-14 06:00:00 | AAPL | Stock | 221.69 | 221.7 | 221.65 | 221.7 | 305.0 |
| 2024-08-14 06:05:00 | AAPL | Stock | 221.69 | 221.74 | 221.69 | 221.72 | 746.0 |
| 2024-08-14 06:10:00 | AAPL | Stock | 221.74 | 221.77 | 221.68 | 221.77 | 500.0 |
| 2024-08-14 06:15:00 | AAPL | Stock | 221.74 | 221.74 | 221.2 | 221.2 | 4072.0 |
| 2024-08-14 06:20:00 | AAPL | Stock | 221.27 | 221.27 | 221.26 | 221.26 | 387.0 |
| 2024-08-14 06:30:00 | AAPL | Stock | 221.51 | 221.51 | 221.4 | 221.4 | 310.0 |
| 2024-08-14 06:50:00 | AAPL | Stock | 221.5 | 221.51 | 221.5 | 221.51 | 231.0 |
| 2024-08-14 06:55:00 | AAPL | Stock | 221.51 | 221.51 | 221.35 | 221.35 | 1703.0 |
| 2024-08-14 07:00:00 | AAPL | Stock | 221.33 | 221.33 | 221.19 | 221.19 | 1347.0 |
| 2024-08-14 07:05:00 | AAPL | Stock | 221.19 | 221.21 | 220.98 | 220.98 | 2510.0 |
| 2024-08-14 07:10:00 | AAPL | Stock | 221.09 | 221.09 | 220.95 | 221.08 | 1874.0 |
| 2024-08-14 07:15:00 | AAPL | Stock | 221.08 | 221.08 | 221.04 | 221.06 | 742.0 |
| 2024-08-14 07:20:00 | AAPL | Stock | 221.05 | 221.15 | 221.05 | 221.11 | 765.0 |
| 2024-08-14 07:25:00 | AAPL | Stock | 221.14 | 221.15 | 221.1 | 221.14 | 1976.0 |
| 2024-08-14 07:30:00 | AAPL | Stock | 221.14 | 221.14 | 221.09 | 221.1 | 835.0 |
| 2024-08-14 07:35:00 | AAPL | Stock | 221.05 | 221.11 | 221.05 | 221.11 | 885.0 |
| 2024-08-14 07:40:00 | AAPL | Stock | 221.11 | 221.14 | 221.07 | 221.07 | 1893.0 |
| 2024-08-14 07:45:00 | AAPL | Stock | 221.08 | 221.14 | 221.08 | 221.14 | 628.0 |
| 2024-08-14 07:50:00 | AAPL | Stock | 221.09 | 221.11 | 221.09 | 221.11 | 2766.0 |
| 2024-08-14 07:55:00 | AAPL | Stock | 221.05 | 221.05 | 221.04 | 221.04 | 1025.0 |
| 2024-08-14 08:00:00 | AAPL | Stock | 221.2 | 221.65 | 220.35 | 221.14 | 28123.0 |
| 2024-08-14 08:05:00 | AAPL | Stock | 221.11 | 221.1324 | 221.1 | 221.1324 | 500.0 |
| 2024-08-14 08:10:00 | AAPL | Stock | 221.04 | 221.14 | 221.04 | 221.1 | 4420.0 |
| 2024-08-14 08:15:00 | AAPL | Stock | 221.08 | 221.09 | 221.0 | 221.03 | 5147.0 |
| 2024-08-14 08:20:00 | AAPL | Stock | 221.03 | 221.06 | 221.0001 | 221.06 | 1355.0 |
| 2024-08-14 08:25:00 | AAPL | Stock | 221.09 | 221.3598 | 221.09 | 221.3598 | 5767.0 |
| 2024-08-14 08:30:00 | AAPL | Stock | 221.37 | 221.9996 | 220.32 | 221.028 | 48178.0 |
| 2024-08-14 08:35:00 | AAPL | Stock | 220.81 | 221.55 | 220.81 | 221.55 | 13015.0 |
> showing 50 of 391,174 rows — these rows as CSV