PREVIEW / etf_5min / 2023-06-26
file: by_date/etf_5min/2023/2023-06-26.parquet size: 1.9 MB rows: 94,928
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-06-26 04:00:00 | SPY | ETF | 432.85 | 432.85 | 432.5 | 432.62 | 8505.0 |
| 2023-06-26 04:05:00 | SPY | ETF | 432.58 | 432.64 | 432.41 | 432.5 | 1770.0 |
| 2023-06-26 04:10:00 | SPY | ETF | 432.46 | 432.63 | 432.46 | 432.59 | 442.0 |
| 2023-06-26 04:15:00 | SPY | ETF | 432.49 | 432.61 | 432.37 | 432.37 | 1551.0 |
| 2023-06-26 04:20:00 | SPY | ETF | 432.43 | 432.45 | 432.3 | 432.3 | 1605.0 |
| 2023-06-26 04:25:00 | SPY | ETF | 432.35 | 432.35 | 432.16 | 432.16 | 2269.0 |
| 2023-06-26 04:30:00 | SPY | ETF | 432.15 | 432.5 | 432.0 | 432.5 | 84428.0 |
| 2023-06-26 04:35:00 | SPY | ETF | 432.5 | 432.81 | 432.48 | 432.8 | 127907.0 |
| 2023-06-26 04:40:00 | SPY | ETF | 432.65 | 432.65 | 432.37 | 432.37 | 870.0 |
| 2023-06-26 04:45:00 | SPY | ETF | 432.35 | 432.35 | 432.03 | 432.03 | 2500.0 |
| 2023-06-26 04:50:00 | SPY | ETF | 431.99 | 432.16 | 431.99 | 432.15 | 6436.0 |
| 2023-06-26 04:55:00 | SPY | ETF | 432.18 | 432.23 | 432.17 | 432.17 | 4885.0 |
| 2023-06-26 05:00:00 | SPY | ETF | 432.3 | 432.3 | 432.3 | 432.3 | 900.0 |
| 2023-06-26 05:05:00 | SPY | ETF | 432.31 | 432.41 | 432.31 | 432.4 | 1109.0 |
| 2023-06-26 05:10:00 | SPY | ETF | 432.37 | 432.48 | 432.37 | 432.41 | 1700.0 |
| 2023-06-26 05:15:00 | SPY | ETF | 432.45 | 432.57 | 432.45 | 432.55 | 601.0 |
| 2023-06-26 05:20:00 | SPY | ETF | 432.57 | 432.65 | 432.57 | 432.64 | 1430.0 |
| 2023-06-26 05:25:00 | SPY | ETF | 432.71 | 432.71 | 432.6 | 432.6 | 1714.0 |
| 2023-06-26 05:30:00 | SPY | ETF | 432.56 | 432.72 | 432.52 | 432.71 | 3979.0 |
| 2023-06-26 05:35:00 | SPY | ETF | 432.79 | 432.9 | 432.79 | 432.8 | 5380.0 |
| 2023-06-26 05:40:00 | SPY | ETF | 432.8 | 432.8 | 432.8 | 432.8 | 100.0 |
| 2023-06-26 05:45:00 | SPY | ETF | 432.88 | 432.92 | 432.79 | 432.79 | 2085.0 |
| 2023-06-26 05:50:00 | SPY | ETF | 432.87 | 432.87 | 432.87 | 432.87 | 388.0 |
| 2023-06-26 05:55:00 | SPY | ETF | 432.87 | 432.87 | 432.75 | 432.75 | 400.0 |
| 2023-06-26 06:00:00 | SPY | ETF | 432.72 | 432.75 | 432.68 | 432.68 | 520.0 |
| 2023-06-26 06:05:00 | SPY | ETF | 432.62 | 432.69 | 432.62 | 432.69 | 1255.0 |
| 2023-06-26 06:10:00 | SPY | ETF | 432.81 | 432.81 | 432.7 | 432.7 | 509.0 |
| 2023-06-26 06:15:00 | SPY | ETF | 432.68 | 432.74 | 432.68 | 432.74 | 1000.0 |
| 2023-06-26 06:20:00 | SPY | ETF | 432.76 | 432.76 | 432.59 | 432.59 | 1339.0 |
| 2023-06-26 06:25:00 | SPY | ETF | 432.57 | 432.6 | 432.56 | 432.6 | 2809.0 |
| 2023-06-26 06:35:00 | SPY | ETF | 432.5 | 432.72 | 432.5 | 432.68 | 1350.0 |
| 2023-06-26 06:40:00 | SPY | ETF | 432.61 | 432.78 | 432.61 | 432.78 | 1409.0 |
| 2023-06-26 06:45:00 | SPY | ETF | 432.84 | 432.84 | 432.64 | 432.69 | 6000.0 |
| 2023-06-26 06:50:00 | SPY | ETF | 432.6 | 432.68 | 432.6 | 432.64 | 1700.0 |
| 2023-06-26 06:55:00 | SPY | ETF | 432.57 | 432.61 | 432.55 | 432.55 | 808.0 |
| 2023-06-26 07:00:00 | SPY | ETF | 432.59 | 432.59 | 432.5 | 432.5 | 2498.0 |
| 2023-06-26 07:05:00 | SPY | ETF | 432.5 | 432.51 | 432.45 | 432.5 | 2881.0 |
| 2023-06-26 07:10:00 | SPY | ETF | 432.62 | 432.69 | 432.5 | 432.64 | 7419.0 |
| 2023-06-26 07:15:00 | SPY | ETF | 432.67 | 432.68 | 432.67 | 432.68 | 1020.0 |
| 2023-06-26 07:20:00 | SPY | ETF | 432.68 | 432.85 | 432.68 | 432.75 | 8710.0 |
| 2023-06-26 07:25:00 | SPY | ETF | 432.68 | 432.75 | 432.61 | 432.75 | 6273.0 |
| 2023-06-26 07:30:00 | SPY | ETF | 432.75 | 432.75 | 432.59 | 432.63 | 1893.0 |
| 2023-06-26 07:35:00 | SPY | ETF | 432.71 | 432.77 | 432.7 | 432.77 | 2178.0 |
| 2023-06-26 07:40:00 | SPY | ETF | 432.75 | 432.85 | 432.75 | 432.85 | 3835.0 |
| 2023-06-26 07:45:00 | SPY | ETF | 432.86 | 433.03 | 432.82 | 433.02 | 17374.0 |
| 2023-06-26 07:50:00 | SPY | ETF | 432.96 | 433.13 | 432.96 | 433.08 | 9414.0 |
| 2023-06-26 07:55:00 | SPY | ETF | 433.02 | 433.15 | 432.99 | 432.99 | 13385.0 |
| 2023-06-26 08:00:00 | SPY | ETF | 432.57 | 434.37 | 432.0 | 432.88 | 44761.0 |
| 2023-06-26 08:05:00 | SPY | ETF | 432.88 | 432.88 | 432.68 | 432.69 | 8544.0 |
| 2023-06-26 08:10:00 | SPY | ETF | 432.83 | 432.97 | 432.82 | 432.86 | 13987.0 |
> showing 50 of 94,928 rows — these rows as CSV