PREVIEW / etf_5min / 2022-09-23
file: by_date/etf_5min/2022/2022-09-23.parquet size: 2.2 MB rows: 106,850
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-09-23 04:00:00 | SPY | ETF | 372.84 | 373.48 | 372.7 | 373.06 | 13023.0 |
| 2022-09-23 04:05:00 | SPY | ETF | 373.11 | 373.12 | 372.7 | 372.7 | 7130.0 |
| 2022-09-23 04:10:00 | SPY | ETF | 372.86 | 372.86 | 372.3 | 372.3 | 5199.0 |
| 2022-09-23 04:15:00 | SPY | ETF | 372.29 | 372.5 | 372.21 | 372.49 | 3071.0 |
| 2022-09-23 04:20:00 | SPY | ETF | 372.35 | 372.42 | 372.3 | 372.41 | 1650.0 |
| 2022-09-23 04:25:00 | SPY | ETF | 372.36 | 372.45 | 372.15 | 372.22 | 4455.0 |
| 2022-09-23 04:30:00 | SPY | ETF | 372.26 | 372.32 | 371.94 | 372.32 | 12458.0 |
| 2022-09-23 04:35:00 | SPY | ETF | 372.35 | 372.54 | 372.35 | 372.54 | 1200.0 |
| 2022-09-23 04:40:00 | SPY | ETF | 372.38 | 372.44 | 372.23 | 372.28 | 2660.0 |
| 2022-09-23 04:45:00 | SPY | ETF | 372.36 | 372.36 | 372.17 | 372.17 | 1340.0 |
| 2022-09-23 04:50:00 | SPY | ETF | 372.24 | 372.35 | 372.1 | 372.1 | 3752.0 |
| 2022-09-23 04:55:00 | SPY | ETF | 372.0 | 372.0 | 371.86 | 371.88 | 9171.0 |
| 2022-09-23 05:00:00 | SPY | ETF | 371.83 | 371.83 | 371.69 | 371.69 | 1530.0 |
| 2022-09-23 05:05:00 | SPY | ETF | 371.68 | 371.7 | 371.55 | 371.7 | 2770.0 |
| 2022-09-23 05:10:00 | SPY | ETF | 371.73 | 371.76 | 371.66 | 371.66 | 2509.0 |
| 2022-09-23 05:15:00 | SPY | ETF | 371.65 | 371.76 | 371.59 | 371.6 | 15399.0 |
| 2022-09-23 05:20:00 | SPY | ETF | 371.57 | 371.65 | 371.57 | 371.62 | 16200.0 |
| 2022-09-23 05:25:00 | SPY | ETF | 371.64 | 371.87 | 371.47 | 371.47 | 16608.0 |
| 2022-09-23 05:30:00 | SPY | ETF | 371.52 | 371.52 | 370.98 | 371.02 | 10147.0 |
| 2022-09-23 05:35:00 | SPY | ETF | 370.91 | 370.91 | 370.31 | 370.38 | 14302.0 |
| 2022-09-23 05:40:00 | SPY | ETF | 370.57 | 370.69 | 370.52 | 370.55 | 23528.0 |
| 2022-09-23 05:45:00 | SPY | ETF | 370.65 | 370.87 | 370.64 | 370.86 | 1700.0 |
| 2022-09-23 05:50:00 | SPY | ETF | 370.91 | 370.91 | 370.5 | 370.54 | 14490.0 |
| 2022-09-23 05:55:00 | SPY | ETF | 370.56 | 371.28 | 370.56 | 371.28 | 26890.0 |
| 2022-09-23 06:00:00 | SPY | ETF | 371.31 | 371.32 | 371.1 | 371.1 | 9737.0 |
| 2022-09-23 06:05:00 | SPY | ETF | 371.04 | 371.28 | 371.01 | 371.15 | 4150.0 |
| 2022-09-23 06:10:00 | SPY | ETF | 371.09 | 371.16 | 371.02 | 371.06 | 3864.0 |
| 2022-09-23 06:15:00 | SPY | ETF | 371.14 | 371.19 | 371.08 | 371.19 | 3142.0 |
| 2022-09-23 06:20:00 | SPY | ETF | 371.03 | 371.03 | 370.42 | 370.5 | 7834.0 |
| 2022-09-23 06:25:00 | SPY | ETF | 370.42 | 370.53 | 370.28 | 370.34 | 14161.0 |
| 2022-09-23 06:30:00 | SPY | ETF | 370.32 | 370.35 | 369.93 | 369.98 | 37981.0 |
| 2022-09-23 06:35:00 | SPY | ETF | 370.0 | 370.28 | 370.0 | 370.17 | 21007.0 |
| 2022-09-23 06:40:00 | SPY | ETF | 370.31 | 370.31 | 369.75 | 369.84 | 21494.0 |
| 2022-09-23 06:45:00 | SPY | ETF | 369.87 | 369.9 | 369.66 | 369.72 | 44846.0 |
| 2022-09-23 06:50:00 | SPY | ETF | 369.65 | 369.7 | 369.45 | 369.53 | 46017.0 |
| 2022-09-23 06:55:00 | SPY | ETF | 369.35 | 369.35 | 368.99 | 369.08 | 107175.0 |
| 2022-09-23 07:00:00 | SPY | ETF | 369.07 | 369.47 | 369.0 | 369.2 | 45494.0 |
| 2022-09-23 07:05:00 | SPY | ETF | 369.23 | 369.37 | 369.0 | 369.05 | 94992.0 |
| 2022-09-23 07:10:00 | SPY | ETF | 368.95 | 369.16 | 368.9 | 368.9 | 28470.0 |
| 2022-09-23 07:15:00 | SPY | ETF | 369.02 | 369.23 | 368.89 | 368.94 | 93342.0 |
| 2022-09-23 07:20:00 | SPY | ETF | 368.9 | 369.13 | 368.87 | 369.08 | 70258.0 |
| 2022-09-23 07:25:00 | SPY | ETF | 369.08 | 369.5 | 368.99 | 369.5 | 152994.0 |
| 2022-09-23 07:30:00 | SPY | ETF | 369.38 | 369.45 | 369.08 | 369.35 | 37051.0 |
| 2022-09-23 07:35:00 | SPY | ETF | 369.21 | 369.52 | 369.16 | 369.4 | 51008.0 |
| 2022-09-23 07:40:00 | SPY | ETF | 369.44 | 369.49 | 368.9 | 368.9 | 75500.0 |
| 2022-09-23 07:45:00 | SPY | ETF | 369.0 | 369.44 | 368.94 | 369.38 | 31762.0 |
| 2022-09-23 07:50:00 | SPY | ETF | 369.38 | 369.77 | 369.3 | 369.46 | 64597.0 |
| 2022-09-23 07:55:00 | SPY | ETF | 369.47 | 369.68 | 369.4 | 369.6 | 53015.0 |
| 2022-09-23 08:00:00 | SPY | ETF | 369.17 | 374.14 | 368.89 | 369.84 | 194173.0 |
| 2022-09-23 08:05:00 | SPY | ETF | 369.82 | 369.95 | 369.61 | 369.76 | 117956.0 |
> showing 50 of 106,850 rows — these rows as CSV