PREVIEW / stock_5min / 2024-11-01
file: by_date/stock_5min/2024/2024-11-01.parquet size: 6.7 MB rows: 400,192 symbols: 726
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-11-01 04:00:00 | AAPL | Stock | 222.27 | 223.0 | 222.27 | 222.79 | 7349.0 |
| 2024-11-01 04:05:00 | AAPL | Stock | 222.74 | 222.86 | 222.74 | 222.8 | 4364.0 |
| 2024-11-01 04:10:00 | AAPL | Stock | 222.82 | 223.22 | 222.76 | 223.18 | 9666.0 |
| 2024-11-01 04:15:00 | AAPL | Stock | 223.18 | 223.86 | 223.18 | 223.62 | 6971.0 |
| 2024-11-01 04:20:00 | AAPL | Stock | 223.59 | 223.59 | 223.28 | 223.37 | 2872.0 |
| 2024-11-01 04:25:00 | AAPL | Stock | 223.37 | 223.65 | 223.27 | 223.65 | 5098.0 |
| 2024-11-01 04:30:00 | AAPL | Stock | 223.56 | 223.65 | 223.51 | 223.51 | 2280.0 |
| 2024-11-01 04:35:00 | AAPL | Stock | 223.59 | 223.64 | 223.31 | 223.64 | 7769.0 |
| 2024-11-01 04:40:00 | AAPL | Stock | 223.58 | 223.68 | 223.4 | 223.41 | 4031.0 |
| 2024-11-01 04:45:00 | AAPL | Stock | 223.36 | 223.44 | 223.34 | 223.34 | 1710.0 |
| 2024-11-01 04:50:00 | AAPL | Stock | 223.28 | 223.28 | 223.21 | 223.22 | 2354.0 |
| 2024-11-01 04:55:00 | AAPL | Stock | 223.3 | 223.35 | 223.26 | 223.35 | 887.0 |
| 2024-11-01 05:00:00 | AAPL | Stock | 223.36 | 223.36 | 223.36 | 223.36 | 436.0 |
| 2024-11-01 05:05:00 | AAPL | Stock | 223.36 | 223.36 | 223.27 | 223.27 | 1428.0 |
| 2024-11-01 05:10:00 | AAPL | Stock | 223.34 | 223.6 | 223.25 | 223.6 | 3558.0 |
| 2024-11-01 05:15:00 | AAPL | Stock | 223.69 | 223.8 | 223.56 | 223.73 | 3511.0 |
| 2024-11-01 05:20:00 | AAPL | Stock | 223.75 | 223.75 | 223.72 | 223.72 | 539.0 |
| 2024-11-01 05:25:00 | AAPL | Stock | 223.73 | 223.75 | 223.61 | 223.61 | 1306.0 |
| 2024-11-01 05:30:00 | AAPL | Stock | 223.6 | 223.6 | 223.6 | 223.6 | 200.0 |
| 2024-11-01 05:35:00 | AAPL | Stock | 223.53 | 223.67 | 223.53 | 223.56 | 1104.0 |
| 2024-11-01 05:40:00 | AAPL | Stock | 223.58 | 223.58 | 223.46 | 223.46 | 1246.0 |
| 2024-11-01 05:45:00 | AAPL | Stock | 223.46 | 223.46 | 223.3 | 223.3 | 2350.0 |
| 2024-11-01 05:50:00 | AAPL | Stock | 223.27 | 223.29 | 223.21 | 223.29 | 1104.0 |
| 2024-11-01 05:55:00 | AAPL | Stock | 223.28 | 223.29 | 223.19 | 223.23 | 1346.0 |
| 2024-11-01 06:00:00 | AAPL | Stock | 223.2 | 223.2 | 223.1 | 223.1 | 1599.0 |
| 2024-11-01 06:05:00 | AAPL | Stock | 223.23 | 223.7 | 223.23 | 223.67 | 3711.0 |
| 2024-11-01 06:10:00 | AAPL | Stock | 223.68 | 223.71 | 223.6 | 223.6 | 2894.0 |
| 2024-11-01 06:15:00 | AAPL | Stock | 223.53 | 223.55 | 223.49 | 223.5 | 1451.0 |
| 2024-11-01 06:20:00 | AAPL | Stock | 223.54 | 223.66 | 223.53 | 223.56 | 2010.0 |
| 2024-11-01 06:25:00 | AAPL | Stock | 223.63 | 223.71 | 223.5 | 223.55 | 1000.0 |
| 2024-11-01 06:30:00 | AAPL | Stock | 223.55 | 223.55 | 223.55 | 223.55 | 530.0 |
| 2024-11-01 06:35:00 | AAPL | Stock | 223.55 | 223.69 | 223.29 | 223.36 | 11334.0 |
| 2024-11-01 06:40:00 | AAPL | Stock | 223.4 | 223.4 | 223.36 | 223.37 | 650.0 |
| 2024-11-01 06:45:00 | AAPL | Stock | 223.5 | 223.5 | 223.41 | 223.5 | 1001.0 |
| 2024-11-01 06:50:00 | AAPL | Stock | 223.42 | 223.5 | 223.42 | 223.47 | 1600.0 |
| 2024-11-01 06:55:00 | AAPL | Stock | 223.48 | 223.5 | 223.3 | 223.31 | 4787.0 |
| 2024-11-01 07:00:00 | AAPL | Stock | 223.31 | 223.4 | 222.61 | 222.65 | 35394.0 |
| 2024-11-01 07:05:00 | AAPL | Stock | 222.65 | 222.7 | 222.45 | 222.51 | 9362.0 |
| 2024-11-01 07:10:00 | AAPL | Stock | 222.5 | 222.51 | 222.09 | 222.25 | 16748.0 |
| 2024-11-01 07:15:00 | AAPL | Stock | 222.25 | 222.65 | 222.25 | 222.27 | 13358.0 |
| 2024-11-01 07:20:00 | AAPL | Stock | 222.23 | 222.4 | 222.06 | 222.26 | 10653.0 |
| 2024-11-01 07:25:00 | AAPL | Stock | 222.25 | 222.29 | 222.0 | 222.06 | 14622.0 |
| 2024-11-01 07:30:00 | AAPL | Stock | 222.03 | 222.03 | 221.96 | 221.98 | 5419.0 |
| 2024-11-01 07:35:00 | AAPL | Stock | 222.0 | 222.21 | 221.92 | 222.0 | 14827.0 |
| 2024-11-01 07:40:00 | AAPL | Stock | 221.92 | 221.92 | 221.6 | 221.9 | 18704.0 |
| 2024-11-01 07:45:00 | AAPL | Stock | 221.86 | 221.86 | 221.59 | 221.65 | 17353.0 |
| 2024-11-01 07:50:00 | AAPL | Stock | 221.77 | 222.17 | 221.69 | 221.99 | 12878.0 |
| 2024-11-01 07:55:00 | AAPL | Stock | 222.0 | 222.35 | 221.98 | 222.02 | 20442.0 |
| 2024-11-01 08:00:00 | AAPL | Stock | 222.74 | 223.36 | 221.59 | 222.21 | 139246.0 |
| 2024-11-01 08:05:00 | AAPL | Stock | 222.21 | 222.22 | 222.0 | 222.05 | 18086.0 |
> showing 50 of 400,192 rows — these rows as CSV