PREVIEW / etf_5min / 2021-01-11
file: by_date/etf_5min/2021/2021-01-11.parquet size: 1.9 MB rows: 86,315
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-01-11 04:00:00 | SPY | ETF | 379.47 | 379.6 | 379.2 | 379.45 | 13716.0 |
| 2021-01-11 04:05:00 | SPY | ETF | 379.5 | 379.53 | 379.45 | 379.53 | 4340.0 |
| 2021-01-11 04:10:00 | SPY | ETF | 379.56 | 379.56 | 379.19 | 379.19 | 6618.0 |
| 2021-01-11 04:15:00 | SPY | ETF | 379.16 | 379.37 | 379.12 | 379.13 | 6926.0 |
| 2021-01-11 04:20:00 | SPY | ETF | 379.3 | 379.55 | 379.3 | 379.5 | 1675.0 |
| 2021-01-11 04:25:00 | SPY | ETF | 379.45 | 379.45 | 379.11 | 379.3 | 2362.0 |
| 2021-01-11 04:30:00 | SPY | ETF | 379.28 | 379.53 | 379.24 | 379.4 | 4075.0 |
| 2021-01-11 04:35:00 | SPY | ETF | 379.3 | 379.3 | 379.1 | 379.1 | 1026.0 |
| 2021-01-11 04:40:00 | SPY | ETF | 379.2 | 379.32 | 379.1 | 379.1 | 1751.0 |
| 2021-01-11 04:45:00 | SPY | ETF | 379.0 | 379.1 | 378.92 | 378.92 | 4461.0 |
| 2021-01-11 04:50:00 | SPY | ETF | 378.96 | 379.04 | 378.92 | 378.92 | 1822.0 |
| 2021-01-11 04:55:00 | SPY | ETF | 378.9 | 378.9 | 378.84 | 378.84 | 500.0 |
| 2021-01-11 05:00:00 | SPY | ETF | 378.8 | 378.84 | 378.79 | 378.79 | 1774.0 |
| 2021-01-11 05:05:00 | SPY | ETF | 378.9 | 379.2 | 378.9 | 379.19 | 2399.0 |
| 2021-01-11 05:10:00 | SPY | ETF | 379.12 | 379.32 | 379.12 | 379.21 | 2187.0 |
| 2021-01-11 05:15:00 | SPY | ETF | 379.25 | 379.3 | 379.2 | 379.2 | 2451.0 |
| 2021-01-11 05:20:00 | SPY | ETF | 379.22 | 379.22 | 378.9 | 379.07 | 3857.0 |
| 2021-01-11 05:25:00 | SPY | ETF | 379.1 | 379.34 | 379.1 | 379.34 | 471.0 |
| 2021-01-11 05:30:00 | SPY | ETF | 379.25 | 379.37 | 379.23 | 379.37 | 954.0 |
| 2021-01-11 05:35:00 | SPY | ETF | 379.38 | 379.5 | 379.35 | 379.35 | 4191.0 |
| 2021-01-11 05:40:00 | SPY | ETF | 379.3 | 379.3 | 379.08 | 379.13 | 2164.0 |
| 2021-01-11 05:45:00 | SPY | ETF | 379.3 | 379.53 | 379.3 | 379.4 | 5085.0 |
| 2021-01-11 05:50:00 | SPY | ETF | 379.3 | 379.5 | 379.29 | 379.48 | 1444.0 |
| 2021-01-11 05:55:00 | SPY | ETF | 379.45 | 379.48 | 379.45 | 379.48 | 862.0 |
| 2021-01-11 06:00:00 | SPY | ETF | 379.53 | 379.53 | 379.4 | 379.4 | 1149.0 |
| 2021-01-11 06:10:00 | SPY | ETF | 379.3 | 379.3 | 379.06 | 379.12 | 4988.0 |
| 2021-01-11 06:15:00 | SPY | ETF | 379.02 | 379.2 | 379.02 | 379.2 | 721.0 |
| 2021-01-11 06:20:00 | SPY | ETF | 379.29 | 379.3 | 379.29 | 379.3 | 341.0 |
| 2021-01-11 06:25:00 | SPY | ETF | 379.25 | 379.3 | 379.2 | 379.3 | 1432.0 |
| 2021-01-11 06:30:00 | SPY | ETF | 379.2 | 379.4 | 379.2 | 379.38 | 1466.0 |
| 2021-01-11 06:35:00 | SPY | ETF | 379.4 | 379.56 | 379.4 | 379.56 | 3318.0 |
| 2021-01-11 06:40:00 | SPY | ETF | 379.4 | 379.63 | 379.4 | 379.63 | 2235.0 |
| 2021-01-11 06:45:00 | SPY | ETF | 379.61 | 379.61 | 379.39 | 379.53 | 974.0 |
| 2021-01-11 06:50:00 | SPY | ETF | 379.4 | 379.53 | 379.4 | 379.51 | 931.0 |
| 2021-01-11 06:55:00 | SPY | ETF | 379.43 | 379.43 | 379.4 | 379.42 | 628.0 |
| 2021-01-11 07:00:00 | SPY | ETF | 379.47 | 379.57 | 379.39 | 379.5 | 46353.0 |
| 2021-01-11 07:05:00 | SPY | ETF | 379.47 | 379.47 | 379.19 | 379.21 | 38837.0 |
| 2021-01-11 07:10:00 | SPY | ETF | 379.21 | 379.21 | 379.03 | 379.03 | 14514.0 |
| 2021-01-11 07:15:00 | SPY | ETF | 379.0 | 379.08 | 378.8 | 378.85 | 33519.0 |
| 2021-01-11 07:20:00 | SPY | ETF | 378.89 | 378.89 | 378.75 | 378.75 | 31818.0 |
| 2021-01-11 07:25:00 | SPY | ETF | 378.78 | 379.19 | 378.72 | 379.15 | 21730.0 |
| 2021-01-11 07:30:00 | SPY | ETF | 379.2 | 379.23 | 379.14 | 379.22 | 10402.0 |
| 2021-01-11 07:35:00 | SPY | ETF | 379.18 | 379.25 | 379.01 | 379.09 | 37800.0 |
| 2021-01-11 07:40:00 | SPY | ETF | 379.2 | 379.28 | 379.19 | 379.27 | 16867.0 |
| 2021-01-11 07:45:00 | SPY | ETF | 379.26 | 379.28 | 379.15 | 379.28 | 22086.0 |
| 2021-01-11 07:50:00 | SPY | ETF | 379.27 | 379.27 | 379.1 | 379.1 | 5946.0 |
| 2021-01-11 07:55:00 | SPY | ETF | 379.1 | 379.28 | 379.08 | 379.25 | 21271.0 |
| 2021-01-11 08:00:00 | SPY | ETF | 379.19 | 379.81 | 378.74 | 378.74 | 87629.0 |
| 2021-01-11 08:05:00 | SPY | ETF | 378.81 | 378.96 | 378.8 | 378.8 | 22291.0 |
| 2021-01-11 08:10:00 | SPY | ETF | 378.9 | 379.18 | 378.9 | 379.07 | 22668.0 |
> showing 50 of 86,315 rows — these rows as CSV