PREVIEW / etf_5min / 2021-11-26
file: by_date/etf_5min/2021/2021-11-26.parquet size: 1.3 MB rows: 62,303
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 |
|---|---|---|---|---|---|---|---|
| 2021-11-26 04:00:00 | SPY | ETF | 465.0 | 465.0 | 460.8 | 460.94 | 107127.0 |
| 2021-11-26 04:05:00 | SPY | ETF | 461.0 | 461.25 | 460.17 | 460.57 | 13784.0 |
| 2021-11-26 04:10:00 | SPY | ETF | 460.58 | 461.52 | 460.52 | 461.5 | 19671.0 |
| 2021-11-26 04:15:00 | SPY | ETF | 461.35 | 461.56 | 460.54 | 460.59 | 26706.0 |
| 2021-11-26 04:20:00 | SPY | ETF | 460.81 | 461.27 | 460.79 | 460.79 | 15330.0 |
| 2021-11-26 04:25:00 | SPY | ETF | 460.76 | 460.98 | 460.3 | 460.35 | 11936.0 |
| 2021-11-26 04:30:00 | SPY | ETF | 460.33 | 460.6 | 460.17 | 460.17 | 23388.0 |
| 2021-11-26 04:35:00 | SPY | ETF | 460.1 | 460.71 | 459.75 | 460.71 | 25822.0 |
| 2021-11-26 04:40:00 | SPY | ETF | 460.75 | 460.87 | 460.56 | 460.72 | 10541.0 |
| 2021-11-26 04:45:00 | SPY | ETF | 460.85 | 461.2 | 460.62 | 460.62 | 2489.0 |
| 2021-11-26 04:50:00 | SPY | ETF | 460.75 | 460.96 | 460.33 | 460.77 | 6074.0 |
| 2021-11-26 04:55:00 | SPY | ETF | 460.52 | 460.87 | 460.52 | 460.63 | 7997.0 |
| 2021-11-26 05:00:00 | SPY | ETF | 460.95 | 461.41 | 460.77 | 461.28 | 12225.0 |
| 2021-11-26 05:05:00 | SPY | ETF | 461.36 | 461.42 | 461.07 | 461.42 | 12503.0 |
| 2021-11-26 05:10:00 | SPY | ETF | 461.43 | 461.69 | 461.42 | 461.6 | 39269.0 |
| 2021-11-26 05:15:00 | SPY | ETF | 461.58 | 461.64 | 461.05 | 461.06 | 43378.0 |
| 2021-11-26 05:20:00 | SPY | ETF | 460.9 | 461.5 | 460.9 | 461.5 | 7951.0 |
| 2021-11-26 05:25:00 | SPY | ETF | 461.41 | 461.8 | 461.4 | 461.66 | 3851.0 |
| 2021-11-26 05:30:00 | SPY | ETF | 461.71 | 461.76 | 461.05 | 461.19 | 8058.0 |
| 2021-11-26 05:35:00 | SPY | ETF | 461.05 | 461.11 | 460.96 | 461.11 | 3570.0 |
| 2021-11-26 05:40:00 | SPY | ETF | 460.99 | 461.02 | 460.7 | 460.88 | 9912.0 |
| 2021-11-26 05:45:00 | SPY | ETF | 460.9 | 460.9 | 460.52 | 460.52 | 3365.0 |
| 2021-11-26 05:50:00 | SPY | ETF | 460.5 | 460.84 | 460.12 | 460.84 | 6734.0 |
| 2021-11-26 05:55:00 | SPY | ETF | 460.8 | 461.18 | 460.72 | 461.16 | 5862.0 |
| 2021-11-26 06:00:00 | SPY | ETF | 460.94 | 461.25 | 460.85 | 461.25 | 23280.0 |
| 2021-11-26 06:05:00 | SPY | ETF | 461.37 | 461.98 | 461.35 | 461.89 | 25169.0 |
| 2021-11-26 06:10:00 | SPY | ETF | 461.79 | 461.89 | 461.33 | 461.6 | 39582.0 |
| 2021-11-26 06:15:00 | SPY | ETF | 461.64 | 461.9 | 461.5 | 461.58 | 22562.0 |
| 2021-11-26 06:20:00 | SPY | ETF | 461.75 | 461.95 | 461.44 | 461.44 | 12953.0 |
| 2021-11-26 06:25:00 | SPY | ETF | 461.65 | 461.65 | 461.57 | 461.64 | 4305.0 |
| 2021-11-26 06:30:00 | SPY | ETF | 461.41 | 461.41 | 460.93 | 460.93 | 11622.0 |
| 2021-11-26 06:35:00 | SPY | ETF | 460.9 | 461.05 | 460.74 | 460.98 | 6051.0 |
| 2021-11-26 06:40:00 | SPY | ETF | 461.02 | 461.54 | 461.0 | 461.39 | 26174.0 |
| 2021-11-26 06:45:00 | SPY | ETF | 461.38 | 461.5 | 461.12 | 461.2 | 48759.0 |
| 2021-11-26 06:50:00 | SPY | ETF | 461.15 | 461.39 | 461.03 | 461.06 | 8755.0 |
| 2021-11-26 06:55:00 | SPY | ETF | 461.25 | 461.25 | 460.94 | 461.16 | 5142.0 |
| 2021-11-26 07:00:00 | SPY | ETF | 461.07 | 461.85 | 461.02 | 461.8 | 43458.0 |
| 2021-11-26 07:05:00 | SPY | ETF | 461.8 | 462.0 | 461.6 | 461.88 | 48932.0 |
| 2021-11-26 07:10:00 | SPY | ETF | 461.95 | 462.41 | 461.75 | 462.15 | 69438.0 |
| 2021-11-26 07:15:00 | SPY | ETF | 462.19 | 462.27 | 462.0 | 462.15 | 60890.0 |
| 2021-11-26 07:20:00 | SPY | ETF | 462.12 | 462.35 | 461.9 | 461.9 | 41512.0 |
| 2021-11-26 07:25:00 | SPY | ETF | 461.85 | 461.93 | 461.35 | 461.57 | 101244.0 |
| 2021-11-26 07:30:00 | SPY | ETF | 461.52 | 462.12 | 461.52 | 461.72 | 131552.0 |
| 2021-11-26 07:35:00 | SPY | ETF | 461.67 | 461.95 | 461.54 | 461.78 | 102113.0 |
| 2021-11-26 07:40:00 | SPY | ETF | 461.74 | 461.9 | 461.6 | 461.79 | 186659.0 |
| 2021-11-26 07:45:00 | SPY | ETF | 461.81 | 462.28 | 461.81 | 462.22 | 33460.0 |
| 2021-11-26 07:50:00 | SPY | ETF | 462.08 | 462.1 | 461.75 | 461.75 | 123719.0 |
| 2021-11-26 07:55:00 | SPY | ETF | 461.78 | 461.93 | 461.54 | 461.59 | 120647.0 |
| 2021-11-26 08:00:00 | SPY | ETF | 461.6199 | 465.39 | 459.6 | 461.5 | 257256.0 |
| 2021-11-26 08:05:00 | SPY | ETF | 461.54 | 462.1 | 461.42 | 461.92 | 129521.0 |
> showing 50 of 62,303 rows — these rows as CSV