PREVIEW / etf_5min / 2022-01-06
file: by_date/etf_5min/2022/2022-01-06.parquet size: 2.0 MB rows: 95,824
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 |
|---|---|---|---|---|---|---|---|
| 2022-01-06 04:00:00 | SPY | ETF | 468.46 | 468.47 | 467.71 | 467.81 | 12014.0 |
| 2022-01-06 04:05:00 | SPY | ETF | 467.91 | 467.98 | 467.7 | 467.88 | 3025.0 |
| 2022-01-06 04:10:00 | SPY | ETF | 468.0 | 468.18 | 467.92 | 468.18 | 3249.0 |
| 2022-01-06 04:15:00 | SPY | ETF | 468.24 | 468.46 | 468.12 | 468.29 | 2375.0 |
| 2022-01-06 04:20:00 | SPY | ETF | 468.36 | 468.45 | 468.23 | 468.35 | 1985.0 |
| 2022-01-06 04:25:00 | SPY | ETF | 468.49 | 468.49 | 468.11 | 468.11 | 1700.0 |
| 2022-01-06 04:30:00 | SPY | ETF | 468.0 | 468.0 | 467.79 | 467.86 | 1100.0 |
| 2022-01-06 04:35:00 | SPY | ETF | 467.79 | 467.88 | 467.68 | 467.83 | 850.0 |
| 2022-01-06 04:40:00 | SPY | ETF | 467.92 | 467.94 | 467.71 | 467.86 | 2624.0 |
| 2022-01-06 04:45:00 | SPY | ETF | 467.96 | 467.96 | 467.75 | 467.88 | 4991.0 |
| 2022-01-06 04:50:00 | SPY | ETF | 467.92 | 468.15 | 467.92 | 468.04 | 4430.0 |
| 2022-01-06 04:55:00 | SPY | ETF | 467.93 | 468.17 | 467.55 | 468.17 | 5382.0 |
| 2022-01-06 05:00:00 | SPY | ETF | 468.29 | 468.33 | 468.09 | 468.29 | 819.0 |
| 2022-01-06 05:05:00 | SPY | ETF | 468.34 | 468.57 | 468.3 | 468.46 | 2605.0 |
| 2022-01-06 05:10:00 | SPY | ETF | 468.6 | 468.72 | 468.6 | 468.68 | 1510.0 |
| 2022-01-06 05:15:00 | SPY | ETF | 468.69 | 468.7 | 468.48 | 468.59 | 4015.0 |
| 2022-01-06 05:20:00 | SPY | ETF | 468.63 | 469.02 | 468.58 | 468.97 | 3171.0 |
| 2022-01-06 05:25:00 | SPY | ETF | 468.91 | 469.02 | 468.83 | 468.84 | 13200.0 |
| 2022-01-06 05:30:00 | SPY | ETF | 468.95 | 469.18 | 468.94 | 469.1 | 16345.0 |
| 2022-01-06 05:35:00 | SPY | ETF | 469.1 | 469.25 | 469.1 | 469.23 | 2297.0 |
| 2022-01-06 05:40:00 | SPY | ETF | 469.34 | 469.46 | 468.64 | 468.77 | 4217.0 |
| 2022-01-06 05:45:00 | SPY | ETF | 468.73 | 468.99 | 468.73 | 468.92 | 7429.0 |
| 2022-01-06 05:50:00 | SPY | ETF | 469.02 | 469.02 | 468.68 | 468.68 | 7159.0 |
| 2022-01-06 05:55:00 | SPY | ETF | 468.87 | 468.87 | 468.69 | 468.78 | 1559.0 |
| 2022-01-06 06:00:00 | SPY | ETF | 468.78 | 469.1 | 468.69 | 468.99 | 5282.0 |
| 2022-01-06 06:05:00 | SPY | ETF | 469.15 | 469.17 | 468.72 | 468.73 | 6200.0 |
| 2022-01-06 06:10:00 | SPY | ETF | 468.65 | 468.76 | 468.52 | 468.58 | 12876.0 |
| 2022-01-06 06:15:00 | SPY | ETF | 468.62 | 468.65 | 468.51 | 468.51 | 600.0 |
| 2022-01-06 06:20:00 | SPY | ETF | 468.77 | 468.77 | 468.38 | 468.4 | 2345.0 |
| 2022-01-06 06:25:00 | SPY | ETF | 468.4 | 468.55 | 468.34 | 468.38 | 27211.0 |
| 2022-01-06 06:30:00 | SPY | ETF | 468.4 | 468.67 | 468.35 | 468.67 | 2175.0 |
| 2022-01-06 06:35:00 | SPY | ETF | 468.69 | 468.7 | 468.32 | 468.37 | 5290.0 |
| 2022-01-06 06:40:00 | SPY | ETF | 468.3 | 468.6 | 468.3 | 468.44 | 2126.0 |
| 2022-01-06 06:45:00 | SPY | ETF | 468.36 | 468.42 | 468.06 | 468.09 | 3225.0 |
| 2022-01-06 06:50:00 | SPY | ETF | 468.17 | 468.46 | 468.14 | 468.46 | 2907.0 |
| 2022-01-06 06:55:00 | SPY | ETF | 468.38 | 468.4 | 468.24 | 468.29 | 2607.0 |
| 2022-01-06 07:00:00 | SPY | ETF | 468.24 | 468.82 | 468.23 | 468.65 | 11232.0 |
| 2022-01-06 07:05:00 | SPY | ETF | 468.65 | 468.85 | 468.65 | 468.85 | 5834.0 |
| 2022-01-06 07:10:00 | SPY | ETF | 468.81 | 468.9 | 468.75 | 468.87 | 4639.0 |
| 2022-01-06 07:15:00 | SPY | ETF | 468.78 | 468.93 | 468.72 | 468.72 | 2846.0 |
| 2022-01-06 07:20:00 | SPY | ETF | 468.71 | 468.71 | 468.22 | 468.32 | 16401.0 |
| 2022-01-06 07:25:00 | SPY | ETF | 468.36 | 468.36 | 467.95 | 468.05 | 40449.0 |
| 2022-01-06 07:30:00 | SPY | ETF | 467.97 | 468.2 | 467.91 | 468.07 | 16160.0 |
| 2022-01-06 07:35:00 | SPY | ETF | 468.14 | 468.5 | 468.12 | 468.4 | 10604.0 |
| 2022-01-06 07:40:00 | SPY | ETF | 468.35 | 468.4 | 467.98 | 467.99 | 11330.0 |
| 2022-01-06 07:45:00 | SPY | ETF | 467.98 | 468.019 | 467.87 | 468.014 | 22542.0 |
| 2022-01-06 07:50:00 | SPY | ETF | 468.0 | 468.27 | 467.99 | 468.26 | 25700.0 |
| 2022-01-06 07:55:00 | SPY | ETF | 468.23 | 468.39 | 468.11 | 468.28 | 16663.0 |
| 2022-01-06 08:00:00 | SPY | ETF | 468.28 | 469.0504 | 466.4 | 468.29 | 71991.0 |
| 2022-01-06 08:05:00 | SPY | ETF | 468.26 | 468.42 | 468.16 | 468.4 | 21199.0 |
> showing 50 of 95,824 rows — these rows as CSV