PREVIEW / etf_5min / 2021-10-19
file: by_date/etf_5min/2021/2021-10-19.parquet size: 1.8 MB rows: 83,932
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-10-19 04:00:00 | SPY | ETF | 448.14 | 448.14 | 448.08 | 448.14 | 600.0 |
| 2021-10-19 04:05:00 | SPY | ETF | 448.03 | 448.63 | 448.03 | 448.6 | 1800.0 |
| 2021-10-19 04:10:00 | SPY | ETF | 448.58 | 448.58 | 448.4 | 448.47 | 3880.0 |
| 2021-10-19 04:15:00 | SPY | ETF | 448.52 | 448.8 | 448.52 | 448.8 | 2314.0 |
| 2021-10-19 04:20:00 | SPY | ETF | 448.59 | 448.59 | 448.59 | 448.59 | 100.0 |
| 2021-10-19 04:25:00 | SPY | ETF | 448.63 | 448.63 | 448.5 | 448.5 | 2811.0 |
| 2021-10-19 04:30:00 | SPY | ETF | 448.53 | 448.53 | 448.4 | 448.4 | 900.0 |
| 2021-10-19 04:35:00 | SPY | ETF | 448.45 | 448.45 | 448.36 | 448.39 | 5094.0 |
| 2021-10-19 04:40:00 | SPY | ETF | 448.37 | 448.41 | 448.37 | 448.41 | 315.0 |
| 2021-10-19 04:45:00 | SPY | ETF | 448.43 | 448.5 | 448.43 | 448.44 | 1494.0 |
| 2021-10-19 04:50:00 | SPY | ETF | 448.45 | 448.45 | 448.44 | 448.44 | 330.0 |
| 2021-10-19 04:55:00 | SPY | ETF | 448.44 | 448.58 | 448.44 | 448.58 | 830.0 |
| 2021-10-19 05:00:00 | SPY | ETF | 448.52 | 448.73 | 448.43 | 448.73 | 1600.0 |
| 2021-10-19 05:05:00 | SPY | ETF | 448.71 | 448.71 | 448.67 | 448.71 | 1002.0 |
| 2021-10-19 05:10:00 | SPY | ETF | 448.66 | 448.66 | 448.66 | 448.66 | 228.0 |
| 2021-10-19 05:15:00 | SPY | ETF | 448.62 | 448.62 | 448.61 | 448.61 | 650.0 |
| 2021-10-19 05:20:00 | SPY | ETF | 448.6 | 448.61 | 448.6 | 448.61 | 4990.0 |
| 2021-10-19 05:25:00 | SPY | ETF | 448.65 | 448.7 | 448.65 | 448.7 | 808.0 |
| 2021-10-19 05:30:00 | SPY | ETF | 448.66 | 448.7 | 448.6 | 448.7 | 1340.0 |
| 2021-10-19 05:35:00 | SPY | ETF | 448.78 | 448.78 | 448.78 | 448.78 | 300.0 |
| 2021-10-19 05:40:00 | SPY | ETF | 448.78 | 448.78 | 448.78 | 448.78 | 295.0 |
| 2021-10-19 05:45:00 | SPY | ETF | 448.85 | 448.96 | 448.75 | 448.75 | 3770.0 |
| 2021-10-19 05:50:00 | SPY | ETF | 448.76 | 448.84 | 448.76 | 448.84 | 907.0 |
| 2021-10-19 06:00:00 | SPY | ETF | 448.78 | 448.82 | 448.78 | 448.82 | 325.0 |
| 2021-10-19 06:05:00 | SPY | ETF | 448.8 | 448.86 | 448.8 | 448.86 | 758.0 |
| 2021-10-19 06:10:00 | SPY | ETF | 448.85 | 448.85 | 448.85 | 448.85 | 100.0 |
| 2021-10-19 06:15:00 | SPY | ETF | 448.89 | 448.89 | 448.86 | 448.86 | 3091.0 |
| 2021-10-19 06:25:00 | SPY | ETF | 448.88 | 449.2 | 448.87 | 449.2 | 3228.0 |
| 2021-10-19 06:30:00 | SPY | ETF | 449.22 | 449.26 | 449.15 | 449.18 | 11993.0 |
| 2021-10-19 06:35:00 | SPY | ETF | 449.18 | 449.26 | 449.17 | 449.22 | 7941.0 |
| 2021-10-19 06:40:00 | SPY | ETF | 449.3 | 449.33 | 449.27 | 449.3 | 10063.0 |
| 2021-10-19 06:45:00 | SPY | ETF | 449.3 | 449.32 | 449.23 | 449.28 | 4996.0 |
| 2021-10-19 06:50:00 | SPY | ETF | 449.39 | 449.64 | 449.39 | 449.6 | 8054.0 |
| 2021-10-19 06:55:00 | SPY | ETF | 449.62 | 449.64 | 449.49 | 449.57 | 6144.0 |
| 2021-10-19 07:00:00 | SPY | ETF | 449.56 | 449.58 | 449.48 | 449.54 | 18651.0 |
| 2021-10-19 07:05:00 | SPY | ETF | 449.5 | 449.5 | 449.43 | 449.43 | 3779.0 |
| 2021-10-19 07:10:00 | SPY | ETF | 449.42 | 449.61 | 449.36 | 449.61 | 5137.0 |
| 2021-10-19 07:15:00 | SPY | ETF | 449.64 | 449.85 | 449.58 | 449.84 | 32275.0 |
| 2021-10-19 07:20:00 | SPY | ETF | 449.8 | 449.88 | 449.73 | 449.73 | 13403.0 |
| 2021-10-19 07:25:00 | SPY | ETF | 449.75 | 449.95 | 449.75 | 449.93 | 12322.0 |
| 2021-10-19 07:30:00 | SPY | ETF | 449.91 | 449.91 | 449.51 | 449.58 | 15197.0 |
| 2021-10-19 07:35:00 | SPY | ETF | 449.58 | 449.59 | 449.45 | 449.48 | 46242.0 |
| 2021-10-19 07:40:00 | SPY | ETF | 449.48 | 449.52 | 449.46 | 449.5 | 7756.0 |
| 2021-10-19 07:45:00 | SPY | ETF | 449.48 | 449.49 | 449.41 | 449.41 | 2867.0 |
| 2021-10-19 07:50:00 | SPY | ETF | 449.4 | 449.52 | 449.4 | 449.48 | 8931.0 |
| 2021-10-19 07:55:00 | SPY | ETF | 449.47 | 449.5 | 449.44 | 449.5 | 1500.0 |
| 2021-10-19 08:00:00 | SPY | ETF | 449.1604 | 449.93 | 447.3 | 449.52 | 39431.0 |
| 2021-10-19 08:05:00 | SPY | ETF | 449.52 | 449.57 | 449.45 | 449.48 | 10972.0 |
| 2021-10-19 08:10:00 | SPY | ETF | 449.46 | 449.5 | 449.43 | 449.43 | 8422.0 |
| 2021-10-19 08:15:00 | SPY | ETF | 449.43 | 449.49 | 449.34 | 449.46 | 8112.0 |
> showing 50 of 83,932 rows — these rows as CSV