PREVIEW / etf_5min / 2020-09-14
file: by_date/etf_5min/2020/2020-09-14.parquet size: 1.6 MB rows: 72,052
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-14 04:00:00 | SPY | ETF | 338.1 | 338.54 | 338.1 | 338.54 | 10998.0 |
| 2020-09-14 04:05:00 | SPY | ETF | 338.53 | 338.57 | 338.29 | 338.29 | 4325.0 |
| 2020-09-14 04:10:00 | SPY | ETF | 338.27 | 338.43 | 338.27 | 338.39 | 986.0 |
| 2020-09-14 04:15:00 | SPY | ETF | 338.35 | 338.35 | 338.31 | 338.31 | 623.0 |
| 2020-09-14 04:20:00 | SPY | ETF | 338.23 | 338.23 | 338.03 | 338.03 | 3753.0 |
| 2020-09-14 04:25:00 | SPY | ETF | 338.06 | 338.06 | 337.84 | 337.84 | 8057.0 |
| 2020-09-14 04:30:00 | SPY | ETF | 337.81 | 337.81 | 337.6 | 337.6 | 660.0 |
| 2020-09-14 04:35:00 | SPY | ETF | 337.53 | 337.66 | 337.53 | 337.65 | 5937.0 |
| 2020-09-14 04:40:00 | SPY | ETF | 337.66 | 337.71 | 337.44 | 337.64 | 1611.0 |
| 2020-09-14 04:45:00 | SPY | ETF | 337.53 | 337.66 | 337.53 | 337.66 | 4966.0 |
| 2020-09-14 04:50:00 | SPY | ETF | 337.54 | 337.62 | 337.35 | 337.35 | 769.0 |
| 2020-09-14 04:55:00 | SPY | ETF | 337.35 | 337.48 | 337.35 | 337.43 | 1800.0 |
| 2020-09-14 05:00:00 | SPY | ETF | 337.36 | 337.46 | 337.36 | 337.46 | 482.0 |
| 2020-09-14 05:05:00 | SPY | ETF | 337.57 | 337.57 | 337.36 | 337.36 | 1276.0 |
| 2020-09-14 05:10:00 | SPY | ETF | 337.35 | 337.43 | 337.3 | 337.3 | 2596.0 |
| 2020-09-14 05:15:00 | SPY | ETF | 337.39 | 337.39 | 337.33 | 337.33 | 2211.0 |
| 2020-09-14 05:20:00 | SPY | ETF | 337.3 | 337.66 | 337.3 | 337.65 | 831.0 |
| 2020-09-14 05:25:00 | SPY | ETF | 337.69 | 337.7 | 337.69 | 337.7 | 2006.0 |
| 2020-09-14 05:30:00 | SPY | ETF | 337.7 | 337.7 | 337.51 | 337.51 | 813.0 |
| 2020-09-14 05:35:00 | SPY | ETF | 337.3 | 337.3 | 336.95 | 336.95 | 4422.0 |
| 2020-09-14 05:40:00 | SPY | ETF | 336.94 | 336.94 | 336.73 | 336.73 | 6201.0 |
| 2020-09-14 05:45:00 | SPY | ETF | 336.58 | 336.7 | 336.55 | 336.68 | 5679.0 |
| 2020-09-14 05:50:00 | SPY | ETF | 336.65 | 336.83 | 336.59 | 336.82 | 2175.0 |
| 2020-09-14 06:00:00 | SPY | ETF | 336.69 | 336.88 | 336.69 | 336.88 | 784.0 |
| 2020-09-14 06:05:00 | SPY | ETF | 336.88 | 337.06 | 336.88 | 336.97 | 2704.0 |
| 2020-09-14 06:10:00 | SPY | ETF | 336.98 | 337.12 | 336.98 | 337.0 | 4186.0 |
| 2020-09-14 06:15:00 | SPY | ETF | 336.95 | 337.01 | 336.9 | 337.01 | 1700.0 |
| 2020-09-14 06:20:00 | SPY | ETF | 337.1 | 337.1 | 336.67 | 336.68 | 1018.0 |
| 2020-09-14 06:25:00 | SPY | ETF | 336.78 | 336.79 | 336.7 | 336.79 | 3705.0 |
| 2020-09-14 06:30:00 | SPY | ETF | 336.7 | 336.96 | 336.7 | 336.94 | 27168.0 |
| 2020-09-14 06:35:00 | SPY | ETF | 337.02 | 337.03 | 337.02 | 337.03 | 2500.0 |
| 2020-09-14 06:40:00 | SPY | ETF | 337.03 | 337.21 | 337.03 | 337.16 | 7954.0 |
| 2020-09-14 06:45:00 | SPY | ETF | 337.13 | 337.28 | 337.13 | 337.28 | 10048.0 |
| 2020-09-14 06:50:00 | SPY | ETF | 337.28 | 337.31 | 337.14 | 337.26 | 1801.0 |
| 2020-09-14 06:55:00 | SPY | ETF | 337.18 | 337.46 | 337.18 | 337.46 | 2719.0 |
| 2020-09-14 07:00:00 | SPY | ETF | 337.45 | 337.49 | 337.26 | 337.28 | 18875.0 |
| 2020-09-14 07:05:00 | SPY | ETF | 337.31 | 337.51 | 337.31 | 337.48 | 25695.0 |
| 2020-09-14 07:10:00 | SPY | ETF | 337.48 | 337.56 | 337.36 | 337.51 | 14470.0 |
| 2020-09-14 07:15:00 | SPY | ETF | 337.51 | 337.59 | 337.46 | 337.53 | 8517.0 |
| 2020-09-14 07:20:00 | SPY | ETF | 337.47 | 337.76 | 337.47 | 337.76 | 14976.0 |
| 2020-09-14 07:25:00 | SPY | ETF | 337.74 | 337.84 | 337.73 | 337.74 | 19597.0 |
| 2020-09-14 07:30:00 | SPY | ETF | 337.7 | 337.78 | 337.57 | 337.7 | 8413.0 |
| 2020-09-14 07:35:00 | SPY | ETF | 337.71 | 337.71 | 337.58 | 337.67 | 3242.0 |
| 2020-09-14 07:40:00 | SPY | ETF | 337.67 | 337.68 | 337.4 | 337.4 | 2373.0 |
| 2020-09-14 07:45:00 | SPY | ETF | 337.43 | 337.51 | 337.38 | 337.42 | 22522.0 |
| 2020-09-14 07:50:00 | SPY | ETF | 337.57 | 337.6 | 337.5 | 337.6 | 5560.0 |
| 2020-09-14 07:55:00 | SPY | ETF | 337.58 | 337.58 | 337.24 | 337.24 | 18349.0 |
| 2020-09-14 08:00:00 | SPY | ETF | 337.6 | 338.35 | 337.05 | 337.08 | 49394.0 |
| 2020-09-14 08:05:00 | SPY | ETF | 337.59 | 337.59 | 336.96 | 337.18 | 12996.0 |
| 2020-09-14 08:10:00 | SPY | ETF | 337.18 | 337.3 | 337.16 | 337.21 | 11683.0 |
> showing 50 of 72,052 rows — these rows as CSV