PREVIEW / etf_5min / 2022-01-26
file: by_date/etf_5min/2022/2022-01-26.parquet size: 2.1 MB rows: 102,127
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-01-26 04:00:00 | SPY | ETF | 436.0 | 438.82 | 436.0 | 438.26 | 15412.0 |
| 2022-01-26 04:05:00 | SPY | ETF | 438.27 | 438.9 | 438.25 | 438.9 | 8870.0 |
| 2022-01-26 04:10:00 | SPY | ETF | 438.98 | 439.29 | 438.95 | 439.1 | 6910.0 |
| 2022-01-26 04:15:00 | SPY | ETF | 439.08 | 439.39 | 439.0 | 439.35 | 7208.0 |
| 2022-01-26 04:20:00 | SPY | ETF | 438.99 | 439.7 | 438.99 | 439.7 | 2147.0 |
| 2022-01-26 04:25:00 | SPY | ETF | 439.88 | 440.0 | 439.41 | 439.5 | 7342.0 |
| 2022-01-26 04:30:00 | SPY | ETF | 439.28 | 439.34 | 439.28 | 439.3 | 1300.0 |
| 2022-01-26 04:35:00 | SPY | ETF | 439.46 | 440.11 | 439.4 | 440.05 | 4209.0 |
| 2022-01-26 04:40:00 | SPY | ETF | 439.86 | 440.31 | 439.86 | 440.3 | 1293.0 |
| 2022-01-26 04:45:00 | SPY | ETF | 440.48 | 440.51 | 440.01 | 440.01 | 16279.0 |
| 2022-01-26 04:50:00 | SPY | ETF | 439.95 | 440.06 | 439.8 | 439.8 | 2165.0 |
| 2022-01-26 04:55:00 | SPY | ETF | 439.71 | 439.75 | 439.4 | 439.52 | 18828.0 |
| 2022-01-26 05:00:00 | SPY | ETF | 439.43 | 439.43 | 438.81 | 439.2 | 11562.0 |
| 2022-01-26 05:05:00 | SPY | ETF | 439.24 | 439.24 | 438.96 | 439.05 | 1693.0 |
| 2022-01-26 05:10:00 | SPY | ETF | 438.94 | 439.37 | 438.93 | 439.22 | 1100.0 |
| 2022-01-26 05:15:00 | SPY | ETF | 439.49 | 439.5 | 439.14 | 439.14 | 4731.0 |
| 2022-01-26 05:20:00 | SPY | ETF | 439.15 | 439.83 | 439.11 | 439.8 | 2758.0 |
| 2022-01-26 05:25:00 | SPY | ETF | 439.38 | 439.46 | 439.3 | 439.3 | 1900.0 |
| 2022-01-26 05:30:00 | SPY | ETF | 439.69 | 439.89 | 439.59 | 439.77 | 4268.0 |
| 2022-01-26 05:35:00 | SPY | ETF | 439.99 | 440.19 | 439.92 | 440.18 | 2167.0 |
| 2022-01-26 05:40:00 | SPY | ETF | 440.04 | 440.22 | 439.93 | 440.02 | 6237.0 |
| 2022-01-26 05:45:00 | SPY | ETF | 439.95 | 440.29 | 439.95 | 440.29 | 2413.0 |
| 2022-01-26 05:50:00 | SPY | ETF | 440.34 | 440.39 | 440.29 | 440.29 | 4993.0 |
| 2022-01-26 05:55:00 | SPY | ETF | 440.26 | 440.26 | 440.01 | 440.01 | 2200.0 |
| 2022-01-26 06:00:00 | SPY | ETF | 440.49 | 440.79 | 440.42 | 440.72 | 14050.0 |
| 2022-01-26 06:05:00 | SPY | ETF | 440.7 | 440.7 | 440.37 | 440.4 | 1959.0 |
| 2022-01-26 06:10:00 | SPY | ETF | 440.29 | 440.4 | 440.26 | 440.37 | 3052.0 |
| 2022-01-26 06:15:00 | SPY | ETF | 440.35 | 440.76 | 440.35 | 440.76 | 6134.0 |
| 2022-01-26 06:20:00 | SPY | ETF | 440.62 | 440.7 | 440.45 | 440.5 | 9260.0 |
| 2022-01-26 06:25:00 | SPY | ETF | 440.4 | 440.4 | 439.96 | 440.11 | 56860.0 |
| 2022-01-26 06:30:00 | SPY | ETF | 440.09 | 440.71 | 440.09 | 440.64 | 24450.0 |
| 2022-01-26 06:35:00 | SPY | ETF | 440.69 | 440.9 | 440.66 | 440.9 | 130356.0 |
| 2022-01-26 06:40:00 | SPY | ETF | 440.88 | 441.0 | 440.72 | 440.72 | 25782.0 |
| 2022-01-26 06:45:00 | SPY | ETF | 440.78 | 440.95 | 440.66 | 440.86 | 31013.0 |
| 2022-01-26 06:50:00 | SPY | ETF | 440.95 | 441.02 | 440.91 | 440.95 | 13629.0 |
| 2022-01-26 06:55:00 | SPY | ETF | 441.0 | 441.25 | 440.83 | 441.25 | 40683.0 |
| 2022-01-26 07:00:00 | SPY | ETF | 441.23 | 441.3 | 440.39 | 440.45 | 47250.0 |
| 2022-01-26 07:05:00 | SPY | ETF | 440.34 | 440.72 | 440.34 | 440.35 | 65167.0 |
| 2022-01-26 07:10:00 | SPY | ETF | 440.42 | 440.48 | 440.0 | 440.03 | 39353.0 |
| 2022-01-26 07:15:00 | SPY | ETF | 440.01 | 440.05 | 439.65 | 439.74 | 48284.0 |
| 2022-01-26 07:20:00 | SPY | ETF | 439.72 | 439.91 | 439.37 | 439.45 | 38403.0 |
| 2022-01-26 07:25:00 | SPY | ETF | 439.59 | 440.04 | 439.58 | 440.01 | 57311.0 |
| 2022-01-26 07:30:00 | SPY | ETF | 440.18 | 440.25 | 440.0 | 440.1 | 33501.0 |
| 2022-01-26 07:35:00 | SPY | ETF | 440.11 | 440.36 | 440.09 | 440.27 | 29613.0 |
| 2022-01-26 07:40:00 | SPY | ETF | 440.27 | 440.29 | 439.5 | 439.68 | 63786.0 |
| 2022-01-26 07:45:00 | SPY | ETF | 439.75 | 439.96 | 439.56 | 439.56 | 47104.0 |
| 2022-01-26 07:50:00 | SPY | ETF | 439.74 | 440.26 | 439.74 | 440.09 | 11033.0 |
| 2022-01-26 07:55:00 | SPY | ETF | 440.1 | 440.29 | 440.0 | 440.01 | 15100.0 |
| 2022-01-26 08:00:00 | SPY | ETF | 440.87 | 441.24 | 434.1 | 440.94 | 216262.0 |
| 2022-01-26 08:05:00 | SPY | ETF | 440.93 | 440.94 | 440.63 | 440.74 | 83459.0 |
> showing 50 of 102,127 rows — these rows as CSV