PREVIEW / etf_5min / 2020-05-20
file: by_date/etf_5min/2020/2020-05-20.parquet size: 1.6 MB rows: 74,754
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 |
|---|---|---|---|---|---|---|---|
| 2020-05-20 04:00:00 | SPY | ETF | 293.38 | 293.73 | 293.38 | 293.63 | 6716.0 |
| 2020-05-20 04:05:00 | SPY | ETF | 293.62 | 293.95 | 293.62 | 293.95 | 2009.0 |
| 2020-05-20 04:10:00 | SPY | ETF | 293.97 | 294.29 | 293.97 | 294.28 | 5560.0 |
| 2020-05-20 04:15:00 | SPY | ETF | 294.31 | 294.89 | 294.31 | 294.73 | 20925.0 |
| 2020-05-20 04:20:00 | SPY | ETF | 294.92 | 295.05 | 294.9 | 294.92 | 9273.0 |
| 2020-05-20 04:25:00 | SPY | ETF | 294.98 | 295.0 | 294.85 | 294.97 | 5019.0 |
| 2020-05-20 04:30:00 | SPY | ETF | 294.99 | 295.0 | 294.76 | 294.76 | 5315.0 |
| 2020-05-20 04:35:00 | SPY | ETF | 294.7 | 294.97 | 294.7 | 294.85 | 3905.0 |
| 2020-05-20 04:40:00 | SPY | ETF | 294.87 | 294.91 | 294.67 | 294.7 | 1469.0 |
| 2020-05-20 04:45:00 | SPY | ETF | 294.7 | 294.88 | 294.66 | 294.87 | 5794.0 |
| 2020-05-20 04:50:00 | SPY | ETF | 294.88 | 294.9 | 294.63 | 294.7 | 5874.0 |
| 2020-05-20 04:55:00 | SPY | ETF | 294.73 | 294.76 | 294.66 | 294.76 | 1215.0 |
| 2020-05-20 05:00:00 | SPY | ETF | 294.73 | 294.8 | 294.67 | 294.67 | 853.0 |
| 2020-05-20 05:05:00 | SPY | ETF | 294.65 | 294.93 | 294.57 | 294.93 | 3912.0 |
| 2020-05-20 05:10:00 | SPY | ETF | 295.0 | 295.03 | 294.87 | 294.91 | 6666.0 |
| 2020-05-20 05:15:00 | SPY | ETF | 294.75 | 294.78 | 294.68 | 294.78 | 472.0 |
| 2020-05-20 05:20:00 | SPY | ETF | 294.72 | 295.0 | 294.65 | 294.97 | 12259.0 |
| 2020-05-20 05:25:00 | SPY | ETF | 295.0 | 295.08 | 295.0 | 295.0 | 21019.0 |
| 2020-05-20 05:30:00 | SPY | ETF | 294.89 | 294.89 | 294.74 | 294.74 | 17010.0 |
| 2020-05-20 05:35:00 | SPY | ETF | 294.77 | 294.93 | 294.75 | 294.8 | 7564.0 |
| 2020-05-20 05:40:00 | SPY | ETF | 294.75 | 295.29 | 294.75 | 295.24 | 16883.0 |
| 2020-05-20 05:45:00 | SPY | ETF | 295.25 | 295.29 | 295.17 | 295.2 | 18227.0 |
| 2020-05-20 05:50:00 | SPY | ETF | 295.27 | 295.46 | 295.27 | 295.46 | 22712.0 |
| 2020-05-20 05:55:00 | SPY | ETF | 295.39 | 295.68 | 295.39 | 295.6 | 14506.0 |
| 2020-05-20 06:00:00 | SPY | ETF | 295.57 | 295.65 | 295.48 | 295.56 | 8048.0 |
| 2020-05-20 06:05:00 | SPY | ETF | 295.72 | 295.72 | 295.57 | 295.57 | 4866.0 |
| 2020-05-20 06:10:00 | SPY | ETF | 295.62 | 295.62 | 295.48 | 295.48 | 24665.0 |
| 2020-05-20 06:15:00 | SPY | ETF | 295.55 | 295.7 | 295.55 | 295.63 | 17539.0 |
| 2020-05-20 06:20:00 | SPY | ETF | 295.68 | 295.74 | 295.63 | 295.64 | 14190.0 |
| 2020-05-20 06:25:00 | SPY | ETF | 295.65 | 295.65 | 295.44 | 295.44 | 11237.0 |
| 2020-05-20 06:30:00 | SPY | ETF | 295.52 | 295.53 | 295.41 | 295.49 | 2860.0 |
| 2020-05-20 06:35:00 | SPY | ETF | 295.48 | 295.68 | 295.45 | 295.62 | 13457.0 |
| 2020-05-20 06:40:00 | SPY | ETF | 295.55 | 295.7 | 295.5 | 295.51 | 7870.0 |
| 2020-05-20 06:45:00 | SPY | ETF | 295.51 | 295.52 | 295.32 | 295.45 | 6727.0 |
| 2020-05-20 06:50:00 | SPY | ETF | 295.45 | 295.59 | 295.22 | 295.59 | 39409.0 |
| 2020-05-20 06:55:00 | SPY | ETF | 295.55 | 295.55 | 295.4 | 295.52 | 3946.0 |
| 2020-05-20 07:00:00 | SPY | ETF | 295.43 | 295.51 | 295.32 | 295.38 | 53267.0 |
| 2020-05-20 07:05:00 | SPY | ETF | 295.41 | 295.48 | 295.3 | 295.3 | 27836.0 |
| 2020-05-20 07:10:00 | SPY | ETF | 295.35 | 295.37 | 295.13 | 295.29 | 52639.0 |
| 2020-05-20 07:15:00 | SPY | ETF | 295.28 | 295.39 | 295.15 | 295.15 | 33734.0 |
| 2020-05-20 07:20:00 | SPY | ETF | 295.19 | 295.2 | 295.06 | 295.09 | 25694.0 |
| 2020-05-20 07:25:00 | SPY | ETF | 295.15 | 295.25 | 295.08 | 295.16 | 37365.0 |
| 2020-05-20 07:30:00 | SPY | ETF | 295.25 | 295.31 | 295.11 | 295.2 | 45956.0 |
| 2020-05-20 07:35:00 | SPY | ETF | 295.2 | 295.45 | 295.16 | 295.4 | 81373.0 |
| 2020-05-20 07:40:00 | SPY | ETF | 295.43 | 295.63 | 295.34 | 295.55 | 54202.0 |
| 2020-05-20 07:45:00 | SPY | ETF | 295.56 | 295.56 | 295.36 | 295.36 | 74494.0 |
| 2020-05-20 07:50:00 | SPY | ETF | 295.36 | 295.52 | 295.28 | 295.46 | 55365.0 |
| 2020-05-20 07:55:00 | SPY | ETF | 295.46 | 295.5 | 295.4 | 295.45 | 39901.0 |
| 2020-05-20 08:00:00 | SPY | ETF | 292.13 | 295.6404 | 292.13 | 295.36 | 217227.0 |
| 2020-05-20 08:05:00 | SPY | ETF | 295.4 | 295.5 | 295.3 | 295.5 | 18944.0 |
> showing 50 of 74,754 rows — these rows as CSV