PREVIEW / etf_5min / 2022-10-19
file: by_date/etf_5min/2022/2022-10-19.parquet size: 2.0 MB rows: 95,695
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-19 04:00:00 | SPY | ETF | 371.79 | 372.93 | 371.0 | 371.7 | 14404.0 |
| 2022-10-19 04:05:00 | SPY | ETF | 371.6 | 371.71 | 371.35 | 371.35 | 10155.0 |
| 2022-10-19 04:10:00 | SPY | ETF | 371.37 | 371.37 | 370.94 | 371.0 | 3978.0 |
| 2022-10-19 04:15:00 | SPY | ETF | 370.94 | 370.94 | 370.55 | 370.55 | 14904.0 |
| 2022-10-19 04:20:00 | SPY | ETF | 370.6 | 370.6 | 370.04 | 370.28 | 8881.0 |
| 2022-10-19 04:25:00 | SPY | ETF | 370.16 | 370.16 | 370.0 | 370.1 | 6065.0 |
| 2022-10-19 04:30:00 | SPY | ETF | 370.25 | 370.67 | 370.25 | 370.58 | 2346.0 |
| 2022-10-19 04:35:00 | SPY | ETF | 370.69 | 370.69 | 370.24 | 370.24 | 800.0 |
| 2022-10-19 04:40:00 | SPY | ETF | 370.7 | 370.7 | 370.7 | 370.7 | 100.0 |
| 2022-10-19 04:45:00 | SPY | ETF | 370.71 | 370.71 | 370.45 | 370.56 | 2100.0 |
| 2022-10-19 04:50:00 | SPY | ETF | 370.46 | 370.97 | 370.42 | 370.89 | 4000.0 |
| 2022-10-19 04:55:00 | SPY | ETF | 370.75 | 370.93 | 370.6 | 370.93 | 1640.0 |
| 2022-10-19 05:00:00 | SPY | ETF | 370.83 | 371.13 | 370.77 | 371.03 | 3600.0 |
| 2022-10-19 05:05:00 | SPY | ETF | 371.1 | 371.38 | 371.1 | 371.38 | 1889.0 |
| 2022-10-19 05:10:00 | SPY | ETF | 371.68 | 371.68 | 371.47 | 371.5 | 2068.0 |
| 2022-10-19 05:15:00 | SPY | ETF | 371.63 | 371.65 | 371.5 | 371.5 | 3400.0 |
| 2022-10-19 05:20:00 | SPY | ETF | 371.35 | 371.35 | 371.35 | 371.35 | 300.0 |
| 2022-10-19 05:25:00 | SPY | ETF | 371.16 | 371.34 | 371.06 | 371.34 | 1300.0 |
| 2022-10-19 05:30:00 | SPY | ETF | 371.69 | 372.19 | 371.69 | 372.19 | 1700.0 |
| 2022-10-19 05:35:00 | SPY | ETF | 372.01 | 372.13 | 371.98 | 371.99 | 2579.0 |
| 2022-10-19 05:40:00 | SPY | ETF | 372.06 | 372.23 | 372.04 | 372.2 | 800.0 |
| 2022-10-19 05:45:00 | SPY | ETF | 372.12 | 372.29 | 372.04 | 372.26 | 2909.0 |
| 2022-10-19 05:50:00 | SPY | ETF | 372.17 | 372.59 | 372.17 | 372.55 | 3609.0 |
| 2022-10-19 05:55:00 | SPY | ETF | 372.69 | 372.99 | 372.68 | 372.94 | 12082.0 |
| 2022-10-19 06:00:00 | SPY | ETF | 373.0 | 373.07 | 372.66 | 372.8 | 5164.0 |
| 2022-10-19 06:05:00 | SPY | ETF | 372.73 | 372.78 | 372.7 | 372.7 | 5586.0 |
| 2022-10-19 06:10:00 | SPY | ETF | 372.75 | 372.75 | 372.26 | 372.31 | 10351.0 |
| 2022-10-19 06:15:00 | SPY | ETF | 372.37 | 372.65 | 372.37 | 372.55 | 4368.0 |
| 2022-10-19 06:20:00 | SPY | ETF | 372.59 | 372.59 | 372.12 | 372.2 | 9460.0 |
| 2022-10-19 06:25:00 | SPY | ETF | 372.25 | 372.25 | 371.75 | 371.75 | 6570.0 |
| 2022-10-19 06:30:00 | SPY | ETF | 371.73 | 371.99 | 371.67 | 371.99 | 4299.0 |
| 2022-10-19 06:35:00 | SPY | ETF | 371.87 | 371.97 | 371.48 | 371.48 | 3894.0 |
| 2022-10-19 06:40:00 | SPY | ETF | 371.46 | 371.46 | 370.67 | 370.67 | 29850.0 |
| 2022-10-19 06:45:00 | SPY | ETF | 370.65 | 370.99 | 370.64 | 370.83 | 13240.0 |
| 2022-10-19 06:50:00 | SPY | ETF | 371.04 | 371.2 | 371.01 | 371.04 | 8495.0 |
| 2022-10-19 06:55:00 | SPY | ETF | 371.01 | 371.06 | 370.9 | 370.94 | 18830.0 |
| 2022-10-19 07:00:00 | SPY | ETF | 371.24 | 371.67 | 371.21 | 371.62 | 68054.0 |
| 2022-10-19 07:05:00 | SPY | ETF | 371.58 | 371.64 | 371.24 | 371.28 | 25777.0 |
| 2022-10-19 07:10:00 | SPY | ETF | 371.27 | 371.3 | 370.0 | 370.14 | 78285.0 |
| 2022-10-19 07:15:00 | SPY | ETF | 370.25 | 370.45 | 369.5 | 369.63 | 103341.0 |
| 2022-10-19 07:20:00 | SPY | ETF | 369.61 | 370.12 | 369.6 | 369.85 | 111566.0 |
| 2022-10-19 07:25:00 | SPY | ETF | 369.81 | 369.82 | 369.09 | 369.33 | 50654.0 |
| 2022-10-19 07:30:00 | SPY | ETF | 369.1 | 369.28 | 368.99 | 369.18 | 48497.0 |
| 2022-10-19 07:35:00 | SPY | ETF | 369.14 | 369.72 | 369.14 | 369.6 | 19667.0 |
| 2022-10-19 07:40:00 | SPY | ETF | 369.6 | 369.6 | 369.09 | 369.25 | 46087.0 |
| 2022-10-19 07:45:00 | SPY | ETF | 369.25 | 369.73 | 369.05 | 369.73 | 53115.0 |
| 2022-10-19 07:50:00 | SPY | ETF | 369.81 | 369.87 | 369.39 | 369.46 | 80102.0 |
| 2022-10-19 07:55:00 | SPY | ETF | 369.44 | 369.96 | 369.44 | 369.93 | 68964.0 |
| 2022-10-19 08:00:00 | SPY | ETF | 371.48 | 373.9 | 369.03 | 371.0 | 141212.0 |
| 2022-10-19 08:05:00 | SPY | ETF | 369.15 | 369.27 | 368.33 | 368.7 | 89200.0 |
> showing 50 of 95,695 rows — these rows as CSV