PREVIEW / stock_5min / 2023-12-18
file: by_date/stock_5min/2023/2023-12-18.parquet size: 7.1 MB rows: 424,330 symbols: 1,266
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-18 04:00:00 | AAPL | Stock | 196.32 | 196.49 | 196.32 | 196.49 | 1271.0 |
| 2023-12-18 04:05:00 | AAPL | Stock | 196.48 | 196.49 | 196.48 | 196.49 | 804.0 |
| 2023-12-18 04:10:00 | AAPL | Stock | 196.46 | 196.46 | 196.46 | 196.46 | 100.0 |
| 2023-12-18 04:15:00 | AAPL | Stock | 196.42 | 196.42 | 195.83 | 195.98 | 3407.0 |
| 2023-12-18 04:20:00 | AAPL | Stock | 196.02 | 196.02 | 195.94 | 195.94 | 1178.0 |
| 2023-12-18 04:25:00 | AAPL | Stock | 195.97 | 196.03 | 195.97 | 196.03 | 468.0 |
| 2023-12-18 04:30:00 | AAPL | Stock | 196.0 | 196.01 | 195.97 | 195.97 | 1827.0 |
| 2023-12-18 04:35:00 | AAPL | Stock | 196.02 | 196.05 | 196.0 | 196.05 | 375.0 |
| 2023-12-18 04:40:00 | AAPL | Stock | 195.91 | 195.96 | 195.5 | 195.5 | 8028.0 |
| 2023-12-18 04:45:00 | AAPL | Stock | 195.61 | 195.61 | 195.59 | 195.59 | 1246.0 |
| 2023-12-18 04:50:00 | AAPL | Stock | 195.6 | 195.6 | 195.6 | 195.6 | 600.0 |
| 2023-12-18 04:55:00 | AAPL | Stock | 195.77 | 195.77 | 195.77 | 195.77 | 106.0 |
| 2023-12-18 05:00:00 | AAPL | Stock | 195.8 | 195.89 | 195.8 | 195.89 | 412.0 |
| 2023-12-18 05:05:00 | AAPL | Stock | 195.9 | 195.9 | 195.9 | 195.9 | 547.0 |
| 2023-12-18 05:10:00 | AAPL | Stock | 195.8 | 195.85 | 195.8 | 195.85 | 322.0 |
| 2023-12-18 05:15:00 | AAPL | Stock | 195.91 | 195.91 | 195.91 | 195.91 | 300.0 |
| 2023-12-18 05:20:00 | AAPL | Stock | 195.92 | 196.1 | 195.92 | 196.1 | 1232.0 |
| 2023-12-18 05:25:00 | AAPL | Stock | 196.03 | 196.03 | 196.03 | 196.03 | 439.0 |
| 2023-12-18 05:30:00 | AAPL | Stock | 196.1 | 196.2 | 196.1 | 196.18 | 1423.0 |
| 2023-12-18 05:35:00 | AAPL | Stock | 196.12 | 196.13 | 196.06 | 196.06 | 551.0 |
| 2023-12-18 05:40:00 | AAPL | Stock | 196.1 | 196.1 | 196.06 | 196.06 | 200.0 |
| 2023-12-18 05:45:00 | AAPL | Stock | 196.1 | 196.1 | 196.1 | 196.1 | 116.0 |
| 2023-12-18 05:50:00 | AAPL | Stock | 196.0 | 196.0 | 195.99 | 196.0 | 550.0 |
| 2023-12-18 05:55:00 | AAPL | Stock | 196.0 | 196.05 | 196.0 | 196.05 | 442.0 |
| 2023-12-18 06:00:00 | AAPL | Stock | 196.07 | 196.07 | 196.04 | 196.04 | 1747.0 |
| 2023-12-18 06:05:00 | AAPL | Stock | 196.02 | 196.02 | 196.0 | 196.0 | 979.0 |
| 2023-12-18 06:15:00 | AAPL | Stock | 195.95 | 195.95 | 195.95 | 195.95 | 149.0 |
| 2023-12-18 06:20:00 | AAPL | Stock | 196.02 | 196.02 | 196.02 | 196.02 | 1101.0 |
| 2023-12-18 06:25:00 | AAPL | Stock | 196.06 | 196.06 | 196.05 | 196.05 | 395.0 |
| 2023-12-18 06:30:00 | AAPL | Stock | 196.07 | 196.07 | 196.05 | 196.05 | 467.0 |
| 2023-12-18 06:35:00 | AAPL | Stock | 196.07 | 196.11 | 196.07 | 196.11 | 724.0 |
| 2023-12-18 06:40:00 | AAPL | Stock | 196.19 | 196.19 | 196.18 | 196.18 | 1900.0 |
| 2023-12-18 06:50:00 | AAPL | Stock | 196.17 | 196.18 | 196.17 | 196.18 | 487.0 |
| 2023-12-18 06:55:00 | AAPL | Stock | 196.28 | 196.31 | 196.21 | 196.21 | 1763.0 |
| 2023-12-18 07:00:00 | AAPL | Stock | 196.32 | 196.45 | 196.32 | 196.32 | 2470.0 |
| 2023-12-18 07:05:00 | AAPL | Stock | 196.33 | 196.37 | 196.28 | 196.37 | 3760.0 |
| 2023-12-18 07:10:00 | AAPL | Stock | 196.34 | 196.38 | 196.34 | 196.37 | 1585.0 |
| 2023-12-18 07:15:00 | AAPL | Stock | 196.37 | 196.37 | 196.21 | 196.21 | 4494.0 |
| 2023-12-18 07:20:00 | AAPL | Stock | 196.21 | 196.3 | 196.2 | 196.3 | 1350.0 |
| 2023-12-18 07:25:00 | AAPL | Stock | 196.35 | 196.35 | 196.3 | 196.32 | 1768.0 |
| 2023-12-18 07:30:00 | AAPL | Stock | 196.31 | 196.31 | 196.2 | 196.2 | 500.0 |
| 2023-12-18 07:35:00 | AAPL | Stock | 196.19 | 196.19 | 196.17 | 196.17 | 424.0 |
| 2023-12-18 07:40:00 | AAPL | Stock | 196.2 | 196.2 | 196.18 | 196.19 | 588.0 |
| 2023-12-18 07:45:00 | AAPL | Stock | 196.17 | 196.2 | 196.12 | 196.2 | 814.0 |
| 2023-12-18 07:50:00 | AAPL | Stock | 196.21 | 196.39 | 196.21 | 196.39 | 1838.0 |
| 2023-12-18 07:55:00 | AAPL | Stock | 196.44 | 196.5 | 196.44 | 196.48 | 4495.0 |
| 2023-12-18 08:00:00 | AAPL | Stock | 196.44 | 196.5 | 193.5 | 196.48 | 65387.0 |
| 2023-12-18 08:05:00 | AAPL | Stock | 196.44 | 196.4416 | 196.19 | 196.2 | 12320.0 |
| 2023-12-18 08:10:00 | AAPL | Stock | 196.17 | 196.19 | 196.14 | 196.17 | 5485.0 |
| 2023-12-18 08:15:00 | AAPL | Stock | 196.15 | 196.17 | 196.1 | 196.1 | 9841.0 |
> showing 50 of 424,330 rows — these rows as CSV