PREVIEW / etf_5min / 2022-01-11
file: by_date/etf_5min/2022/2022-01-11.parquet size: 2.0 MB rows: 94,229
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-11 04:00:00 | SPY | ETF | 465.99 | 466.39 | 465.97 | 466.29 | 5133.0 |
| 2022-01-11 04:05:00 | SPY | ETF | 466.32 | 466.33 | 466.14 | 466.21 | 3724.0 |
| 2022-01-11 04:10:00 | SPY | ETF | 466.28 | 466.71 | 466.21 | 466.65 | 7275.0 |
| 2022-01-11 04:15:00 | SPY | ETF | 466.52 | 466.97 | 466.46 | 466.92 | 3294.0 |
| 2022-01-11 04:20:00 | SPY | ETF | 467.0 | 467.29 | 466.88 | 467.25 | 10354.0 |
| 2022-01-11 04:25:00 | SPY | ETF | 467.23 | 467.29 | 467.16 | 467.24 | 1319.0 |
| 2022-01-11 04:30:00 | SPY | ETF | 467.24 | 467.65 | 467.24 | 467.61 | 23001.0 |
| 2022-01-11 04:35:00 | SPY | ETF | 467.45 | 467.65 | 467.43 | 467.65 | 1762.0 |
| 2022-01-11 04:40:00 | SPY | ETF | 467.65 | 467.7 | 467.55 | 467.7 | 6984.0 |
| 2022-01-11 04:45:00 | SPY | ETF | 467.66 | 467.91 | 467.66 | 467.88 | 2175.0 |
| 2022-01-11 04:50:00 | SPY | ETF | 467.87 | 467.9 | 467.76 | 467.76 | 2484.0 |
| 2022-01-11 04:55:00 | SPY | ETF | 467.81 | 467.81 | 467.52 | 467.55 | 7291.0 |
| 2022-01-11 05:00:00 | SPY | ETF | 467.59 | 467.82 | 467.48 | 467.82 | 6871.0 |
| 2022-01-11 05:05:00 | SPY | ETF | 467.87 | 468.06 | 467.76 | 467.81 | 6927.0 |
| 2022-01-11 05:10:00 | SPY | ETF | 467.76 | 467.79 | 467.65 | 467.68 | 1883.0 |
| 2022-01-11 05:15:00 | SPY | ETF | 467.62 | 467.66 | 467.48 | 467.66 | 1000.0 |
| 2022-01-11 05:20:00 | SPY | ETF | 467.66 | 467.66 | 467.42 | 467.43 | 2020.0 |
| 2022-01-11 05:25:00 | SPY | ETF | 467.56 | 467.56 | 467.46 | 467.46 | 1700.0 |
| 2022-01-11 05:30:00 | SPY | ETF | 467.34 | 467.41 | 467.34 | 467.35 | 800.0 |
| 2022-01-11 05:35:00 | SPY | ETF | 467.48 | 467.64 | 467.46 | 467.48 | 2100.0 |
| 2022-01-11 05:40:00 | SPY | ETF | 467.48 | 467.63 | 467.48 | 467.58 | 3635.0 |
| 2022-01-11 05:45:00 | SPY | ETF | 467.61 | 467.72 | 467.61 | 467.69 | 2400.0 |
| 2022-01-11 05:50:00 | SPY | ETF | 467.69 | 467.69 | 467.46 | 467.68 | 771.0 |
| 2022-01-11 05:55:00 | SPY | ETF | 467.67 | 467.67 | 467.43 | 467.45 | 700.0 |
| 2022-01-11 06:00:00 | SPY | ETF | 467.47 | 467.47 | 467.05 | 467.05 | 8518.0 |
| 2022-01-11 06:05:00 | SPY | ETF | 467.12 | 467.14 | 466.84 | 467.08 | 4531.0 |
| 2022-01-11 06:10:00 | SPY | ETF | 467.07 | 467.12 | 466.93 | 466.93 | 1650.0 |
| 2022-01-11 06:15:00 | SPY | ETF | 466.97 | 467.13 | 466.96 | 467.1 | 700.0 |
| 2022-01-11 06:20:00 | SPY | ETF | 467.05 | 467.05 | 466.99 | 466.99 | 1728.0 |
| 2022-01-11 06:25:00 | SPY | ETF | 466.95 | 466.95 | 466.85 | 466.92 | 1150.0 |
| 2022-01-11 06:30:00 | SPY | ETF | 466.92 | 467.17 | 466.92 | 467.17 | 3856.0 |
| 2022-01-11 06:35:00 | SPY | ETF | 467.11 | 467.24 | 467.06 | 467.24 | 1075.0 |
| 2022-01-11 06:40:00 | SPY | ETF | 467.22 | 467.3 | 467.22 | 467.3 | 9657.0 |
| 2022-01-11 06:45:00 | SPY | ETF | 467.26 | 467.32 | 467.26 | 467.29 | 2450.0 |
| 2022-01-11 06:50:00 | SPY | ETF | 467.27 | 467.47 | 467.24 | 467.47 | 2581.0 |
| 2022-01-11 06:55:00 | SPY | ETF | 467.44 | 467.44 | 466.96 | 466.96 | 6512.0 |
| 2022-01-11 07:00:00 | SPY | ETF | 466.81 | 467.11 | 466.81 | 467.07 | 27316.0 |
| 2022-01-11 07:05:00 | SPY | ETF | 467.02 | 467.19 | 466.98 | 467.08 | 8931.0 |
| 2022-01-11 07:10:00 | SPY | ETF | 467.06 | 467.14 | 466.88 | 467.06 | 4799.0 |
| 2022-01-11 07:15:00 | SPY | ETF | 467.0 | 467.08 | 466.96 | 466.96 | 10938.0 |
| 2022-01-11 07:20:00 | SPY | ETF | 466.97 | 467.08 | 466.95 | 467.04 | 10135.0 |
| 2022-01-11 07:25:00 | SPY | ETF | 467.04 | 467.07 | 466.93 | 467.07 | 12740.0 |
| 2022-01-11 07:30:00 | SPY | ETF | 467.11 | 467.11 | 466.94 | 467.03 | 2203.0 |
| 2022-01-11 07:35:00 | SPY | ETF | 467.0 | 467.09 | 466.95 | 467.02 | 4088.0 |
| 2022-01-11 07:40:00 | SPY | ETF | 467.05 | 467.06 | 466.93 | 466.93 | 2520.0 |
| 2022-01-11 07:45:00 | SPY | ETF | 466.97 | 466.97 | 466.58 | 466.7 | 6984.0 |
| 2022-01-11 07:50:00 | SPY | ETF | 466.74 | 466.91 | 466.68 | 466.7 | 13895.0 |
| 2022-01-11 07:55:00 | SPY | ETF | 466.7 | 466.78 | 466.24 | 466.24 | 22575.0 |
| 2022-01-11 08:00:00 | SPY | ETF | 467.0399 | 467.8896 | 464.93 | 466.6 | 53068.0 |
| 2022-01-11 08:05:00 | SPY | ETF | 466.55 | 466.75 | 466.52 | 466.58 | 14749.0 |
> showing 50 of 94,229 rows — these rows as CSV