PREVIEW / etf_5min / 2020-09-16
file: by_date/etf_5min/2020/2020-09-16.parquet size: 1.6 MB rows: 72,245
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-09-16 04:00:00 | SPY | ETF | 341.36 | 341.37 | 341.25 | 341.37 | 865.0 |
| 2020-09-16 04:05:00 | SPY | ETF | 341.42 | 341.67 | 341.42 | 341.67 | 1022.0 |
| 2020-09-16 04:10:00 | SPY | ETF | 341.72 | 341.87 | 341.7 | 341.87 | 1521.0 |
| 2020-09-16 04:15:00 | SPY | ETF | 342.0 | 342.01 | 341.89 | 342.01 | 1804.0 |
| 2020-09-16 04:20:00 | SPY | ETF | 342.08 | 342.16 | 342.08 | 342.16 | 5039.0 |
| 2020-09-16 04:25:00 | SPY | ETF | 342.21 | 342.21 | 342.15 | 342.15 | 2335.0 |
| 2020-09-16 04:30:00 | SPY | ETF | 342.09 | 342.09 | 342.07 | 342.07 | 722.0 |
| 2020-09-16 04:35:00 | SPY | ETF | 342.11 | 342.16 | 342.11 | 342.16 | 300.0 |
| 2020-09-16 04:40:00 | SPY | ETF | 342.12 | 342.13 | 342.11 | 342.13 | 650.0 |
| 2020-09-16 04:45:00 | SPY | ETF | 342.06 | 342.06 | 342.04 | 342.04 | 970.0 |
| 2020-09-16 04:50:00 | SPY | ETF | 342.06 | 342.06 | 342.06 | 342.06 | 151.0 |
| 2020-09-16 05:00:00 | SPY | ETF | 342.16 | 342.28 | 342.0 | 342.0 | 865.0 |
| 2020-09-16 05:05:00 | SPY | ETF | 342.02 | 342.06 | 342.02 | 342.06 | 575.0 |
| 2020-09-16 05:10:00 | SPY | ETF | 342.09 | 342.2 | 342.09 | 342.2 | 601.0 |
| 2020-09-16 05:15:00 | SPY | ETF | 342.06 | 342.06 | 342.06 | 342.06 | 250.0 |
| 2020-09-16 05:20:00 | SPY | ETF | 342.1 | 342.24 | 342.1 | 342.24 | 255.0 |
| 2020-09-16 05:25:00 | SPY | ETF | 342.28 | 342.42 | 342.28 | 342.42 | 4542.0 |
| 2020-09-16 05:30:00 | SPY | ETF | 342.33 | 342.33 | 342.33 | 342.33 | 119.0 |
| 2020-09-16 05:35:00 | SPY | ETF | 342.31 | 342.35 | 342.31 | 342.35 | 602.0 |
| 2020-09-16 05:40:00 | SPY | ETF | 342.46 | 342.46 | 342.3 | 342.3 | 713.0 |
| 2020-09-16 05:50:00 | SPY | ETF | 342.27 | 342.4 | 342.26 | 342.4 | 1635.0 |
| 2020-09-16 05:55:00 | SPY | ETF | 342.43 | 342.48 | 342.43 | 342.48 | 3701.0 |
| 2020-09-16 06:00:00 | SPY | ETF | 342.4 | 342.41 | 342.33 | 342.34 | 1000.0 |
| 2020-09-16 06:05:00 | SPY | ETF | 342.26 | 342.3 | 342.26 | 342.29 | 788.0 |
| 2020-09-16 06:10:00 | SPY | ETF | 342.3 | 342.31 | 342.2 | 342.23 | 2790.0 |
| 2020-09-16 06:15:00 | SPY | ETF | 342.26 | 342.37 | 342.16 | 342.21 | 1300.0 |
| 2020-09-16 06:25:00 | SPY | ETF | 342.1 | 342.11 | 342.05 | 342.05 | 3760.0 |
| 2020-09-16 06:30:00 | SPY | ETF | 342.0 | 342.07 | 341.97 | 341.97 | 1461.0 |
| 2020-09-16 06:35:00 | SPY | ETF | 342.06 | 342.2 | 342.06 | 342.2 | 2529.0 |
| 2020-09-16 06:40:00 | SPY | ETF | 342.13 | 342.3 | 342.13 | 342.3 | 2250.0 |
| 2020-09-16 06:45:00 | SPY | ETF | 342.33 | 342.62 | 342.32 | 342.62 | 7725.0 |
| 2020-09-16 06:50:00 | SPY | ETF | 342.59 | 342.8 | 342.59 | 342.79 | 19964.0 |
| 2020-09-16 06:55:00 | SPY | ETF | 342.82 | 342.92 | 342.73 | 342.73 | 15301.0 |
| 2020-09-16 07:00:00 | SPY | ETF | 342.68 | 342.76 | 342.59 | 342.62 | 42515.0 |
| 2020-09-16 07:05:00 | SPY | ETF | 342.61 | 342.7 | 342.57 | 342.61 | 12571.0 |
| 2020-09-16 07:10:00 | SPY | ETF | 342.57 | 342.61 | 342.47 | 342.49 | 7124.0 |
| 2020-09-16 07:15:00 | SPY | ETF | 342.45 | 342.46 | 342.14 | 342.19 | 30998.0 |
| 2020-09-16 07:20:00 | SPY | ETF | 342.19 | 342.25 | 341.98 | 342.0 | 11643.0 |
| 2020-09-16 07:25:00 | SPY | ETF | 342.06 | 342.06 | 341.96 | 341.96 | 8044.0 |
| 2020-09-16 07:30:00 | SPY | ETF | 341.89 | 342.05 | 341.89 | 342.05 | 16751.0 |
| 2020-09-16 07:35:00 | SPY | ETF | 342.02 | 342.05 | 341.95 | 342.03 | 4781.0 |
| 2020-09-16 07:40:00 | SPY | ETF | 342.04 | 342.16 | 341.97 | 342.11 | 51514.0 |
| 2020-09-16 07:45:00 | SPY | ETF | 342.12 | 342.38 | 342.06 | 342.3 | 38884.0 |
| 2020-09-16 07:50:00 | SPY | ETF | 342.3 | 342.3 | 342.23 | 342.27 | 4900.0 |
| 2020-09-16 07:55:00 | SPY | ETF | 342.28 | 342.36 | 342.23 | 342.36 | 11775.0 |
| 2020-09-16 08:00:00 | SPY | ETF | 342.4999 | 342.81 | 341.05 | 342.36 | 43350.0 |
| 2020-09-16 08:05:00 | SPY | ETF | 342.36 | 342.44 | 342.35 | 342.41 | 30566.0 |
| 2020-09-16 08:10:00 | SPY | ETF | 342.38 | 342.41 | 342.33 | 342.41 | 11015.0 |
| 2020-09-16 08:15:00 | SPY | ETF | 342.44 | 342.46 | 342.4 | 342.41 | 10951.0 |
| 2020-09-16 08:20:00 | SPY | ETF | 342.41 | 342.48 | 342.4 | 342.45 | 31834.0 |
> showing 50 of 72,245 rows — these rows as CSV