PREVIEW / etf_5min / 2021-12-20
file: by_date/etf_5min/2021/2021-12-20.parquet size: 2.0 MB rows: 97,587
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-20 04:00:00 | SPY | ETF | 453.6 | 458.1 | 452.23 | 452.38 | 57606.0 |
| 2021-12-20 04:05:00 | SPY | ETF | 452.24 | 452.24 | 451.82 | 452.06 | 40372.0 |
| 2021-12-20 04:10:00 | SPY | ETF | 452.06 | 452.36 | 451.8 | 451.8 | 44844.0 |
| 2021-12-20 04:15:00 | SPY | ETF | 451.76 | 452.07 | 451.76 | 451.94 | 27528.0 |
| 2021-12-20 04:20:00 | SPY | ETF | 451.83 | 452.21 | 451.76 | 452.18 | 6989.0 |
| 2021-12-20 04:25:00 | SPY | ETF | 452.13 | 452.13 | 451.8 | 452.02 | 4740.0 |
| 2021-12-20 04:30:00 | SPY | ETF | 452.12 | 452.76 | 452.12 | 452.53 | 25109.0 |
| 2021-12-20 04:35:00 | SPY | ETF | 452.41 | 452.81 | 452.41 | 452.51 | 3289.0 |
| 2021-12-20 04:40:00 | SPY | ETF | 452.82 | 452.82 | 452.76 | 452.76 | 200.0 |
| 2021-12-20 04:45:00 | SPY | ETF | 452.79 | 452.79 | 452.53 | 452.61 | 2403.0 |
| 2021-12-20 04:50:00 | SPY | ETF | 452.56 | 452.57 | 452.3 | 452.34 | 5254.0 |
| 2021-12-20 04:55:00 | SPY | ETF | 452.34 | 452.82 | 452.34 | 452.82 | 10255.0 |
| 2021-12-20 05:00:00 | SPY | ETF | 453.34 | 453.67 | 453.29 | 453.5 | 8566.0 |
| 2021-12-20 05:05:00 | SPY | ETF | 453.66 | 454.05 | 453.66 | 453.83 | 4714.0 |
| 2021-12-20 05:10:00 | SPY | ETF | 453.94 | 454.12 | 453.93 | 454.0 | 28672.0 |
| 2021-12-20 05:15:00 | SPY | ETF | 454.01 | 454.14 | 453.81 | 454.14 | 3350.0 |
| 2021-12-20 05:20:00 | SPY | ETF | 454.17 | 454.39 | 454.07 | 454.1 | 32170.0 |
| 2021-12-20 05:25:00 | SPY | ETF | 454.13 | 454.13 | 454.02 | 454.08 | 1421.0 |
| 2021-12-20 05:30:00 | SPY | ETF | 454.03 | 454.05 | 453.58 | 453.71 | 5812.0 |
| 2021-12-20 05:35:00 | SPY | ETF | 453.8 | 453.91 | 453.78 | 453.91 | 1669.0 |
| 2021-12-20 05:40:00 | SPY | ETF | 454.03 | 454.16 | 454.03 | 454.08 | 1022.0 |
| 2021-12-20 05:45:00 | SPY | ETF | 454.03 | 454.4 | 454.03 | 454.4 | 3552.0 |
| 2021-12-20 05:50:00 | SPY | ETF | 454.58 | 454.68 | 454.36 | 454.68 | 6644.0 |
| 2021-12-20 05:55:00 | SPY | ETF | 454.78 | 454.78 | 454.59 | 454.59 | 27280.0 |
| 2021-12-20 06:00:00 | SPY | ETF | 454.4 | 454.4 | 454.01 | 454.04 | 2309.0 |
| 2021-12-20 06:05:00 | SPY | ETF | 454.03 | 454.43 | 454.03 | 454.4 | 61012.0 |
| 2021-12-20 06:10:00 | SPY | ETF | 454.45 | 454.68 | 454.3 | 454.59 | 7589.0 |
| 2021-12-20 06:15:00 | SPY | ETF | 454.5 | 454.5 | 454.15 | 454.2 | 9101.0 |
| 2021-12-20 06:20:00 | SPY | ETF | 454.23 | 454.54 | 454.23 | 454.54 | 2543.0 |
| 2021-12-20 06:25:00 | SPY | ETF | 454.6 | 454.7 | 454.55 | 454.55 | 7044.0 |
| 2021-12-20 06:30:00 | SPY | ETF | 454.64 | 455.0 | 454.61 | 454.83 | 9113.0 |
| 2021-12-20 06:35:00 | SPY | ETF | 454.84 | 454.99 | 454.61 | 454.61 | 6909.0 |
| 2021-12-20 06:40:00 | SPY | ETF | 454.61 | 454.72 | 454.53 | 454.65 | 15650.0 |
| 2021-12-20 06:45:00 | SPY | ETF | 454.75 | 454.75 | 454.45 | 454.46 | 4981.0 |
| 2021-12-20 06:50:00 | SPY | ETF | 454.55 | 454.62 | 454.55 | 454.62 | 400.0 |
| 2021-12-20 06:55:00 | SPY | ETF | 454.7 | 455.34 | 454.7 | 455.29 | 18735.0 |
| 2021-12-20 07:00:00 | SPY | ETF | 455.37 | 455.77 | 455.31 | 455.38 | 132842.0 |
| 2021-12-20 07:05:00 | SPY | ETF | 455.4 | 455.87 | 455.38 | 455.7 | 107442.0 |
| 2021-12-20 07:10:00 | SPY | ETF | 455.7 | 455.7 | 455.44 | 455.47 | 28304.0 |
| 2021-12-20 07:15:00 | SPY | ETF | 455.34 | 455.34 | 454.82 | 454.82 | 35666.0 |
| 2021-12-20 07:20:00 | SPY | ETF | 454.86 | 455.24 | 454.78 | 455.06 | 32267.0 |
| 2021-12-20 07:25:00 | SPY | ETF | 455.19 | 455.19 | 454.84 | 454.91 | 5885.0 |
| 2021-12-20 07:30:00 | SPY | ETF | 454.87 | 455.09 | 454.77 | 455.09 | 12750.0 |
| 2021-12-20 07:35:00 | SPY | ETF | 455.1 | 455.1 | 454.87 | 455.05 | 19732.0 |
| 2021-12-20 07:40:00 | SPY | ETF | 455.11 | 455.18 | 455.0 | 455.03 | 22269.0 |
| 2021-12-20 07:45:00 | SPY | ETF | 455.02 | 455.02 | 454.64 | 454.71 | 19096.0 |
| 2021-12-20 07:50:00 | SPY | ETF | 454.71 | 454.86 | 454.53 | 454.54 | 31692.0 |
| 2021-12-20 07:55:00 | SPY | ETF | 454.7 | 454.7 | 454.33 | 454.33 | 35503.0 |
| 2021-12-20 08:00:00 | SPY | ETF | 454.29 | 460.214 | 451.8596 | 454.48 | 89427.0 |
| 2021-12-20 08:05:00 | SPY | ETF | 454.42 | 454.62 | 454.17 | 454.22 | 18582.0 |
> showing 50 of 97,587 rows — these rows as CSV