PREVIEW / etf_5min / 2021-12-07
file: by_date/etf_5min/2021/2021-12-07.parquet size: 1.9 MB rows: 90,290
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-12-07 04:00:00 | SPY | ETF | 460.11 | 464.0 | 459.75 | 463.95 | 27438.0 |
| 2021-12-07 04:05:00 | SPY | ETF | 463.84 | 464.02 | 463.78 | 463.84 | 27643.0 |
| 2021-12-07 04:10:00 | SPY | ETF | 463.84 | 463.98 | 463.79 | 463.92 | 70239.0 |
| 2021-12-07 04:15:00 | SPY | ETF | 463.91 | 464.09 | 463.87 | 464.04 | 28332.0 |
| 2021-12-07 04:20:00 | SPY | ETF | 464.05 | 464.26 | 464.04 | 464.24 | 15782.0 |
| 2021-12-07 04:25:00 | SPY | ETF | 464.29 | 464.32 | 464.09 | 464.09 | 12137.0 |
| 2021-12-07 04:30:00 | SPY | ETF | 464.08 | 464.1 | 463.66 | 463.66 | 2458.0 |
| 2021-12-07 04:35:00 | SPY | ETF | 463.79 | 463.8 | 463.52 | 463.52 | 3478.0 |
| 2021-12-07 04:40:00 | SPY | ETF | 463.62 | 463.89 | 463.5 | 463.81 | 18710.0 |
| 2021-12-07 04:45:00 | SPY | ETF | 463.88 | 463.94 | 463.82 | 463.93 | 4183.0 |
| 2021-12-07 04:50:00 | SPY | ETF | 463.95 | 463.98 | 463.78 | 463.9 | 5418.0 |
| 2021-12-07 04:55:00 | SPY | ETF | 463.99 | 464.02 | 463.83 | 463.88 | 3017.0 |
| 2021-12-07 05:00:00 | SPY | ETF | 463.91 | 464.15 | 463.89 | 464.15 | 1313.0 |
| 2021-12-07 05:05:00 | SPY | ETF | 464.1 | 464.1 | 463.98 | 464.03 | 3507.0 |
| 2021-12-07 05:10:00 | SPY | ETF | 464.19 | 464.27 | 464.18 | 464.27 | 1330.0 |
| 2021-12-07 05:15:00 | SPY | ETF | 464.35 | 464.44 | 464.32 | 464.44 | 6008.0 |
| 2021-12-07 05:20:00 | SPY | ETF | 464.4 | 464.47 | 464.26 | 464.26 | 5131.0 |
| 2021-12-07 05:25:00 | SPY | ETF | 464.43 | 464.48 | 464.41 | 464.48 | 1442.0 |
| 2021-12-07 05:30:00 | SPY | ETF | 464.41 | 464.44 | 464.29 | 464.29 | 3208.0 |
| 2021-12-07 05:35:00 | SPY | ETF | 464.33 | 464.33 | 464.27 | 464.33 | 3220.0 |
| 2021-12-07 05:40:00 | SPY | ETF | 464.39 | 464.49 | 464.38 | 464.49 | 4060.0 |
| 2021-12-07 05:45:00 | SPY | ETF | 464.45 | 464.49 | 464.45 | 464.45 | 2457.0 |
| 2021-12-07 05:50:00 | SPY | ETF | 464.48 | 465.23 | 464.48 | 464.86 | 25878.0 |
| 2021-12-07 05:55:00 | SPY | ETF | 464.9 | 464.9 | 464.71 | 464.85 | 8403.0 |
| 2021-12-07 06:00:00 | SPY | ETF | 464.83 | 464.83 | 464.71 | 464.82 | 4061.0 |
| 2021-12-07 06:05:00 | SPY | ETF | 464.72 | 464.91 | 464.72 | 464.84 | 2675.0 |
| 2021-12-07 06:10:00 | SPY | ETF | 464.83 | 464.91 | 464.6 | 464.67 | 14565.0 |
| 2021-12-07 06:15:00 | SPY | ETF | 464.66 | 464.76 | 464.66 | 464.75 | 705.0 |
| 2021-12-07 06:20:00 | SPY | ETF | 464.7 | 464.73 | 464.58 | 464.59 | 2244.0 |
| 2021-12-07 06:25:00 | SPY | ETF | 464.51 | 464.7 | 464.5 | 464.65 | 3338.0 |
| 2021-12-07 06:30:00 | SPY | ETF | 464.64 | 464.77 | 464.63 | 464.77 | 1749.0 |
| 2021-12-07 06:35:00 | SPY | ETF | 464.66 | 464.83 | 464.65 | 464.83 | 628.0 |
| 2021-12-07 06:40:00 | SPY | ETF | 464.8 | 465.02 | 464.8 | 465.02 | 26908.0 |
| 2021-12-07 06:45:00 | SPY | ETF | 464.9 | 464.9 | 464.8 | 464.8 | 2503.0 |
| 2021-12-07 06:50:00 | SPY | ETF | 464.84 | 464.85 | 464.77 | 464.78 | 2130.0 |
| 2021-12-07 06:55:00 | SPY | ETF | 464.78 | 464.92 | 464.77 | 464.8 | 21194.0 |
| 2021-12-07 07:00:00 | SPY | ETF | 464.8 | 464.92 | 464.27 | 464.45 | 110302.0 |
| 2021-12-07 07:05:00 | SPY | ETF | 464.47 | 464.6 | 464.23 | 464.57 | 60192.0 |
| 2021-12-07 07:10:00 | SPY | ETF | 464.57 | 464.67 | 464.41 | 464.5 | 35095.0 |
| 2021-12-07 07:15:00 | SPY | ETF | 464.54 | 464.65 | 464.49 | 464.57 | 13695.0 |
| 2021-12-07 07:20:00 | SPY | ETF | 464.54 | 464.72 | 464.54 | 464.7 | 10039.0 |
| 2021-12-07 07:25:00 | SPY | ETF | 464.68 | 464.68 | 464.46 | 464.59 | 14733.0 |
| 2021-12-07 07:30:00 | SPY | ETF | 464.55 | 464.66 | 464.46 | 464.46 | 49032.0 |
| 2021-12-07 07:35:00 | SPY | ETF | 464.53 | 464.69 | 464.53 | 464.55 | 13896.0 |
| 2021-12-07 07:40:00 | SPY | ETF | 464.55 | 464.6 | 464.43 | 464.55 | 12728.0 |
| 2021-12-07 07:45:00 | SPY | ETF | 464.58 | 464.62 | 464.55 | 464.55 | 19817.0 |
| 2021-12-07 07:50:00 | SPY | ETF | 464.58 | 464.71 | 464.58 | 464.69 | 18264.0 |
| 2021-12-07 07:55:00 | SPY | ETF | 464.69 | 464.69 | 464.56 | 464.64 | 17259.0 |
| 2021-12-07 08:00:00 | SPY | ETF | 464.6401 | 464.8496 | 460.5 | 464.55 | 66351.0 |
| 2021-12-07 08:05:00 | SPY | ETF | 464.53 | 464.62 | 464.4 | 464.54 | 65503.0 |
> showing 50 of 90,290 rows — these rows as CSV