PREVIEW / etf_5min / 2024-01-31
file: by_date/etf_5min/2024/2024-01-31.parquet size: 2.3 MB rows: 113,548
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-01-31 04:00:00 | SPY | ETF | 489.15 | 489.5 | 489.15 | 489.43 | 2716.0 |
| 2024-01-31 04:05:00 | SPY | ETF | 489.24 | 489.29 | 489.23 | 489.25 | 4425.0 |
| 2024-01-31 04:10:00 | SPY | ETF | 489.2 | 489.2 | 489.14 | 489.14 | 1300.0 |
| 2024-01-31 04:15:00 | SPY | ETF | 489.08 | 489.08 | 488.8 | 488.8 | 800.0 |
| 2024-01-31 04:20:00 | SPY | ETF | 488.69 | 488.69 | 488.55 | 488.61 | 1790.0 |
| 2024-01-31 04:25:00 | SPY | ETF | 488.53 | 488.58 | 488.49 | 488.52 | 10175.0 |
| 2024-01-31 04:30:00 | SPY | ETF | 488.53 | 488.55 | 488.37 | 488.39 | 4196.0 |
| 2024-01-31 04:35:00 | SPY | ETF | 488.44 | 488.49 | 488.4 | 488.44 | 3017.0 |
| 2024-01-31 04:40:00 | SPY | ETF | 488.44 | 488.44 | 488.4 | 488.4 | 700.0 |
| 2024-01-31 04:45:00 | SPY | ETF | 488.57 | 488.79 | 488.55 | 488.79 | 3957.0 |
| 2024-01-31 04:50:00 | SPY | ETF | 488.84 | 488.84 | 488.66 | 488.69 | 2450.0 |
| 2024-01-31 04:55:00 | SPY | ETF | 488.72 | 488.72 | 488.55 | 488.55 | 4604.0 |
| 2024-01-31 05:00:00 | SPY | ETF | 488.58 | 488.58 | 488.51 | 488.51 | 602.0 |
| 2024-01-31 05:05:00 | SPY | ETF | 488.56 | 488.56 | 488.5 | 488.5 | 5500.0 |
| 2024-01-31 05:10:00 | SPY | ETF | 488.51 | 488.53 | 488.51 | 488.53 | 5000.0 |
| 2024-01-31 05:15:00 | SPY | ETF | 488.51 | 488.54 | 488.51 | 488.53 | 1150.0 |
| 2024-01-31 05:20:00 | SPY | ETF | 488.52 | 488.6 | 488.52 | 488.57 | 1300.0 |
| 2024-01-31 05:25:00 | SPY | ETF | 488.54 | 488.55 | 488.54 | 488.55 | 600.0 |
| 2024-01-31 05:30:00 | SPY | ETF | 488.5 | 488.5 | 488.48 | 488.48 | 531.0 |
| 2024-01-31 05:35:00 | SPY | ETF | 488.53 | 488.53 | 488.43 | 488.43 | 300.0 |
| 2024-01-31 05:40:00 | SPY | ETF | 488.4 | 488.46 | 488.4 | 488.46 | 5250.0 |
| 2024-01-31 05:45:00 | SPY | ETF | 488.46 | 488.54 | 488.46 | 488.53 | 1506.0 |
| 2024-01-31 05:50:00 | SPY | ETF | 488.52 | 488.52 | 488.47 | 488.49 | 1036.0 |
| 2024-01-31 05:55:00 | SPY | ETF | 488.51 | 488.51 | 488.51 | 488.51 | 255.0 |
| 2024-01-31 06:00:00 | SPY | ETF | 488.35 | 488.38 | 488.35 | 488.38 | 1506.0 |
| 2024-01-31 06:05:00 | SPY | ETF | 488.39 | 488.51 | 488.39 | 488.51 | 874.0 |
| 2024-01-31 06:10:00 | SPY | ETF | 488.55 | 488.57 | 488.5 | 488.57 | 10406.0 |
| 2024-01-31 06:15:00 | SPY | ETF | 488.59 | 488.7 | 488.59 | 488.7 | 6256.0 |
| 2024-01-31 06:20:00 | SPY | ETF | 488.8 | 488.8 | 488.8 | 488.8 | 243.0 |
| 2024-01-31 06:25:00 | SPY | ETF | 488.85 | 488.89 | 488.8 | 488.8 | 3924.0 |
| 2024-01-31 06:30:00 | SPY | ETF | 488.66 | 488.66 | 488.66 | 488.66 | 300.0 |
| 2024-01-31 06:35:00 | SPY | ETF | 488.81 | 488.81 | 488.73 | 488.77 | 1100.0 |
| 2024-01-31 06:40:00 | SPY | ETF | 488.61 | 488.71 | 488.61 | 488.71 | 1036.0 |
| 2024-01-31 06:45:00 | SPY | ETF | 488.75 | 488.78 | 488.74 | 488.78 | 652.0 |
| 2024-01-31 06:50:00 | SPY | ETF | 488.74 | 488.8 | 488.74 | 488.8 | 6285.0 |
| 2024-01-31 06:55:00 | SPY | ETF | 488.7 | 488.82 | 488.7 | 488.75 | 1304.0 |
| 2024-01-31 07:00:00 | SPY | ETF | 488.84 | 488.85 | 488.71 | 488.71 | 5721.0 |
| 2024-01-31 07:05:00 | SPY | ETF | 488.68 | 488.73 | 488.64 | 488.64 | 6414.0 |
| 2024-01-31 07:10:00 | SPY | ETF | 488.65 | 488.77 | 488.63 | 488.76 | 3698.0 |
| 2024-01-31 07:15:00 | SPY | ETF | 488.77 | 488.87 | 488.76 | 488.87 | 4649.0 |
| 2024-01-31 07:20:00 | SPY | ETF | 488.87 | 488.94 | 488.69 | 488.69 | 11731.0 |
| 2024-01-31 07:25:00 | SPY | ETF | 488.72 | 488.75 | 488.56 | 488.7 | 16716.0 |
| 2024-01-31 07:30:00 | SPY | ETF | 488.71 | 488.75 | 488.57 | 488.68 | 12585.0 |
| 2024-01-31 07:35:00 | SPY | ETF | 488.65 | 488.66 | 488.48 | 488.5 | 4711.0 |
| 2024-01-31 07:40:00 | SPY | ETF | 488.52 | 488.76 | 488.52 | 488.6 | 33567.0 |
| 2024-01-31 07:45:00 | SPY | ETF | 488.65 | 488.92 | 488.65 | 488.85 | 13926.0 |
| 2024-01-31 07:50:00 | SPY | ETF | 488.83 | 489.0 | 488.83 | 489.0 | 6304.0 |
| 2024-01-31 07:55:00 | SPY | ETF | 489.0 | 489.11 | 489.0 | 489.11 | 26845.0 |
| 2024-01-31 08:00:00 | SPY | ETF | 488.85 | 489.81 | 488.59 | 488.98 | 59368.0 |
| 2024-01-31 08:05:00 | SPY | ETF | 488.96 | 489.05 | 488.89 | 489.05 | 17767.0 |
> showing 50 of 113,548 rows — these rows as CSV