PREVIEW / etf_5min / 2021-01-19
file: by_date/etf_5min/2021/2021-01-19.parquet size: 1.9 MB rows: 88,888
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-19 04:00:00 | SPY | ETF | 377.7 | 378.19 | 377.7 | 378.19 | 21049.0 |
| 2021-01-19 04:05:00 | SPY | ETF | 378.17 | 378.17 | 377.99 | 378.05 | 4440.0 |
| 2021-01-19 04:10:00 | SPY | ETF | 378.0 | 378.06 | 377.97 | 378.0 | 2347.0 |
| 2021-01-19 04:15:00 | SPY | ETF | 378.03 | 378.03 | 377.84 | 377.84 | 2748.0 |
| 2021-01-19 04:20:00 | SPY | ETF | 377.95 | 378.0 | 377.89 | 377.98 | 12721.0 |
| 2021-01-19 04:25:00 | SPY | ETF | 377.95 | 377.95 | 377.77 | 377.82 | 3411.0 |
| 2021-01-19 04:30:00 | SPY | ETF | 377.8 | 378.07 | 377.79 | 378.07 | 2779.0 |
| 2021-01-19 04:35:00 | SPY | ETF | 378.03 | 378.04 | 378.03 | 378.04 | 300.0 |
| 2021-01-19 04:40:00 | SPY | ETF | 378.01 | 378.13 | 378.01 | 378.13 | 865.0 |
| 2021-01-19 04:45:00 | SPY | ETF | 378.2 | 378.2 | 378.19 | 378.19 | 207.0 |
| 2021-01-19 04:50:00 | SPY | ETF | 378.31 | 378.46 | 378.31 | 378.36 | 4686.0 |
| 2021-01-19 04:55:00 | SPY | ETF | 378.31 | 378.31 | 378.23 | 378.28 | 3632.0 |
| 2021-01-19 05:00:00 | SPY | ETF | 378.36 | 378.36 | 378.28 | 378.32 | 2017.0 |
| 2021-01-19 05:05:00 | SPY | ETF | 378.29 | 378.38 | 378.29 | 378.38 | 905.0 |
| 2021-01-19 05:10:00 | SPY | ETF | 378.36 | 378.39 | 378.26 | 378.26 | 9376.0 |
| 2021-01-19 05:15:00 | SPY | ETF | 378.24 | 378.27 | 378.23 | 378.24 | 1051.0 |
| 2021-01-19 05:20:00 | SPY | ETF | 378.23 | 378.27 | 378.18 | 378.18 | 1351.0 |
| 2021-01-19 05:25:00 | SPY | ETF | 378.1 | 378.19 | 378.05 | 378.15 | 8492.0 |
| 2021-01-19 05:30:00 | SPY | ETF | 378.15 | 378.24 | 378.15 | 378.21 | 3355.0 |
| 2021-01-19 05:35:00 | SPY | ETF | 378.2 | 378.35 | 378.2 | 378.33 | 5920.0 |
| 2021-01-19 05:40:00 | SPY | ETF | 378.29 | 378.53 | 378.29 | 378.53 | 6805.0 |
| 2021-01-19 05:45:00 | SPY | ETF | 378.49 | 378.5 | 378.41 | 378.45 | 2927.0 |
| 2021-01-19 05:50:00 | SPY | ETF | 378.36 | 378.36 | 378.36 | 378.36 | 150.0 |
| 2021-01-19 05:55:00 | SPY | ETF | 378.31 | 378.32 | 378.29 | 378.32 | 22754.0 |
| 2021-01-19 06:00:00 | SPY | ETF | 378.36 | 378.48 | 378.36 | 378.48 | 386.0 |
| 2021-01-19 06:05:00 | SPY | ETF | 378.48 | 378.59 | 378.48 | 378.56 | 4958.0 |
| 2021-01-19 06:10:00 | SPY | ETF | 378.57 | 378.67 | 378.53 | 378.62 | 6011.0 |
| 2021-01-19 06:15:00 | SPY | ETF | 378.7 | 378.72 | 378.63 | 378.7 | 3836.0 |
| 2021-01-19 06:20:00 | SPY | ETF | 378.68 | 378.68 | 378.63 | 378.63 | 1855.0 |
| 2021-01-19 06:25:00 | SPY | ETF | 378.61 | 378.67 | 378.57 | 378.67 | 4835.0 |
| 2021-01-19 06:30:00 | SPY | ETF | 378.69 | 378.69 | 378.59 | 378.59 | 1403.0 |
| 2021-01-19 06:35:00 | SPY | ETF | 378.55 | 378.57 | 378.55 | 378.57 | 1952.0 |
| 2021-01-19 06:40:00 | SPY | ETF | 378.58 | 378.62 | 378.58 | 378.62 | 1635.0 |
| 2021-01-19 06:45:00 | SPY | ETF | 378.65 | 378.65 | 378.53 | 378.57 | 5909.0 |
| 2021-01-19 06:50:00 | SPY | ETF | 378.57 | 378.57 | 378.52 | 378.52 | 878.0 |
| 2021-01-19 06:55:00 | SPY | ETF | 378.63 | 378.68 | 378.62 | 378.64 | 9910.0 |
| 2021-01-19 07:00:00 | SPY | ETF | 378.65 | 378.67 | 378.28 | 378.32 | 105859.0 |
| 2021-01-19 07:05:00 | SPY | ETF | 378.31 | 378.35 | 378.25 | 378.35 | 10065.0 |
| 2021-01-19 07:10:00 | SPY | ETF | 378.37 | 378.45 | 378.33 | 378.41 | 8762.0 |
| 2021-01-19 07:15:00 | SPY | ETF | 378.35 | 378.46 | 378.31 | 378.41 | 11839.0 |
| 2021-01-19 07:20:00 | SPY | ETF | 378.4 | 378.51 | 378.39 | 378.5 | 32932.0 |
| 2021-01-19 07:25:00 | SPY | ETF | 378.47 | 378.47 | 378.28 | 378.28 | 10075.0 |
| 2021-01-19 07:30:00 | SPY | ETF | 378.26 | 378.26 | 378.1 | 378.18 | 8413.0 |
| 2021-01-19 07:35:00 | SPY | ETF | 378.19 | 378.25 | 378.17 | 378.24 | 4725.0 |
| 2021-01-19 07:40:00 | SPY | ETF | 378.23 | 378.28 | 378.16 | 378.26 | 9903.0 |
| 2021-01-19 07:45:00 | SPY | ETF | 378.26 | 378.45 | 378.23 | 378.37 | 10134.0 |
| 2021-01-19 07:50:00 | SPY | ETF | 378.36 | 378.36 | 378.25 | 378.36 | 4340.0 |
| 2021-01-19 07:55:00 | SPY | ETF | 378.34 | 378.45 | 378.33 | 378.45 | 31438.0 |
| 2021-01-19 08:00:00 | SPY | ETF | 378.46 | 378.68 | 377.85 | 378.5096 | 83263.0 |
| 2021-01-19 08:05:00 | SPY | ETF | 378.4902 | 378.53 | 378.38 | 378.38 | 56768.0 |
> showing 50 of 88,888 rows — these rows as CSV