PREVIEW / stock_5min / 2023-12-08
file: by_date/stock_5min/2023/2023-12-08.parquet size: 6.7 MB rows: 402,433 symbols: 1,262
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 |
|---|---|---|---|---|---|---|---|
| 2023-12-08 04:05:00 | AAPL | Stock | 194.0 | 194.14 | 194.0 | 194.14 | 511.0 |
| 2023-12-08 04:10:00 | AAPL | Stock | 194.09 | 194.09 | 194.09 | 194.09 | 100.0 |
| 2023-12-08 04:15:00 | AAPL | Stock | 194.13 | 194.15 | 194.13 | 194.15 | 650.0 |
| 2023-12-08 04:25:00 | AAPL | Stock | 194.1 | 194.13 | 194.1 | 194.13 | 525.0 |
| 2023-12-08 04:30:00 | AAPL | Stock | 194.13 | 194.17 | 194.13 | 194.17 | 575.0 |
| 2023-12-08 04:50:00 | AAPL | Stock | 194.13 | 194.13 | 194.13 | 194.13 | 125.0 |
| 2023-12-08 05:00:00 | AAPL | Stock | 194.13 | 194.13 | 194.13 | 194.13 | 200.0 |
| 2023-12-08 05:05:00 | AAPL | Stock | 194.13 | 194.13 | 194.13 | 194.13 | 200.0 |
| 2023-12-08 05:25:00 | AAPL | Stock | 194.2 | 194.25 | 194.2 | 194.22 | 1140.0 |
| 2023-12-08 05:30:00 | AAPL | Stock | 194.22 | 194.24 | 194.22 | 194.24 | 643.0 |
| 2023-12-08 05:35:00 | AAPL | Stock | 194.26 | 194.27 | 194.26 | 194.27 | 1300.0 |
| 2023-12-08 05:40:00 | AAPL | Stock | 194.3 | 194.3 | 194.25 | 194.25 | 1817.0 |
| 2023-12-08 05:45:00 | AAPL | Stock | 194.27 | 194.27 | 194.21 | 194.21 | 450.0 |
| 2023-12-08 05:55:00 | AAPL | Stock | 194.23 | 194.23 | 194.23 | 194.23 | 145.0 |
| 2023-12-08 06:10:00 | AAPL | Stock | 194.22 | 194.33 | 194.22 | 194.33 | 2735.0 |
| 2023-12-08 06:20:00 | AAPL | Stock | 194.18 | 194.27 | 194.17 | 194.27 | 5909.0 |
| 2023-12-08 06:30:00 | AAPL | Stock | 194.19 | 194.27 | 194.19 | 194.27 | 1149.0 |
| 2023-12-08 06:35:00 | AAPL | Stock | 194.16 | 194.16 | 194.16 | 194.16 | 100.0 |
| 2023-12-08 06:45:00 | AAPL | Stock | 194.1 | 194.15 | 194.1 | 194.15 | 2112.0 |
| 2023-12-08 06:50:00 | AAPL | Stock | 194.0 | 194.0 | 194.0 | 194.0 | 125.0 |
| 2023-12-08 07:00:00 | AAPL | Stock | 193.9 | 193.9 | 193.85 | 193.86 | 4102.0 |
| 2023-12-08 07:05:00 | AAPL | Stock | 193.85 | 193.85 | 193.8 | 193.8 | 2305.0 |
| 2023-12-08 07:10:00 | AAPL | Stock | 193.78 | 193.82 | 193.78 | 193.82 | 373.0 |
| 2023-12-08 07:15:00 | AAPL | Stock | 193.84 | 193.88 | 193.84 | 193.88 | 422.0 |
| 2023-12-08 07:20:00 | AAPL | Stock | 193.94 | 193.94 | 193.94 | 193.94 | 1300.0 |
| 2023-12-08 07:25:00 | AAPL | Stock | 193.89 | 193.9 | 193.89 | 193.9 | 2666.0 |
| 2023-12-08 07:30:00 | AAPL | Stock | 193.88 | 193.88 | 193.88 | 193.88 | 835.0 |
| 2023-12-08 07:40:00 | AAPL | Stock | 193.9 | 193.9 | 193.9 | 193.9 | 878.0 |
| 2023-12-08 07:45:00 | AAPL | Stock | 193.96 | 194.0 | 193.96 | 194.0 | 721.0 |
| 2023-12-08 07:50:00 | AAPL | Stock | 193.97 | 194.05 | 193.97 | 194.05 | 916.0 |
| 2023-12-08 08:00:00 | AAPL | Stock | 193.85 | 194.13 | 193.75 | 194.02 | 54083.0 |
| 2023-12-08 08:05:00 | AAPL | Stock | 194.0 | 194.05 | 193.9 | 194.0 | 7415.0 |
| 2023-12-08 08:10:00 | AAPL | Stock | 194.0 | 194.0 | 193.89 | 193.8999 | 8507.0 |
| 2023-12-08 08:15:00 | AAPL | Stock | 193.89 | 193.91 | 193.89 | 193.9 | 8872.0 |
| 2023-12-08 08:20:00 | AAPL | Stock | 193.9 | 193.92 | 193.87 | 193.9 | 5575.0 |
| 2023-12-08 08:25:00 | AAPL | Stock | 193.91 | 193.97 | 193.8 | 193.9 | 13013.0 |
| 2023-12-08 08:30:00 | AAPL | Stock | 193.98 | 194.31 | 193.44 | 193.65 | 75151.0 |
| 2023-12-08 08:35:00 | AAPL | Stock | 193.61 | 194.12 | 193.61 | 194.02 | 27050.0 |
| 2023-12-08 08:40:00 | AAPL | Stock | 194.02 | 194.39 | 193.95 | 194.2 | 56317.0 |
| 2023-12-08 08:45:00 | AAPL | Stock | 194.2 | 194.3 | 194.05 | 194.05 | 15690.0 |
| 2023-12-08 08:50:00 | AAPL | Stock | 194.05 | 194.25 | 194.0 | 194.2 | 8025.0 |
| 2023-12-08 08:55:00 | AAPL | Stock | 194.02 | 194.18 | 194.02 | 194.1 | 7524.0 |
| 2023-12-08 09:00:00 | AAPL | Stock | 194.11 | 194.27 | 194.01 | 194.26 | 21034.0 |
| 2023-12-08 09:05:00 | AAPL | Stock | 194.23 | 194.27 | 194.1503 | 194.26 | 8558.0 |
| 2023-12-08 09:10:00 | AAPL | Stock | 194.27 | 194.34 | 194.05 | 194.05 | 29918.0 |
| 2023-12-08 09:15:00 | AAPL | Stock | 194.08 | 194.1499 | 194.07 | 194.09 | 5593.0 |
| 2023-12-08 09:20:00 | AAPL | Stock | 194.12 | 194.25 | 194.1 | 194.14 | 17454.0 |
| 2023-12-08 09:25:00 | AAPL | Stock | 194.1 | 194.15 | 193.65 | 194.12 | 62615.0 |
| 2023-12-08 09:30:00 | AAPL | Stock | 194.08 | 194.55 | 193.94 | 194.0591 | 1510895.0 |
| 2023-12-08 09:35:00 | AAPL | Stock | 194.0676 | 194.2 | 193.91 | 194.079 | 617831.0 |
> showing 50 of 402,433 rows — these rows as CSV