PREVIEW / etf_5min / 2021-11-16
file: by_date/etf_5min/2021/2021-11-16.parquet size: 1.8 MB rows: 84,838
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-11-16 04:00:00 | SPY | ETF | 467.0 | 467.0 | 466.84 | 466.84 | 4794.0 |
| 2021-11-16 04:05:00 | SPY | ETF | 466.82 | 466.9 | 466.81 | 466.87 | 2430.0 |
| 2021-11-16 04:10:00 | SPY | ETF | 466.93 | 467.03 | 466.92 | 466.95 | 1647.0 |
| 2021-11-16 04:15:00 | SPY | ETF | 466.96 | 466.98 | 466.93 | 466.93 | 1229.0 |
| 2021-11-16 04:20:00 | SPY | ETF | 466.88 | 466.89 | 466.88 | 466.88 | 460.0 |
| 2021-11-16 04:25:00 | SPY | ETF | 466.92 | 466.97 | 466.88 | 466.97 | 900.0 |
| 2021-11-16 04:40:00 | SPY | ETF | 466.98 | 466.98 | 466.98 | 466.98 | 189.0 |
| 2021-11-16 04:45:00 | SPY | ETF | 467.03 | 467.03 | 467.02 | 467.02 | 300.0 |
| 2021-11-16 04:50:00 | SPY | ETF | 467.1 | 467.12 | 467.04 | 467.04 | 500.0 |
| 2021-11-16 04:55:00 | SPY | ETF | 467.15 | 467.23 | 467.15 | 467.23 | 600.0 |
| 2021-11-16 05:00:00 | SPY | ETF | 467.14 | 467.16 | 467.14 | 467.16 | 600.0 |
| 2021-11-16 05:05:00 | SPY | ETF | 467.15 | 467.15 | 467.05 | 467.05 | 700.0 |
| 2021-11-16 05:10:00 | SPY | ETF | 466.98 | 466.98 | 466.81 | 466.81 | 994.0 |
| 2021-11-16 05:15:00 | SPY | ETF | 466.72 | 466.73 | 466.66 | 466.66 | 460.0 |
| 2021-11-16 05:20:00 | SPY | ETF | 466.73 | 466.81 | 466.73 | 466.76 | 1621.0 |
| 2021-11-16 05:25:00 | SPY | ETF | 466.76 | 466.76 | 466.63 | 466.68 | 881.0 |
| 2021-11-16 05:30:00 | SPY | ETF | 466.88 | 466.91 | 466.88 | 466.9 | 594.0 |
| 2021-11-16 05:45:00 | SPY | ETF | 466.84 | 466.96 | 466.84 | 466.94 | 1590.0 |
| 2021-11-16 05:50:00 | SPY | ETF | 466.88 | 466.88 | 466.88 | 466.88 | 299.0 |
| 2021-11-16 05:55:00 | SPY | ETF | 466.95 | 466.95 | 466.89 | 466.89 | 12566.0 |
| 2021-11-16 06:00:00 | SPY | ETF | 466.87 | 466.98 | 466.87 | 466.89 | 1483.0 |
| 2021-11-16 06:05:00 | SPY | ETF | 466.92 | 467.0 | 466.92 | 467.0 | 930.0 |
| 2021-11-16 06:10:00 | SPY | ETF | 466.98 | 466.99 | 466.95 | 466.95 | 4000.0 |
| 2021-11-16 06:15:00 | SPY | ETF | 466.95 | 467.05 | 466.95 | 467.05 | 14679.0 |
| 2021-11-16 06:20:00 | SPY | ETF | 467.06 | 467.12 | 467.06 | 467.09 | 35766.0 |
| 2021-11-16 06:25:00 | SPY | ETF | 467.09 | 467.28 | 467.08 | 467.28 | 5165.0 |
| 2021-11-16 06:30:00 | SPY | ETF | 467.27 | 467.45 | 467.27 | 467.45 | 2310.0 |
| 2021-11-16 06:35:00 | SPY | ETF | 467.51 | 467.53 | 467.51 | 467.53 | 200.0 |
| 2021-11-16 06:40:00 | SPY | ETF | 467.5 | 467.55 | 467.5 | 467.55 | 398.0 |
| 2021-11-16 06:45:00 | SPY | ETF | 467.63 | 467.71 | 467.63 | 467.69 | 1500.0 |
| 2021-11-16 06:50:00 | SPY | ETF | 467.68 | 467.68 | 467.63 | 467.63 | 620.0 |
| 2021-11-16 06:55:00 | SPY | ETF | 467.75 | 467.86 | 467.75 | 467.85 | 2384.0 |
| 2021-11-16 07:00:00 | SPY | ETF | 467.84 | 467.91 | 467.77 | 467.85 | 15567.0 |
| 2021-11-16 07:05:00 | SPY | ETF | 467.85 | 467.88 | 467.82 | 467.84 | 2498.0 |
| 2021-11-16 07:10:00 | SPY | ETF | 467.86 | 467.86 | 467.73 | 467.75 | 14205.0 |
| 2021-11-16 07:15:00 | SPY | ETF | 467.71 | 467.78 | 467.66 | 467.71 | 4974.0 |
| 2021-11-16 07:20:00 | SPY | ETF | 467.7 | 467.7 | 467.56 | 467.6 | 4862.0 |
| 2021-11-16 07:25:00 | SPY | ETF | 467.64 | 467.64 | 467.56 | 467.56 | 1985.0 |
| 2021-11-16 07:30:00 | SPY | ETF | 467.59 | 467.62 | 467.59 | 467.62 | 1149.0 |
| 2021-11-16 07:35:00 | SPY | ETF | 467.6 | 467.6 | 467.53 | 467.56 | 2870.0 |
| 2021-11-16 07:40:00 | SPY | ETF | 467.58 | 467.6 | 467.5 | 467.5 | 17079.0 |
| 2021-11-16 07:45:00 | SPY | ETF | 467.52 | 467.52 | 467.44 | 467.47 | 5031.0 |
| 2021-11-16 07:50:00 | SPY | ETF | 467.44 | 467.44 | 467.35 | 467.37 | 19963.0 |
| 2021-11-16 07:55:00 | SPY | ETF | 467.42 | 467.48 | 467.42 | 467.48 | 958.0 |
| 2021-11-16 08:00:00 | SPY | ETF | 467.6201 | 467.9 | 466.8996 | 467.68 | 20866.0 |
| 2021-11-16 08:05:00 | SPY | ETF | 467.68 | 467.7 | 467.63 | 467.7 | 6430.0 |
| 2021-11-16 08:10:00 | SPY | ETF | 467.7 | 467.7 | 467.62 | 467.62 | 13976.0 |
| 2021-11-16 08:15:00 | SPY | ETF | 467.62 | 467.69 | 467.61 | 467.61 | 5150.0 |
| 2021-11-16 08:20:00 | SPY | ETF | 467.66 | 467.7 | 467.63 | 467.63 | 4462.0 |
| 2021-11-16 08:25:00 | SPY | ETF | 467.66 | 467.66 | 467.62 | 467.66 | 1661.0 |
> showing 50 of 84,838 rows — these rows as CSV