PREVIEW / etf_5min / 2022-01-18
file: by_date/etf_5min/2022/2022-01-18.parquet size: 2.1 MB rows: 103,100
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-18 04:00:00 | SPY | ETF | 461.45 | 461.45 | 460.24 | 460.28 | 13142.0 |
| 2022-01-18 04:05:00 | SPY | ETF | 460.11 | 460.11 | 459.59 | 459.82 | 10050.0 |
| 2022-01-18 04:10:00 | SPY | ETF | 459.91 | 459.92 | 459.63 | 459.76 | 14403.0 |
| 2022-01-18 04:15:00 | SPY | ETF | 459.72 | 459.72 | 459.04 | 459.11 | 7834.0 |
| 2022-01-18 04:20:00 | SPY | ETF | 459.29 | 459.36 | 458.54 | 458.65 | 11719.0 |
| 2022-01-18 04:25:00 | SPY | ETF | 458.68 | 459.02 | 458.5 | 458.99 | 22733.0 |
| 2022-01-18 04:30:00 | SPY | ETF | 459.03 | 459.18 | 458.9 | 458.94 | 15912.0 |
| 2022-01-18 04:35:00 | SPY | ETF | 458.84 | 458.84 | 458.59 | 458.77 | 3275.0 |
| 2022-01-18 04:40:00 | SPY | ETF | 458.77 | 458.8 | 458.47 | 458.65 | 4550.0 |
| 2022-01-18 04:45:00 | SPY | ETF | 458.98 | 459.41 | 458.98 | 459.33 | 2180.0 |
| 2022-01-18 04:50:00 | SPY | ETF | 459.5 | 459.6 | 459.4 | 459.4 | 4060.0 |
| 2022-01-18 04:55:00 | SPY | ETF | 459.48 | 459.48 | 459.36 | 459.36 | 2100.0 |
| 2022-01-18 05:00:00 | SPY | ETF | 459.35 | 459.57 | 459.35 | 459.57 | 4400.0 |
| 2022-01-18 05:05:00 | SPY | ETF | 459.55 | 459.55 | 459.32 | 459.5 | 2600.0 |
| 2022-01-18 05:10:00 | SPY | ETF | 459.5 | 459.82 | 459.5 | 459.82 | 3099.0 |
| 2022-01-18 05:15:00 | SPY | ETF | 459.61 | 459.61 | 459.43 | 459.46 | 3492.0 |
| 2022-01-18 05:20:00 | SPY | ETF | 459.53 | 459.66 | 459.53 | 459.65 | 2249.0 |
| 2022-01-18 05:25:00 | SPY | ETF | 459.9 | 460.02 | 459.85 | 460.02 | 3133.0 |
| 2022-01-18 05:30:00 | SPY | ETF | 460.1 | 460.1 | 459.8 | 459.8 | 1600.0 |
| 2022-01-18 05:35:00 | SPY | ETF | 459.72 | 459.8 | 459.5 | 459.52 | 6799.0 |
| 2022-01-18 05:40:00 | SPY | ETF | 459.5 | 459.5 | 459.35 | 459.44 | 14693.0 |
| 2022-01-18 05:45:00 | SPY | ETF | 459.52 | 459.61 | 459.11 | 459.37 | 4808.0 |
| 2022-01-18 05:50:00 | SPY | ETF | 459.66 | 459.7 | 459.58 | 459.66 | 2700.0 |
| 2022-01-18 05:55:00 | SPY | ETF | 459.63 | 459.7 | 459.43 | 459.59 | 4400.0 |
| 2022-01-18 06:00:00 | SPY | ETF | 459.49 | 459.49 | 459.08 | 459.08 | 11432.0 |
| 2022-01-18 06:05:00 | SPY | ETF | 459.13 | 459.54 | 459.03 | 459.34 | 6201.0 |
| 2022-01-18 06:10:00 | SPY | ETF | 459.34 | 459.4 | 459.0 | 459.23 | 10376.0 |
| 2022-01-18 06:15:00 | SPY | ETF | 459.37 | 459.6 | 459.37 | 459.6 | 9104.0 |
| 2022-01-18 06:20:00 | SPY | ETF | 459.52 | 459.52 | 459.33 | 459.33 | 860.0 |
| 2022-01-18 06:25:00 | SPY | ETF | 459.26 | 459.51 | 459.14 | 459.49 | 4947.0 |
| 2022-01-18 06:30:00 | SPY | ETF | 459.4 | 459.56 | 459.2 | 459.37 | 7048.0 |
| 2022-01-18 06:35:00 | SPY | ETF | 459.39 | 459.71 | 459.39 | 459.69 | 300.0 |
| 2022-01-18 06:40:00 | SPY | ETF | 459.57 | 459.69 | 459.57 | 459.66 | 1521.0 |
| 2022-01-18 06:45:00 | SPY | ETF | 459.74 | 459.9 | 459.74 | 459.9 | 2467.0 |
| 2022-01-18 06:50:00 | SPY | ETF | 459.74 | 459.74 | 459.57 | 459.57 | 1100.0 |
| 2022-01-18 06:55:00 | SPY | ETF | 459.62 | 459.62 | 459.56 | 459.59 | 1889.0 |
| 2022-01-18 07:00:00 | SPY | ETF | 459.74 | 460.0 | 459.69 | 459.93 | 44100.0 |
| 2022-01-18 07:05:00 | SPY | ETF | 459.9 | 460.09 | 459.75 | 460.09 | 42615.0 |
| 2022-01-18 07:10:00 | SPY | ETF | 460.04 | 460.04 | 459.86 | 460.0 | 32188.0 |
| 2022-01-18 07:15:00 | SPY | ETF | 459.99 | 460.09 | 459.94 | 460.07 | 91544.0 |
| 2022-01-18 07:20:00 | SPY | ETF | 460.12 | 460.42 | 459.96 | 459.96 | 22615.0 |
| 2022-01-18 07:25:00 | SPY | ETF | 460.09 | 460.26 | 460.09 | 460.26 | 2460.0 |
| 2022-01-18 07:30:00 | SPY | ETF | 460.27 | 460.31 | 459.87 | 459.98 | 18749.0 |
| 2022-01-18 07:35:00 | SPY | ETF | 459.96 | 460.18 | 459.9 | 460.13 | 25881.0 |
| 2022-01-18 07:40:00 | SPY | ETF | 460.13 | 460.13 | 459.99 | 460.0 | 17627.0 |
| 2022-01-18 07:45:00 | SPY | ETF | 460.05 | 460.72 | 460.05 | 460.5 | 35366.0 |
| 2022-01-18 07:50:00 | SPY | ETF | 460.51 | 460.75 | 460.46 | 460.58 | 44219.0 |
| 2022-01-18 07:55:00 | SPY | ETF | 460.56 | 460.8 | 460.54 | 460.699 | 10616.0 |
| 2022-01-18 08:00:00 | SPY | ETF | 459.99 | 462.93 | 458.9796 | 460.49 | 77129.0 |
| 2022-01-18 08:05:00 | SPY | ETF | 460.43 | 460.55 | 460.4 | 460.44 | 8371.0 |
> showing 50 of 103,100 rows — these rows as CSV