PREVIEW / etf_5min / 2019-08-30
file: by_date/etf_5min/2019/2019-08-30.parquet size: 1.4 MB rows: 60,508
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 |
|---|---|---|---|---|---|---|---|
| 2019-08-30 04:00:00 | SPY | ETF | 293.52 | 293.6 | 293.51 | 293.51 | 2518.0 |
| 2019-08-30 04:05:00 | SPY | ETF | 293.54 | 293.64 | 293.54 | 293.64 | 1419.0 |
| 2019-08-30 04:10:00 | SPY | ETF | 293.7 | 293.7 | 293.7 | 293.7 | 105.0 |
| 2019-08-30 04:15:00 | SPY | ETF | 293.67 | 293.67 | 293.67 | 293.67 | 350.0 |
| 2019-08-30 04:20:00 | SPY | ETF | 293.67 | 293.72 | 293.67 | 293.72 | 319.0 |
| 2019-08-30 04:25:00 | SPY | ETF | 293.69 | 293.74 | 293.69 | 293.7 | 1100.0 |
| 2019-08-30 04:30:00 | SPY | ETF | 293.7 | 293.7 | 293.7 | 293.7 | 700.0 |
| 2019-08-30 04:35:00 | SPY | ETF | 293.7 | 293.79 | 293.7 | 293.79 | 3450.0 |
| 2019-08-30 04:40:00 | SPY | ETF | 293.75 | 293.75 | 293.75 | 293.75 | 1255.0 |
| 2019-08-30 04:45:00 | SPY | ETF | 293.82 | 294.01 | 293.82 | 293.97 | 11503.0 |
| 2019-08-30 04:50:00 | SPY | ETF | 293.97 | 294.24 | 293.97 | 294.05 | 6924.0 |
| 2019-08-30 04:55:00 | SPY | ETF | 294.02 | 294.15 | 294.02 | 294.15 | 4570.0 |
| 2019-08-30 05:00:00 | SPY | ETF | 294.12 | 294.12 | 294.1 | 294.1 | 900.0 |
| 2019-08-30 05:05:00 | SPY | ETF | 294.15 | 294.17 | 294.12 | 294.17 | 4400.0 |
| 2019-08-30 05:10:00 | SPY | ETF | 294.24 | 294.35 | 294.24 | 294.34 | 4502.0 |
| 2019-08-30 05:15:00 | SPY | ETF | 294.24 | 294.25 | 294.24 | 294.25 | 3600.0 |
| 2019-08-30 05:20:00 | SPY | ETF | 294.29 | 294.34 | 294.29 | 294.34 | 490.0 |
| 2019-08-30 05:25:00 | SPY | ETF | 294.3 | 294.36 | 294.3 | 294.36 | 690.0 |
| 2019-08-30 05:30:00 | SPY | ETF | 294.38 | 294.44 | 294.37 | 294.41 | 1450.0 |
| 2019-08-30 05:35:00 | SPY | ETF | 294.36 | 294.42 | 294.29 | 294.42 | 1130.0 |
| 2019-08-30 05:40:00 | SPY | ETF | 294.31 | 294.37 | 294.31 | 294.37 | 200.0 |
| 2019-08-30 05:45:00 | SPY | ETF | 294.34 | 294.41 | 294.34 | 294.36 | 5123.0 |
| 2019-08-30 05:50:00 | SPY | ETF | 294.39 | 294.64 | 294.39 | 294.63 | 12303.0 |
| 2019-08-30 05:55:00 | SPY | ETF | 294.64 | 294.71 | 294.56 | 294.71 | 9756.0 |
| 2019-08-30 06:00:00 | SPY | ETF | 294.61 | 294.61 | 294.56 | 294.56 | 2900.0 |
| 2019-08-30 06:05:00 | SPY | ETF | 294.48 | 294.67 | 294.46 | 294.67 | 21050.0 |
| 2019-08-30 06:10:00 | SPY | ETF | 294.61 | 294.61 | 294.61 | 294.61 | 5000.0 |
| 2019-08-30 06:15:00 | SPY | ETF | 294.53 | 294.54 | 294.5 | 294.54 | 6609.0 |
| 2019-08-30 06:20:00 | SPY | ETF | 294.5 | 294.58 | 294.41 | 294.58 | 3866.0 |
| 2019-08-30 06:25:00 | SPY | ETF | 294.56 | 294.61 | 294.52 | 294.54 | 4409.0 |
| 2019-08-30 06:30:00 | SPY | ETF | 294.51 | 294.57 | 294.51 | 294.57 | 430.0 |
| 2019-08-30 06:35:00 | SPY | ETF | 294.59 | 294.59 | 294.53 | 294.53 | 4177.0 |
| 2019-08-30 06:40:00 | SPY | ETF | 294.51 | 294.64 | 294.51 | 294.64 | 3770.0 |
| 2019-08-30 06:45:00 | SPY | ETF | 294.6 | 294.62 | 294.59 | 294.62 | 2550.0 |
| 2019-08-30 06:50:00 | SPY | ETF | 294.61 | 294.63 | 294.54 | 294.55 | 14904.0 |
| 2019-08-30 06:55:00 | SPY | ETF | 294.62 | 294.62 | 294.48 | 294.61 | 15835.0 |
| 2019-08-30 07:00:00 | SPY | ETF | 294.58 | 294.65 | 294.58 | 294.61 | 39035.0 |
| 2019-08-30 07:05:00 | SPY | ETF | 294.61 | 294.67 | 294.6 | 294.6 | 17393.0 |
| 2019-08-30 07:10:00 | SPY | ETF | 294.6 | 294.64 | 294.47 | 294.47 | 19500.0 |
| 2019-08-30 07:15:00 | SPY | ETF | 294.47 | 294.52 | 294.38 | 294.4 | 46140.0 |
| 2019-08-30 07:20:00 | SPY | ETF | 294.38 | 294.38 | 294.28 | 294.28 | 24078.0 |
| 2019-08-30 07:25:00 | SPY | ETF | 294.35 | 294.37 | 294.17 | 294.22 | 54630.0 |
| 2019-08-30 07:30:00 | SPY | ETF | 294.22 | 294.35 | 294.18 | 294.35 | 38517.0 |
| 2019-08-30 07:35:00 | SPY | ETF | 294.37 | 294.39 | 294.3 | 294.37 | 30534.0 |
| 2019-08-30 07:40:00 | SPY | ETF | 294.33 | 294.4 | 294.33 | 294.4 | 3336.0 |
| 2019-08-30 07:45:00 | SPY | ETF | 294.39 | 294.4 | 294.37 | 294.4 | 2020.0 |
| 2019-08-30 07:50:00 | SPY | ETF | 294.39 | 294.56 | 294.39 | 294.56 | 33799.0 |
| 2019-08-30 07:55:00 | SPY | ETF | 294.51 | 294.54 | 294.5 | 294.54 | 4369.0 |
| 2019-08-30 08:00:00 | SPY | ETF | 294.64 | 294.66 | 292.65 | 294.47 | 38461.0 |
| 2019-08-30 08:05:00 | SPY | ETF | 294.47 | 294.53 | 294.42 | 294.52 | 22137.0 |
> showing 50 of 60,508 rows — these rows as CSV