PREVIEW / etf_5min / 2022-11-01
file: by_date/etf_5min/2022/2022-11-01.parquet size: 2.0 MB rows: 100,161
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 |
|---|---|---|---|---|---|---|---|
| 2022-11-01 04:00:00 | SPY | ETF | 388.37 | 389.2 | 388.01 | 389.16 | 13747.0 |
| 2022-11-01 04:05:00 | SPY | ETF | 389.12 | 389.39 | 389.12 | 389.22 | 7506.0 |
| 2022-11-01 04:10:00 | SPY | ETF | 389.3 | 389.74 | 389.3 | 389.74 | 3076.0 |
| 2022-11-01 04:15:00 | SPY | ETF | 389.71 | 389.76 | 389.55 | 389.64 | 4364.0 |
| 2022-11-01 04:20:00 | SPY | ETF | 389.6 | 389.66 | 389.37 | 389.37 | 27316.0 |
| 2022-11-01 04:25:00 | SPY | ETF | 389.49 | 389.54 | 389.38 | 389.49 | 6622.0 |
| 2022-11-01 04:30:00 | SPY | ETF | 389.64 | 389.64 | 389.41 | 389.41 | 3220.0 |
| 2022-11-01 04:35:00 | SPY | ETF | 389.51 | 389.6 | 389.44 | 389.44 | 2232.0 |
| 2022-11-01 04:40:00 | SPY | ETF | 389.42 | 389.54 | 389.42 | 389.48 | 2700.0 |
| 2022-11-01 04:45:00 | SPY | ETF | 389.32 | 389.32 | 389.32 | 389.32 | 250.0 |
| 2022-11-01 04:50:00 | SPY | ETF | 389.28 | 389.39 | 389.28 | 389.39 | 200.0 |
| 2022-11-01 04:55:00 | SPY | ETF | 389.28 | 389.4 | 389.22 | 389.22 | 5170.0 |
| 2022-11-01 05:00:00 | SPY | ETF | 389.2 | 389.2 | 388.87 | 388.91 | 6126.0 |
| 2022-11-01 05:05:00 | SPY | ETF | 388.9 | 388.99 | 388.74 | 388.74 | 2550.0 |
| 2022-11-01 05:10:00 | SPY | ETF | 388.87 | 388.97 | 388.87 | 388.93 | 864.0 |
| 2022-11-01 05:15:00 | SPY | ETF | 388.8 | 389.06 | 388.68 | 389.0 | 35194.0 |
| 2022-11-01 05:20:00 | SPY | ETF | 389.05 | 389.17 | 389.01 | 389.04 | 13470.0 |
| 2022-11-01 05:25:00 | SPY | ETF | 388.85 | 389.04 | 388.78 | 389.04 | 700.0 |
| 2022-11-01 05:30:00 | SPY | ETF | 388.94 | 389.29 | 388.94 | 389.21 | 2930.0 |
| 2022-11-01 05:35:00 | SPY | ETF | 389.27 | 389.36 | 389.22 | 389.35 | 2750.0 |
| 2022-11-01 05:40:00 | SPY | ETF | 389.39 | 389.57 | 389.39 | 389.49 | 1975.0 |
| 2022-11-01 05:45:00 | SPY | ETF | 389.48 | 389.49 | 389.38 | 389.43 | 1878.0 |
| 2022-11-01 05:50:00 | SPY | ETF | 389.44 | 389.5 | 389.4 | 389.5 | 1600.0 |
| 2022-11-01 05:55:00 | SPY | ETF | 389.55 | 389.62 | 389.51 | 389.51 | 1300.0 |
| 2022-11-01 06:00:00 | SPY | ETF | 389.63 | 389.67 | 389.45 | 389.45 | 1840.0 |
| 2022-11-01 06:05:00 | SPY | ETF | 389.35 | 389.48 | 389.35 | 389.47 | 2000.0 |
| 2022-11-01 06:10:00 | SPY | ETF | 389.62 | 389.85 | 389.62 | 389.71 | 5050.0 |
| 2022-11-01 06:15:00 | SPY | ETF | 389.66 | 389.67 | 389.59 | 389.59 | 1600.0 |
| 2022-11-01 06:20:00 | SPY | ETF | 389.66 | 390.02 | 389.66 | 389.9 | 25145.0 |
| 2022-11-01 06:25:00 | SPY | ETF | 389.94 | 390.0 | 389.76 | 389.81 | 4220.0 |
| 2022-11-01 06:30:00 | SPY | ETF | 389.82 | 390.0 | 389.82 | 390.0 | 2403.0 |
| 2022-11-01 06:35:00 | SPY | ETF | 390.05 | 390.15 | 390.03 | 390.06 | 11128.0 |
| 2022-11-01 06:40:00 | SPY | ETF | 390.01 | 390.05 | 389.77 | 389.82 | 2529.0 |
| 2022-11-01 06:45:00 | SPY | ETF | 389.77 | 390.01 | 389.77 | 390.01 | 10631.0 |
| 2022-11-01 06:50:00 | SPY | ETF | 390.05 | 390.05 | 389.94 | 390.04 | 14700.0 |
| 2022-11-01 06:55:00 | SPY | ETF | 390.08 | 390.1 | 389.98 | 390.04 | 4200.0 |
| 2022-11-01 07:00:00 | SPY | ETF | 389.86 | 389.9 | 389.53 | 389.74 | 26149.0 |
| 2022-11-01 07:05:00 | SPY | ETF | 389.75 | 390.14 | 389.75 | 389.9 | 36837.0 |
| 2022-11-01 07:10:00 | SPY | ETF | 389.91 | 389.91 | 389.55 | 389.57 | 34552.0 |
| 2022-11-01 07:15:00 | SPY | ETF | 389.6 | 389.6 | 389.45 | 389.53 | 9000.0 |
| 2022-11-01 07:20:00 | SPY | ETF | 389.56 | 389.66 | 389.55 | 389.57 | 13530.0 |
| 2022-11-01 07:25:00 | SPY | ETF | 389.61 | 389.82 | 389.61 | 389.82 | 5868.0 |
| 2022-11-01 07:30:00 | SPY | ETF | 389.81 | 390.01 | 389.77 | 389.96 | 16663.0 |
| 2022-11-01 07:35:00 | SPY | ETF | 389.96 | 390.04 | 389.73 | 389.73 | 8012.0 |
| 2022-11-01 07:40:00 | SPY | ETF | 389.83 | 389.89 | 389.74 | 389.84 | 6881.0 |
| 2022-11-01 07:45:00 | SPY | ETF | 389.85 | 389.97 | 389.84 | 389.88 | 10873.0 |
| 2022-11-01 07:50:00 | SPY | ETF | 389.9 | 389.98 | 389.83 | 389.98 | 11800.0 |
| 2022-11-01 07:55:00 | SPY | ETF | 389.95 | 390.18 | 389.95 | 389.98 | 70371.0 |
| 2022-11-01 08:00:00 | SPY | ETF | 389.5625 | 390.32 | 387.6 | 387.88 | 293274.0 |
| 2022-11-01 08:05:00 | SPY | ETF | 389.79 | 389.99 | 389.75 | 389.95 | 27881.0 |
> showing 50 of 100,161 rows — these rows as CSV