PREVIEW / etf_5min / 2022-04-21
file: by_date/etf_5min/2022/2022-04-21.parquet size: 2.1 MB rows: 98,436
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-04-21 04:00:00 | SPY | ETF | 447.94 | 448.22 | 447.85 | 448.16 | 7632.0 |
| 2022-04-21 04:05:00 | SPY | ETF | 448.14 | 448.3 | 448.09 | 448.3 | 2179.0 |
| 2022-04-21 04:10:00 | SPY | ETF | 448.13 | 448.26 | 448.13 | 448.26 | 3620.0 |
| 2022-04-21 04:15:00 | SPY | ETF | 448.29 | 448.43 | 448.21 | 448.33 | 3289.0 |
| 2022-04-21 04:20:00 | SPY | ETF | 448.18 | 448.18 | 448.09 | 448.14 | 1898.0 |
| 2022-04-21 04:25:00 | SPY | ETF | 448.01 | 448.05 | 447.99 | 448.05 | 3500.0 |
| 2022-04-21 04:30:00 | SPY | ETF | 448.09 | 448.11 | 448.01 | 448.01 | 700.0 |
| 2022-04-21 04:35:00 | SPY | ETF | 447.98 | 448.03 | 447.98 | 448.03 | 3466.0 |
| 2022-04-21 04:40:00 | SPY | ETF | 448.09 | 448.09 | 448.09 | 448.09 | 100.0 |
| 2022-04-21 04:45:00 | SPY | ETF | 448.05 | 448.1 | 448.05 | 448.1 | 900.0 |
| 2022-04-21 04:50:00 | SPY | ETF | 448.1 | 448.37 | 448.1 | 448.36 | 600.0 |
| 2022-04-21 04:55:00 | SPY | ETF | 448.36 | 448.36 | 448.36 | 448.36 | 995.0 |
| 2022-04-21 05:00:00 | SPY | ETF | 448.38 | 448.38 | 447.8 | 447.8 | 1910.0 |
| 2022-04-21 05:05:00 | SPY | ETF | 447.73 | 447.9 | 447.73 | 447.9 | 1100.0 |
| 2022-04-21 05:10:00 | SPY | ETF | 447.94 | 447.94 | 447.93 | 447.93 | 200.0 |
| 2022-04-21 05:20:00 | SPY | ETF | 448.03 | 448.12 | 448.03 | 448.11 | 1200.0 |
| 2022-04-21 05:25:00 | SPY | ETF | 448.07 | 448.12 | 448.06 | 448.12 | 1527.0 |
| 2022-04-21 05:30:00 | SPY | ETF | 448.0 | 448.0 | 447.9 | 447.9 | 469.0 |
| 2022-04-21 05:35:00 | SPY | ETF | 447.82 | 447.82 | 447.55 | 447.69 | 1800.0 |
| 2022-04-21 05:40:00 | SPY | ETF | 447.8 | 447.8 | 447.75 | 447.75 | 552.0 |
| 2022-04-21 05:45:00 | SPY | ETF | 447.74 | 447.85 | 447.7 | 447.85 | 1998.0 |
| 2022-04-21 05:55:00 | SPY | ETF | 447.71 | 447.73 | 447.71 | 447.73 | 1998.0 |
| 2022-04-21 06:00:00 | SPY | ETF | 447.73 | 447.73 | 447.61 | 447.62 | 17900.0 |
| 2022-04-21 06:05:00 | SPY | ETF | 447.68 | 447.83 | 447.64 | 447.83 | 1481.0 |
| 2022-04-21 06:10:00 | SPY | ETF | 447.91 | 447.93 | 447.81 | 447.91 | 17995.0 |
| 2022-04-21 06:15:00 | SPY | ETF | 447.9 | 447.97 | 447.88 | 447.97 | 4200.0 |
| 2022-04-21 06:20:00 | SPY | ETF | 447.96 | 447.96 | 447.96 | 447.96 | 10400.0 |
| 2022-04-21 06:25:00 | SPY | ETF | 448.0 | 448.09 | 448.0 | 448.09 | 4500.0 |
| 2022-04-21 06:30:00 | SPY | ETF | 448.14 | 448.27 | 448.14 | 448.27 | 32681.0 |
| 2022-04-21 06:35:00 | SPY | ETF | 448.24 | 448.24 | 448.14 | 448.21 | 30337.0 |
| 2022-04-21 06:40:00 | SPY | ETF | 448.2 | 448.25 | 448.1 | 448.23 | 20655.0 |
| 2022-04-21 06:45:00 | SPY | ETF | 448.23 | 448.41 | 448.23 | 448.38 | 3863.0 |
| 2022-04-21 06:50:00 | SPY | ETF | 448.31 | 448.31 | 448.18 | 448.29 | 4578.0 |
| 2022-04-21 06:55:00 | SPY | ETF | 448.29 | 448.3 | 448.18 | 448.2 | 8239.0 |
| 2022-04-21 07:00:00 | SPY | ETF | 448.35 | 448.35 | 448.14 | 448.17 | 17726.0 |
| 2022-04-21 07:05:00 | SPY | ETF | 448.17 | 448.17 | 447.97 | 448.11 | 31993.0 |
| 2022-04-21 07:10:00 | SPY | ETF | 448.08 | 448.24 | 448.03 | 448.24 | 13744.0 |
| 2022-04-21 07:15:00 | SPY | ETF | 448.19 | 448.42 | 448.15 | 448.41 | 6615.0 |
| 2022-04-21 07:20:00 | SPY | ETF | 448.38 | 448.48 | 448.37 | 448.44 | 32757.0 |
| 2022-04-21 07:25:00 | SPY | ETF | 448.48 | 448.72 | 448.46 | 448.72 | 59470.0 |
| 2022-04-21 07:30:00 | SPY | ETF | 448.7 | 448.75 | 448.46 | 448.62 | 21640.0 |
| 2022-04-21 07:35:00 | SPY | ETF | 448.61 | 448.61 | 448.47 | 448.49 | 10596.0 |
| 2022-04-21 07:40:00 | SPY | ETF | 448.49 | 448.57 | 448.41 | 448.41 | 1528.0 |
| 2022-04-21 07:45:00 | SPY | ETF | 448.41 | 448.5 | 448.36 | 448.5 | 22458.0 |
| 2022-04-21 07:50:00 | SPY | ETF | 448.41 | 448.61 | 448.37 | 448.61 | 35712.0 |
| 2022-04-21 07:55:00 | SPY | ETF | 448.63 | 448.8 | 448.6 | 448.7 | 29209.0 |
| 2022-04-21 08:00:00 | SPY | ETF | 448.67 | 448.85 | 446.23 | 448.79 | 54340.0 |
| 2022-04-21 08:05:00 | SPY | ETF | 448.77 | 448.8 | 448.53 | 448.69 | 73490.0 |
| 2022-04-21 08:10:00 | SPY | ETF | 448.68 | 448.7 | 448.59 | 448.62 | 11675.0 |
| 2022-04-21 08:15:00 | SPY | ETF | 448.62 | 448.68 | 448.37 | 448.37 | 42960.0 |
> showing 50 of 98,436 rows — these rows as CSV