PREVIEW / etf_5min / 2021-10-28
file: by_date/etf_5min/2021/2021-10-28.parquet size: 1.7 MB rows: 83,356
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-10-28 04:00:00 | SPY | ETF | 454.53 | 454.64 | 454.48 | 454.48 | 1550.0 |
| 2021-10-28 04:05:00 | SPY | ETF | 454.4 | 454.43 | 454.4 | 454.43 | 252.0 |
| 2021-10-28 04:10:00 | SPY | ETF | 454.4 | 454.42 | 454.4 | 454.42 | 768.0 |
| 2021-10-28 04:15:00 | SPY | ETF | 454.37 | 454.38 | 454.28 | 454.35 | 1755.0 |
| 2021-10-28 04:20:00 | SPY | ETF | 454.38 | 454.47 | 454.38 | 454.47 | 500.0 |
| 2021-10-28 04:25:00 | SPY | ETF | 454.45 | 454.57 | 454.45 | 454.46 | 869.0 |
| 2021-10-28 04:30:00 | SPY | ETF | 454.5 | 454.52 | 454.5 | 454.52 | 500.0 |
| 2021-10-28 04:35:00 | SPY | ETF | 454.6 | 454.65 | 454.6 | 454.65 | 6106.0 |
| 2021-10-28 04:40:00 | SPY | ETF | 454.64 | 454.93 | 454.64 | 454.93 | 1036.0 |
| 2021-10-28 04:45:00 | SPY | ETF | 454.89 | 455.0 | 454.84 | 454.98 | 6831.0 |
| 2021-10-28 04:50:00 | SPY | ETF | 455.02 | 455.02 | 454.91 | 454.91 | 1221.0 |
| 2021-10-28 04:55:00 | SPY | ETF | 455.0 | 455.04 | 454.87 | 454.87 | 300.0 |
| 2021-10-28 05:00:00 | SPY | ETF | 454.87 | 454.95 | 454.87 | 454.9 | 1200.0 |
| 2021-10-28 05:05:00 | SPY | ETF | 454.89 | 454.89 | 454.89 | 454.89 | 100.0 |
| 2021-10-28 05:10:00 | SPY | ETF | 454.92 | 454.92 | 454.84 | 454.84 | 1500.0 |
| 2021-10-28 05:15:00 | SPY | ETF | 454.8 | 454.8 | 454.62 | 454.62 | 608.0 |
| 2021-10-28 05:20:00 | SPY | ETF | 454.67 | 454.67 | 454.67 | 454.67 | 100.0 |
| 2021-10-28 05:25:00 | SPY | ETF | 454.62 | 454.67 | 454.62 | 454.67 | 773.0 |
| 2021-10-28 05:30:00 | SPY | ETF | 454.6 | 454.6 | 454.57 | 454.57 | 1300.0 |
| 2021-10-28 05:35:00 | SPY | ETF | 454.47 | 454.57 | 454.47 | 454.57 | 900.0 |
| 2021-10-28 05:40:00 | SPY | ETF | 454.65 | 454.65 | 454.65 | 454.65 | 400.0 |
| 2021-10-28 05:45:00 | SPY | ETF | 454.67 | 454.7 | 454.64 | 454.7 | 1529.0 |
| 2021-10-28 05:50:00 | SPY | ETF | 454.67 | 454.67 | 454.67 | 454.67 | 300.0 |
| 2021-10-28 05:55:00 | SPY | ETF | 454.64 | 454.72 | 454.64 | 454.67 | 32045.0 |
| 2021-10-28 06:00:00 | SPY | ETF | 454.69 | 454.78 | 454.69 | 454.74 | 4093.0 |
| 2021-10-28 06:05:00 | SPY | ETF | 454.72 | 454.75 | 454.72 | 454.75 | 200.0 |
| 2021-10-28 06:10:00 | SPY | ETF | 454.74 | 454.74 | 454.6 | 454.6 | 12350.0 |
| 2021-10-28 06:15:00 | SPY | ETF | 454.6 | 454.75 | 454.6 | 454.75 | 13687.0 |
| 2021-10-28 06:20:00 | SPY | ETF | 454.7 | 454.76 | 454.7 | 454.76 | 596.0 |
| 2021-10-28 06:30:00 | SPY | ETF | 454.89 | 455.01 | 454.89 | 454.96 | 30398.0 |
| 2021-10-28 06:35:00 | SPY | ETF | 454.93 | 454.95 | 454.93 | 454.95 | 1600.0 |
| 2021-10-28 06:40:00 | SPY | ETF | 454.96 | 455.06 | 454.96 | 455.06 | 4479.0 |
| 2021-10-28 06:45:00 | SPY | ETF | 455.07 | 455.2 | 455.06 | 455.13 | 14169.0 |
| 2021-10-28 06:50:00 | SPY | ETF | 455.23 | 455.38 | 455.21 | 455.38 | 3801.0 |
| 2021-10-28 06:55:00 | SPY | ETF | 455.3 | 455.43 | 455.25 | 455.43 | 9656.0 |
| 2021-10-28 07:00:00 | SPY | ETF | 455.37 | 455.44 | 455.32 | 455.36 | 19185.0 |
| 2021-10-28 07:05:00 | SPY | ETF | 455.4 | 455.55 | 455.35 | 455.52 | 62814.0 |
| 2021-10-28 07:10:00 | SPY | ETF | 455.52 | 455.63 | 455.41 | 455.45 | 33740.0 |
| 2021-10-28 07:15:00 | SPY | ETF | 455.48 | 455.51 | 455.44 | 455.44 | 1810.0 |
| 2021-10-28 07:20:00 | SPY | ETF | 455.48 | 455.52 | 455.44 | 455.49 | 23180.0 |
| 2021-10-28 07:25:00 | SPY | ETF | 455.47 | 455.51 | 455.46 | 455.46 | 25639.0 |
| 2021-10-28 07:30:00 | SPY | ETF | 455.45 | 455.45 | 455.3 | 455.34 | 33757.0 |
| 2021-10-28 07:35:00 | SPY | ETF | 455.43 | 455.43 | 455.36 | 455.4 | 2023.0 |
| 2021-10-28 07:40:00 | SPY | ETF | 455.38 | 455.38 | 455.24 | 455.24 | 40125.0 |
| 2021-10-28 07:45:00 | SPY | ETF | 455.231 | 455.37 | 455.231 | 455.31 | 22503.0 |
| 2021-10-28 07:50:00 | SPY | ETF | 455.32 | 455.32 | 455.1 | 455.1 | 19895.0 |
| 2021-10-28 07:55:00 | SPY | ETF | 455.09 | 455.33 | 455.08 | 455.15 | 21890.0 |
| 2021-10-28 08:00:00 | SPY | ETF | 455.42 | 455.5 | 454.28 | 455.14 | 52660.0 |
| 2021-10-28 08:05:00 | SPY | ETF | 455.17 | 455.35 | 455.15 | 455.31 | 16024.0 |
| 2021-10-28 08:10:00 | SPY | ETF | 455.31 | 455.34 | 455.28 | 455.3 | 15483.0 |
> showing 50 of 83,356 rows — these rows as CSV