PREVIEW / stock_5min / 2023-11-15
file: by_date/stock_5min/2023/2023-11-15.parquet size: 6.8 MB rows: 411,954 symbols: 1,319
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-11-15 04:00:00 | AAPL | Stock | 187.82 | 187.83 | 187.82 | 187.83 | 449.0 |
| 2023-11-15 04:05:00 | AAPL | Stock | 187.86 | 187.86 | 187.86 | 187.86 | 150.0 |
| 2023-11-15 04:10:00 | AAPL | Stock | 187.82 | 187.85 | 187.8 | 187.85 | 813.0 |
| 2023-11-15 04:15:00 | AAPL | Stock | 187.82 | 187.83 | 187.79 | 187.79 | 787.0 |
| 2023-11-15 04:20:00 | AAPL | Stock | 187.82 | 187.82 | 187.82 | 187.82 | 100.0 |
| 2023-11-15 04:25:00 | AAPL | Stock | 187.83 | 187.83 | 187.8 | 187.8 | 3712.0 |
| 2023-11-15 04:35:00 | AAPL | Stock | 187.8 | 187.8 | 187.8 | 187.8 | 581.0 |
| 2023-11-15 04:40:00 | AAPL | Stock | 187.7 | 187.7 | 187.7 | 187.7 | 114.0 |
| 2023-11-15 04:50:00 | AAPL | Stock | 187.75 | 187.75 | 187.75 | 187.75 | 100.0 |
| 2023-11-15 04:55:00 | AAPL | Stock | 187.77 | 187.78 | 187.77 | 187.78 | 1419.0 |
| 2023-11-15 05:10:00 | AAPL | Stock | 187.8 | 187.88 | 187.8 | 187.88 | 1768.0 |
| 2023-11-15 05:15:00 | AAPL | Stock | 187.88 | 187.88 | 187.88 | 187.88 | 1020.0 |
| 2023-11-15 05:30:00 | AAPL | Stock | 187.9 | 187.95 | 187.9 | 187.95 | 1264.0 |
| 2023-11-15 05:35:00 | AAPL | Stock | 187.95 | 188.0 | 187.95 | 188.0 | 700.0 |
| 2023-11-15 05:45:00 | AAPL | Stock | 187.98 | 187.98 | 187.98 | 187.98 | 191.0 |
| 2023-11-15 05:50:00 | AAPL | Stock | 187.96 | 188.0 | 187.94 | 188.0 | 1272.0 |
| 2023-11-15 05:55:00 | AAPL | Stock | 188.05 | 188.05 | 188.01 | 188.01 | 208.0 |
| 2023-11-15 06:15:00 | AAPL | Stock | 187.95 | 187.95 | 187.95 | 187.95 | 384.0 |
| 2023-11-15 06:20:00 | AAPL | Stock | 187.95 | 187.96 | 187.95 | 187.96 | 515.0 |
| 2023-11-15 06:30:00 | AAPL | Stock | 188.0 | 188.0 | 188.0 | 188.0 | 250.0 |
| 2023-11-15 06:35:00 | AAPL | Stock | 188.09 | 188.09 | 188.07 | 188.07 | 300.0 |
| 2023-11-15 06:40:00 | AAPL | Stock | 188.05 | 188.05 | 188.0 | 188.0 | 646.0 |
| 2023-11-15 06:55:00 | AAPL | Stock | 188.0 | 188.0 | 188.0 | 188.0 | 677.0 |
| 2023-11-15 07:00:00 | AAPL | Stock | 187.97 | 188.38 | 187.97 | 188.38 | 10692.0 |
| 2023-11-15 07:05:00 | AAPL | Stock | 188.37 | 188.4 | 188.29 | 188.29 | 3073.0 |
| 2023-11-15 07:10:00 | AAPL | Stock | 188.36 | 188.52 | 188.34 | 188.46 | 6161.0 |
| 2023-11-15 07:15:00 | AAPL | Stock | 188.46 | 188.46 | 188.39 | 188.4 | 16772.0 |
| 2023-11-15 07:20:00 | AAPL | Stock | 188.4 | 188.4 | 188.21 | 188.29 | 6221.0 |
| 2023-11-15 07:25:00 | AAPL | Stock | 188.25 | 188.25 | 188.25 | 188.25 | 3795.0 |
| 2023-11-15 07:30:00 | AAPL | Stock | 188.27 | 188.32 | 188.25 | 188.32 | 4634.0 |
| 2023-11-15 07:35:00 | AAPL | Stock | 188.32 | 188.32 | 188.27 | 188.27 | 1187.0 |
| 2023-11-15 07:40:00 | AAPL | Stock | 188.22 | 188.25 | 188.22 | 188.25 | 3130.0 |
| 2023-11-15 07:45:00 | AAPL | Stock | 188.27 | 188.3 | 188.25 | 188.29 | 12663.0 |
| 2023-11-15 07:50:00 | AAPL | Stock | 188.22 | 188.23 | 188.15 | 188.22 | 15040.0 |
| 2023-11-15 07:55:00 | AAPL | Stock | 188.22 | 188.3 | 188.22 | 188.3 | 1650.0 |
| 2023-11-15 08:00:00 | AAPL | Stock | 188.1009 | 188.5 | 187.48 | 188.27 | 71283.0 |
| 2023-11-15 08:05:00 | AAPL | Stock | 188.27 | 188.27 | 188.194 | 188.21 | 1951.0 |
| 2023-11-15 08:10:00 | AAPL | Stock | 188.2 | 188.2 | 188.15 | 188.15 | 3226.0 |
| 2023-11-15 08:15:00 | AAPL | Stock | 188.19 | 188.22 | 188.13 | 188.22 | 1931.0 |
| 2023-11-15 08:20:00 | AAPL | Stock | 188.23 | 188.38 | 188.23 | 188.38 | 9007.0 |
| 2023-11-15 08:25:00 | AAPL | Stock | 188.36 | 188.4 | 188.32 | 188.3599 | 4717.0 |
| 2023-11-15 08:30:00 | AAPL | Stock | 188.36 | 188.88 | 188.065 | 188.15 | 34224.0 |
| 2023-11-15 08:35:00 | AAPL | Stock | 188.15 | 188.2 | 187.61 | 187.73 | 36863.0 |
| 2023-11-15 08:40:00 | AAPL | Stock | 187.78 | 187.98 | 187.65 | 187.73 | 13553.0 |
| 2023-11-15 08:45:00 | AAPL | Stock | 187.7 | 187.9 | 187.44 | 187.9 | 18385.0 |
| 2023-11-15 08:50:00 | AAPL | Stock | 187.92 | 187.94 | 187.742 | 187.91 | 5559.0 |
| 2023-11-15 08:55:00 | AAPL | Stock | 187.9 | 187.9099 | 187.75 | 187.86 | 6715.0 |
| 2023-11-15 09:00:00 | AAPL | Stock | 187.89 | 187.98 | 187.84 | 187.91 | 10206.0 |
| 2023-11-15 09:05:00 | AAPL | Stock | 187.96 | 187.99 | 187.88 | 187.93 | 6113.0 |
| 2023-11-15 09:10:00 | AAPL | Stock | 187.92 | 187.96 | 187.8 | 187.8 | 8888.0 |
> showing 50 of 411,954 rows — these rows as CSV