PREVIEW / etf_5min / 2021-11-22
file: by_date/etf_5min/2021/2021-11-22.parquet size: 1.9 MB rows: 90,775
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-11-22 04:00:00 | SPY | ETF | 470.03 | 470.46 | 470.03 | 470.46 | 3205.0 |
| 2021-11-22 04:05:00 | SPY | ETF | 470.52 | 470.6 | 470.48 | 470.48 | 2003.0 |
| 2021-11-22 04:10:00 | SPY | ETF | 470.5 | 470.57 | 470.5 | 470.56 | 780.0 |
| 2021-11-22 04:15:00 | SPY | ETF | 470.51 | 470.52 | 470.51 | 470.52 | 200.0 |
| 2021-11-22 04:25:00 | SPY | ETF | 470.61 | 470.72 | 470.61 | 470.71 | 1596.0 |
| 2021-11-22 04:30:00 | SPY | ETF | 470.71 | 470.71 | 470.63 | 470.63 | 1655.0 |
| 2021-11-22 04:35:00 | SPY | ETF | 470.66 | 470.66 | 470.66 | 470.66 | 168.0 |
| 2021-11-22 04:40:00 | SPY | ETF | 470.51 | 470.51 | 470.46 | 470.46 | 1136.0 |
| 2021-11-22 04:45:00 | SPY | ETF | 470.48 | 470.48 | 470.44 | 470.44 | 800.0 |
| 2021-11-22 04:50:00 | SPY | ETF | 470.36 | 470.48 | 470.36 | 470.48 | 700.0 |
| 2021-11-22 05:00:00 | SPY | ETF | 470.56 | 470.56 | 470.56 | 470.56 | 165.0 |
| 2021-11-22 05:05:00 | SPY | ETF | 470.6 | 470.6 | 470.6 | 470.6 | 100.0 |
| 2021-11-22 05:10:00 | SPY | ETF | 470.82 | 470.82 | 470.71 | 470.71 | 830.0 |
| 2021-11-22 05:15:00 | SPY | ETF | 470.71 | 470.71 | 470.71 | 470.71 | 900.0 |
| 2021-11-22 05:25:00 | SPY | ETF | 470.69 | 470.7 | 470.6 | 470.6 | 722.0 |
| 2021-11-22 05:30:00 | SPY | ETF | 470.63 | 470.63 | 470.63 | 470.63 | 1100.0 |
| 2021-11-22 05:35:00 | SPY | ETF | 470.55 | 470.61 | 470.55 | 470.57 | 1173.0 |
| 2021-11-22 05:40:00 | SPY | ETF | 470.6 | 470.6 | 470.6 | 470.6 | 300.0 |
| 2021-11-22 05:45:00 | SPY | ETF | 470.59 | 470.59 | 470.56 | 470.56 | 795.0 |
| 2021-11-22 05:50:00 | SPY | ETF | 470.51 | 470.57 | 470.42 | 470.55 | 1600.0 |
| 2021-11-22 06:00:00 | SPY | ETF | 470.66 | 470.66 | 470.66 | 470.66 | 100.0 |
| 2021-11-22 06:05:00 | SPY | ETF | 470.68 | 470.69 | 470.68 | 470.69 | 200.0 |
| 2021-11-22 06:10:00 | SPY | ETF | 470.74 | 470.74 | 470.74 | 470.74 | 214.0 |
| 2021-11-22 06:15:00 | SPY | ETF | 470.77 | 470.85 | 470.73 | 470.84 | 2467.0 |
| 2021-11-22 06:20:00 | SPY | ETF | 470.86 | 470.87 | 470.82 | 470.82 | 1900.0 |
| 2021-11-22 06:25:00 | SPY | ETF | 470.8 | 470.83 | 470.73 | 470.78 | 4016.0 |
| 2021-11-22 06:30:00 | SPY | ETF | 470.69 | 470.69 | 470.69 | 470.69 | 100.0 |
| 2021-11-22 06:35:00 | SPY | ETF | 470.89 | 471.03 | 470.89 | 471.03 | 474.0 |
| 2021-11-22 06:40:00 | SPY | ETF | 471.11 | 471.16 | 470.89 | 470.92 | 4128.0 |
| 2021-11-22 06:45:00 | SPY | ETF | 470.92 | 470.95 | 470.92 | 470.94 | 21000.0 |
| 2021-11-22 06:50:00 | SPY | ETF | 470.78 | 470.78 | 470.36 | 470.42 | 5463.0 |
| 2021-11-22 06:55:00 | SPY | ETF | 470.47 | 470.55 | 470.32 | 470.44 | 18525.0 |
| 2021-11-22 07:00:00 | SPY | ETF | 470.33 | 470.61 | 470.32 | 470.5 | 9865.0 |
| 2021-11-22 07:05:00 | SPY | ETF | 470.58 | 470.6 | 470.5 | 470.5 | 4100.0 |
| 2021-11-22 07:10:00 | SPY | ETF | 470.49 | 470.52 | 470.37 | 470.37 | 11639.0 |
| 2021-11-22 07:15:00 | SPY | ETF | 470.37 | 470.47 | 470.24 | 470.24 | 9302.0 |
| 2021-11-22 07:20:00 | SPY | ETF | 470.25 | 470.32 | 470.12 | 470.27 | 9033.0 |
| 2021-11-22 07:25:00 | SPY | ETF | 470.27 | 470.27 | 470.19 | 470.26 | 1943.0 |
| 2021-11-22 07:30:00 | SPY | ETF | 470.23 | 470.41 | 470.18 | 470.33 | 10614.0 |
| 2021-11-22 07:35:00 | SPY | ETF | 470.33 | 470.38 | 470.31 | 470.34 | 16017.0 |
| 2021-11-22 07:40:00 | SPY | ETF | 470.39 | 470.42 | 470.34 | 470.36 | 32780.0 |
| 2021-11-22 07:45:00 | SPY | ETF | 470.36 | 470.48 | 470.34 | 470.41 | 9833.0 |
| 2021-11-22 07:50:00 | SPY | ETF | 470.44 | 470.45 | 470.34 | 470.36 | 16699.0 |
| 2021-11-22 07:55:00 | SPY | ETF | 470.35 | 470.35 | 470.17 | 470.27 | 5248.0 |
| 2021-11-22 08:00:00 | SPY | ETF | 470.27 | 470.7296 | 469.241 | 470.2 | 37394.0 |
| 2021-11-22 08:05:00 | SPY | ETF | 470.28 | 470.28 | 470.05 | 470.05 | 26810.0 |
| 2021-11-22 08:10:00 | SPY | ETF | 470.09 | 470.17 | 469.97 | 469.97 | 13327.0 |
| 2021-11-22 08:15:00 | SPY | ETF | 469.97 | 469.97 | 469.8 | 469.84 | 43017.0 |
| 2021-11-22 08:20:00 | SPY | ETF | 469.83 | 469.95 | 469.81 | 469.91 | 3914.0 |
| 2021-11-22 08:25:00 | SPY | ETF | 469.93 | 470.04 | 469.93 | 470.03 | 9600.0 |
> showing 50 of 90,775 rows — these rows as CSV