PREVIEW / etf_5min / 2022-11-28
file: by_date/etf_5min/2022/2022-11-28.parquet size: 2.0 MB rows: 95,211
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-28 04:00:00 | SPY | ETF | 400.91 | 400.91 | 399.19 | 399.93 | 9530.0 |
| 2022-11-28 04:05:00 | SPY | ETF | 399.91 | 399.91 | 399.7 | 399.78 | 5146.0 |
| 2022-11-28 04:10:00 | SPY | ETF | 399.85 | 399.88 | 399.73 | 399.73 | 4011.0 |
| 2022-11-28 04:15:00 | SPY | ETF | 399.7 | 400.0 | 399.7 | 400.0 | 2063.0 |
| 2022-11-28 04:20:00 | SPY | ETF | 400.01 | 400.1 | 399.94 | 399.95 | 1163.0 |
| 2022-11-28 04:25:00 | SPY | ETF | 400.0 | 400.0 | 399.7 | 399.76 | 4583.0 |
| 2022-11-28 04:30:00 | SPY | ETF | 399.61 | 399.61 | 399.46 | 399.46 | 4400.0 |
| 2022-11-28 04:35:00 | SPY | ETF | 399.42 | 399.73 | 399.35 | 399.73 | 3350.0 |
| 2022-11-28 04:40:00 | SPY | ETF | 399.66 | 399.66 | 399.46 | 399.46 | 200.0 |
| 2022-11-28 04:45:00 | SPY | ETF | 399.4 | 399.4 | 398.8 | 398.89 | 11588.0 |
| 2022-11-28 04:50:00 | SPY | ETF | 398.9 | 399.0 | 398.64 | 398.64 | 1500.0 |
| 2022-11-28 04:55:00 | SPY | ETF | 398.75 | 398.77 | 398.38 | 398.55 | 4600.0 |
| 2022-11-28 05:00:00 | SPY | ETF | 398.51 | 398.55 | 398.31 | 398.54 | 5600.0 |
| 2022-11-28 05:05:00 | SPY | ETF | 398.53 | 398.73 | 398.53 | 398.72 | 3700.0 |
| 2022-11-28 05:10:00 | SPY | ETF | 398.8 | 398.82 | 398.7 | 398.73 | 6325.0 |
| 2022-11-28 05:15:00 | SPY | ETF | 398.66 | 398.83 | 398.66 | 398.83 | 5919.0 |
| 2022-11-28 05:20:00 | SPY | ETF | 398.8 | 399.04 | 398.8 | 399.03 | 3095.0 |
| 2022-11-28 05:25:00 | SPY | ETF | 399.04 | 399.08 | 398.98 | 399.07 | 2000.0 |
| 2022-11-28 05:30:00 | SPY | ETF | 399.1 | 399.16 | 399.08 | 399.08 | 1400.0 |
| 2022-11-28 05:35:00 | SPY | ETF | 399.13 | 399.17 | 399.0 | 399.0 | 2000.0 |
| 2022-11-28 05:40:00 | SPY | ETF | 398.99 | 399.25 | 398.99 | 399.24 | 2300.0 |
| 2022-11-28 05:45:00 | SPY | ETF | 399.08 | 399.12 | 398.99 | 399.01 | 1730.0 |
| 2022-11-28 05:50:00 | SPY | ETF | 398.94 | 399.03 | 398.79 | 398.84 | 1995.0 |
| 2022-11-28 05:55:00 | SPY | ETF | 398.84 | 398.96 | 398.84 | 398.95 | 2100.0 |
| 2022-11-28 06:00:00 | SPY | ETF | 398.95 | 399.0 | 398.84 | 399.0 | 1999.0 |
| 2022-11-28 06:05:00 | SPY | ETF | 399.14 | 399.43 | 399.13 | 399.39 | 3610.0 |
| 2022-11-28 06:10:00 | SPY | ETF | 399.43 | 399.52 | 399.38 | 399.41 | 9440.0 |
| 2022-11-28 06:15:00 | SPY | ETF | 399.38 | 399.38 | 399.27 | 399.27 | 1811.0 |
| 2022-11-28 06:20:00 | SPY | ETF | 399.3 | 399.31 | 399.15 | 399.2 | 2604.0 |
| 2022-11-28 06:25:00 | SPY | ETF | 399.25 | 399.27 | 399.24 | 399.24 | 2719.0 |
| 2022-11-28 06:30:00 | SPY | ETF | 399.21 | 399.31 | 399.18 | 399.25 | 7677.0 |
| 2022-11-28 06:35:00 | SPY | ETF | 399.31 | 399.31 | 398.97 | 399.05 | 4702.0 |
| 2022-11-28 06:40:00 | SPY | ETF | 399.07 | 399.07 | 398.78 | 398.88 | 8224.0 |
| 2022-11-28 06:45:00 | SPY | ETF | 398.77 | 398.85 | 398.72 | 398.85 | 19391.0 |
| 2022-11-28 06:50:00 | SPY | ETF | 398.86 | 399.0 | 398.82 | 398.85 | 23957.0 |
| 2022-11-28 06:55:00 | SPY | ETF | 398.99 | 399.32 | 398.94 | 399.32 | 5888.0 |
| 2022-11-28 07:00:00 | SPY | ETF | 399.33 | 399.47 | 399.2 | 399.2 | 22244.0 |
| 2022-11-28 07:05:00 | SPY | ETF | 399.22 | 399.4 | 399.21 | 399.39 | 10632.0 |
| 2022-11-28 07:10:00 | SPY | ETF | 399.44 | 399.56 | 399.43 | 399.53 | 13199.0 |
| 2022-11-28 07:15:00 | SPY | ETF | 399.52 | 399.59 | 399.49 | 399.5 | 13184.0 |
| 2022-11-28 07:20:00 | SPY | ETF | 399.53 | 399.6 | 399.49 | 399.6 | 10537.0 |
| 2022-11-28 07:25:00 | SPY | ETF | 399.65 | 399.65 | 399.24 | 399.38 | 53303.0 |
| 2022-11-28 07:30:00 | SPY | ETF | 399.4 | 399.42 | 399.29 | 399.374 | 19388.0 |
| 2022-11-28 07:35:00 | SPY | ETF | 399.371 | 399.53 | 399.31 | 399.5 | 10481.0 |
| 2022-11-28 07:40:00 | SPY | ETF | 399.5 | 399.6 | 399.44 | 399.47 | 8103.0 |
| 2022-11-28 07:45:00 | SPY | ETF | 399.51 | 399.58 | 399.43 | 399.46 | 24529.0 |
| 2022-11-28 07:50:00 | SPY | ETF | 399.45 | 399.46 | 399.34 | 399.36 | 20015.0 |
| 2022-11-28 07:55:00 | SPY | ETF | 399.44 | 399.55 | 399.39 | 399.4 | 23309.0 |
| 2022-11-28 08:00:00 | SPY | ETF | 399.42 | 400.6 | 398.4596 | 399.22 | 56848.0 |
| 2022-11-28 08:05:00 | SPY | ETF | 399.18 | 399.48 | 399.18 | 399.37 | 28232.0 |
> showing 50 of 95,211 rows — these rows as CSV