PREVIEW / etf_5min / 2021-06-22
file: by_date/etf_5min/2021/2021-06-22.parquet size: 1.7 MB rows: 79,817
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 |
|---|---|---|---|---|---|---|---|
| 2021-06-22 04:00:00 | SPY | ETF | 420.74 | 420.74 | 420.29 | 420.59 | 5151.0 |
| 2021-06-22 04:05:00 | SPY | ETF | 420.6 | 420.6 | 420.38 | 420.38 | 2598.0 |
| 2021-06-22 04:10:00 | SPY | ETF | 420.54 | 420.54 | 420.41 | 420.41 | 1450.0 |
| 2021-06-22 04:15:00 | SPY | ETF | 420.21 | 420.43 | 420.21 | 420.43 | 1000.0 |
| 2021-06-22 04:20:00 | SPY | ETF | 420.46 | 420.46 | 420.46 | 420.46 | 200.0 |
| 2021-06-22 04:25:00 | SPY | ETF | 420.35 | 420.35 | 420.35 | 420.35 | 100.0 |
| 2021-06-22 04:30:00 | SPY | ETF | 420.31 | 420.36 | 420.28 | 420.28 | 835.0 |
| 2021-06-22 04:35:00 | SPY | ETF | 420.23 | 420.26 | 420.2 | 420.26 | 2024.0 |
| 2021-06-22 04:40:00 | SPY | ETF | 420.28 | 420.28 | 420.28 | 420.28 | 100.0 |
| 2021-06-22 04:45:00 | SPY | ETF | 420.26 | 420.34 | 420.24 | 420.34 | 4200.0 |
| 2021-06-22 04:50:00 | SPY | ETF | 420.24 | 420.24 | 420.07 | 420.07 | 697.0 |
| 2021-06-22 04:55:00 | SPY | ETF | 420.19 | 420.2 | 420.19 | 420.2 | 500.0 |
| 2021-06-22 05:00:00 | SPY | ETF | 420.35 | 420.35 | 420.33 | 420.33 | 1100.0 |
| 2021-06-22 05:05:00 | SPY | ETF | 420.4 | 420.4 | 420.3 | 420.4 | 1447.0 |
| 2021-06-22 05:10:00 | SPY | ETF | 420.53 | 420.61 | 420.53 | 420.61 | 1200.0 |
| 2021-06-22 05:15:00 | SPY | ETF | 420.58 | 420.58 | 420.58 | 420.58 | 200.0 |
| 2021-06-22 05:20:00 | SPY | ETF | 420.5 | 420.5 | 420.5 | 420.5 | 200.0 |
| 2021-06-22 05:25:00 | SPY | ETF | 420.65 | 420.7 | 420.61 | 420.61 | 15900.0 |
| 2021-06-22 05:30:00 | SPY | ETF | 420.7 | 420.7 | 420.5 | 420.5 | 1733.0 |
| 2021-06-22 05:35:00 | SPY | ETF | 420.5 | 420.5 | 420.3 | 420.3 | 1360.0 |
| 2021-06-22 05:40:00 | SPY | ETF | 420.28 | 420.3 | 420.17 | 420.3 | 4706.0 |
| 2021-06-22 05:45:00 | SPY | ETF | 420.28 | 420.28 | 420.28 | 420.28 | 200.0 |
| 2021-06-22 05:50:00 | SPY | ETF | 420.43 | 420.43 | 420.4 | 420.4 | 400.0 |
| 2021-06-22 05:55:00 | SPY | ETF | 420.34 | 420.36 | 420.31 | 420.36 | 1799.0 |
| 2021-06-22 06:00:00 | SPY | ETF | 420.4 | 420.72 | 420.4 | 420.72 | 700.0 |
| 2021-06-22 06:05:00 | SPY | ETF | 420.71 | 420.88 | 420.66 | 420.88 | 1550.0 |
| 2021-06-22 06:10:00 | SPY | ETF | 420.93 | 420.93 | 420.81 | 420.83 | 1300.0 |
| 2021-06-22 06:15:00 | SPY | ETF | 420.75 | 420.75 | 420.5 | 420.5 | 3064.0 |
| 2021-06-22 06:20:00 | SPY | ETF | 420.48 | 420.57 | 420.46 | 420.54 | 1901.0 |
| 2021-06-22 06:25:00 | SPY | ETF | 420.52 | 420.53 | 420.4 | 420.53 | 1400.0 |
| 2021-06-22 06:30:00 | SPY | ETF | 420.68 | 420.71 | 420.66 | 420.66 | 400.0 |
| 2021-06-22 06:35:00 | SPY | ETF | 420.69 | 420.69 | 420.69 | 420.69 | 1000.0 |
| 2021-06-22 06:40:00 | SPY | ETF | 420.66 | 420.81 | 420.66 | 420.81 | 920.0 |
| 2021-06-22 06:45:00 | SPY | ETF | 420.82 | 421.0 | 420.82 | 421.0 | 3003.0 |
| 2021-06-22 06:50:00 | SPY | ETF | 420.91 | 420.91 | 420.76 | 420.8 | 6480.0 |
| 2021-06-22 06:55:00 | SPY | ETF | 420.84 | 420.85 | 420.84 | 420.85 | 400.0 |
| 2021-06-22 07:00:00 | SPY | ETF | 420.89 | 421.02 | 420.83 | 421.02 | 9934.0 |
| 2021-06-22 07:05:00 | SPY | ETF | 421.15 | 421.41 | 421.15 | 421.35 | 7007.0 |
| 2021-06-22 07:10:00 | SPY | ETF | 421.28 | 421.37 | 421.2 | 421.29 | 10641.0 |
| 2021-06-22 07:15:00 | SPY | ETF | 421.32 | 421.32 | 421.17 | 421.24 | 6131.0 |
| 2021-06-22 07:20:00 | SPY | ETF | 421.23 | 421.38 | 421.22 | 421.32 | 10091.0 |
| 2021-06-22 07:25:00 | SPY | ETF | 421.3 | 421.42 | 421.25 | 421.42 | 4100.0 |
| 2021-06-22 07:30:00 | SPY | ETF | 421.44 | 421.57 | 421.37 | 421.4 | 20800.0 |
| 2021-06-22 07:35:00 | SPY | ETF | 421.37 | 421.39 | 421.25 | 421.25 | 4417.0 |
| 2021-06-22 07:40:00 | SPY | ETF | 421.26 | 421.39 | 421.25 | 421.38 | 5782.0 |
| 2021-06-22 07:45:00 | SPY | ETF | 421.38 | 421.45 | 421.26 | 421.32 | 7355.0 |
| 2021-06-22 07:50:00 | SPY | ETF | 421.34 | 421.39 | 421.31 | 421.39 | 5602.0 |
| 2021-06-22 07:55:00 | SPY | ETF | 421.42 | 421.5 | 421.34 | 421.5 | 14955.0 |
| 2021-06-22 08:00:00 | SPY | ETF | 421.29 | 421.65 | 420.5 | 421.38 | 39085.0 |
| 2021-06-22 08:05:00 | SPY | ETF | 421.45 | 421.63 | 420.86 | 421.4 | 17788.0 |
> showing 50 of 79,817 rows — these rows as CSV