PREVIEW / etf_5min / 2022-10-04
file: by_date/etf_5min/2022/2022-10-04.parquet size: 2.1 MB rows: 102,941
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-10-04 04:00:00 | SPY | ETF | 372.0 | 372.07 | 369.18 | 371.95 | 37994.0 |
| 2022-10-04 04:05:00 | SPY | ETF | 372.0 | 372.07 | 371.92 | 371.94 | 7976.0 |
| 2022-10-04 04:10:00 | SPY | ETF | 372.04 | 372.06 | 371.89 | 372.02 | 2487.0 |
| 2022-10-04 04:15:00 | SPY | ETF | 371.91 | 371.95 | 371.81 | 371.85 | 3324.0 |
| 2022-10-04 04:20:00 | SPY | ETF | 371.82 | 371.85 | 371.6 | 371.61 | 10400.0 |
| 2022-10-04 04:25:00 | SPY | ETF | 371.65 | 371.65 | 371.51 | 371.57 | 3068.0 |
| 2022-10-04 04:30:00 | SPY | ETF | 371.71 | 371.85 | 371.65 | 371.85 | 3850.0 |
| 2022-10-04 04:35:00 | SPY | ETF | 371.75 | 371.97 | 371.75 | 371.93 | 4213.0 |
| 2022-10-04 04:40:00 | SPY | ETF | 371.95 | 372.12 | 371.5 | 371.5 | 10071.0 |
| 2022-10-04 04:45:00 | SPY | ETF | 371.51 | 371.75 | 371.51 | 371.75 | 3700.0 |
| 2022-10-04 04:50:00 | SPY | ETF | 371.86 | 371.95 | 371.73 | 371.75 | 12161.0 |
| 2022-10-04 04:55:00 | SPY | ETF | 371.89 | 372.01 | 371.86 | 372.01 | 5140.0 |
| 2022-10-04 05:00:00 | SPY | ETF | 372.06 | 372.06 | 371.87 | 371.87 | 1900.0 |
| 2022-10-04 05:05:00 | SPY | ETF | 371.86 | 371.94 | 371.31 | 371.35 | 6970.0 |
| 2022-10-04 05:10:00 | SPY | ETF | 371.42 | 371.42 | 371.0 | 371.0 | 10650.0 |
| 2022-10-04 05:15:00 | SPY | ETF | 371.09 | 371.33 | 371.04 | 371.33 | 2000.0 |
| 2022-10-04 05:20:00 | SPY | ETF | 371.28 | 371.46 | 371.28 | 371.4 | 1740.0 |
| 2022-10-04 05:25:00 | SPY | ETF | 371.53 | 371.99 | 371.53 | 371.97 | 5337.0 |
| 2022-10-04 05:30:00 | SPY | ETF | 371.92 | 371.93 | 371.19 | 371.5 | 5027.0 |
| 2022-10-04 05:35:00 | SPY | ETF | 371.51 | 371.71 | 371.47 | 371.71 | 2752.0 |
| 2022-10-04 05:40:00 | SPY | ETF | 371.69 | 372.03 | 371.69 | 371.99 | 4147.0 |
| 2022-10-04 05:45:00 | SPY | ETF | 371.75 | 371.82 | 371.66 | 371.82 | 1500.0 |
| 2022-10-04 05:50:00 | SPY | ETF | 371.98 | 372.3 | 371.98 | 372.26 | 5777.0 |
| 2022-10-04 05:55:00 | SPY | ETF | 372.23 | 372.44 | 372.19 | 372.43 | 8707.0 |
| 2022-10-04 06:00:00 | SPY | ETF | 372.4 | 372.4 | 372.17 | 372.3 | 5872.0 |
| 2022-10-04 06:05:00 | SPY | ETF | 372.29 | 372.4 | 372.12 | 372.4 | 5025.0 |
| 2022-10-04 06:10:00 | SPY | ETF | 372.4 | 372.8 | 372.4 | 372.65 | 8836.0 |
| 2022-10-04 06:15:00 | SPY | ETF | 372.62 | 373.12 | 372.55 | 373.12 | 14152.0 |
| 2022-10-04 06:20:00 | SPY | ETF | 373.13 | 373.23 | 373.0 | 373.19 | 9364.0 |
| 2022-10-04 06:25:00 | SPY | ETF | 373.15 | 373.3 | 373.02 | 373.29 | 32058.0 |
| 2022-10-04 06:30:00 | SPY | ETF | 373.24 | 373.55 | 373.1 | 373.32 | 21663.0 |
| 2022-10-04 06:35:00 | SPY | ETF | 373.28 | 373.39 | 373.1 | 373.1 | 5650.0 |
| 2022-10-04 06:40:00 | SPY | ETF | 373.2 | 373.33 | 373.15 | 373.33 | 3968.0 |
| 2022-10-04 06:45:00 | SPY | ETF | 373.25 | 373.29 | 372.99 | 373.0 | 20122.0 |
| 2022-10-04 06:50:00 | SPY | ETF | 373.05 | 373.05 | 372.79 | 372.79 | 26364.0 |
| 2022-10-04 06:55:00 | SPY | ETF | 372.9 | 372.94 | 372.65 | 372.78 | 11951.0 |
| 2022-10-04 07:00:00 | SPY | ETF | 372.8 | 372.8 | 372.45 | 372.46 | 61202.0 |
| 2022-10-04 07:05:00 | SPY | ETF | 372.45 | 372.64 | 372.3 | 372.55 | 28481.0 |
| 2022-10-04 07:10:00 | SPY | ETF | 372.58 | 372.68 | 372.35 | 372.45 | 18983.0 |
| 2022-10-04 07:15:00 | SPY | ETF | 372.35 | 372.649 | 372.3 | 372.59 | 14473.0 |
| 2022-10-04 07:20:00 | SPY | ETF | 372.6 | 372.6 | 372.16 | 372.25 | 28740.0 |
| 2022-10-04 07:25:00 | SPY | ETF | 372.15 | 372.29 | 372.1 | 372.17 | 11759.0 |
| 2022-10-04 07:30:00 | SPY | ETF | 372.31 | 372.53 | 372.27 | 372.53 | 63270.0 |
| 2022-10-04 07:35:00 | SPY | ETF | 372.5 | 372.66 | 372.36 | 372.49 | 10839.0 |
| 2022-10-04 07:40:00 | SPY | ETF | 372.35 | 372.56 | 372.34 | 372.56 | 11513.0 |
| 2022-10-04 07:45:00 | SPY | ETF | 372.55 | 372.6 | 372.27 | 372.27 | 23223.0 |
| 2022-10-04 07:50:00 | SPY | ETF | 372.34 | 372.81 | 372.27 | 372.7 | 85557.0 |
| 2022-10-04 07:55:00 | SPY | ETF | 372.7 | 372.81 | 372.47 | 372.71 | 26121.0 |
| 2022-10-04 08:00:00 | SPY | ETF | 372.6999 | 373.4204 | 369.45 | 372.86 | 190284.0 |
| 2022-10-04 08:05:00 | SPY | ETF | 372.86 | 372.88 | 372.73 | 372.79 | 58400.0 |
> showing 50 of 102,941 rows — these rows as CSV