PREVIEW / etf_5min / 2019-06-25
file: by_date/etf_5min/2019/2019-06-25.parquet size: 1.4 MB rows: 62,960
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-06-25 04:00:00 | SPY | ETF | 293.22 | 293.34 | 293.15 | 293.33 | 3684.0 |
| 2019-06-25 04:15:00 | SPY | ETF | 293.23 | 293.23 | 293.23 | 293.23 | 100.0 |
| 2019-06-25 04:20:00 | SPY | ETF | 293.3 | 293.3 | 293.3 | 293.3 | 900.0 |
| 2019-06-25 04:30:00 | SPY | ETF | 293.4 | 293.4 | 293.4 | 293.4 | 530.0 |
| 2019-06-25 04:35:00 | SPY | ETF | 293.44 | 293.55 | 293.44 | 293.55 | 2704.0 |
| 2019-06-25 04:40:00 | SPY | ETF | 293.5 | 293.5 | 293.5 | 293.5 | 250.0 |
| 2019-06-25 04:55:00 | SPY | ETF | 293.23 | 293.23 | 293.23 | 293.23 | 100.0 |
| 2019-06-25 05:00:00 | SPY | ETF | 293.2 | 293.2 | 293.2 | 293.2 | 100.0 |
| 2019-06-25 05:15:00 | SPY | ETF | 293.2 | 293.2 | 293.2 | 293.2 | 100.0 |
| 2019-06-25 05:20:00 | SPY | ETF | 293.3 | 293.3 | 293.3 | 293.3 | 100.0 |
| 2019-06-25 05:25:00 | SPY | ETF | 293.28 | 293.28 | 293.28 | 293.28 | 1000.0 |
| 2019-06-25 05:40:00 | SPY | ETF | 293.41 | 293.41 | 293.36 | 293.36 | 1500.0 |
| 2019-06-25 05:45:00 | SPY | ETF | 293.41 | 293.41 | 293.41 | 293.41 | 100.0 |
| 2019-06-25 05:55:00 | SPY | ETF | 293.34 | 293.34 | 293.34 | 293.34 | 121.0 |
| 2019-06-25 06:00:00 | SPY | ETF | 293.33 | 293.33 | 293.24 | 293.24 | 600.0 |
| 2019-06-25 06:05:00 | SPY | ETF | 293.26 | 293.26 | 293.26 | 293.26 | 100.0 |
| 2019-06-25 06:20:00 | SPY | ETF | 293.29 | 293.3 | 293.29 | 293.3 | 1100.0 |
| 2019-06-25 06:25:00 | SPY | ETF | 293.3 | 293.3 | 293.3 | 293.3 | 302.0 |
| 2019-06-25 06:30:00 | SPY | ETF | 293.28 | 293.28 | 293.27 | 293.28 | 2525.0 |
| 2019-06-25 06:35:00 | SPY | ETF | 293.2 | 293.2 | 293.2 | 293.2 | 342.0 |
| 2019-06-25 06:40:00 | SPY | ETF | 293.3 | 293.31 | 293.3 | 293.31 | 1127.0 |
| 2019-06-25 06:45:00 | SPY | ETF | 293.31 | 293.31 | 293.24 | 293.24 | 3155.0 |
| 2019-06-25 06:50:00 | SPY | ETF | 293.24 | 293.25 | 293.24 | 293.25 | 22014.0 |
| 2019-06-25 06:55:00 | SPY | ETF | 293.33 | 293.43 | 293.33 | 293.39 | 1205.0 |
| 2019-06-25 07:00:00 | SPY | ETF | 293.39 | 293.49 | 293.39 | 293.49 | 2098.0 |
| 2019-06-25 07:05:00 | SPY | ETF | 293.5 | 293.5 | 293.45 | 293.45 | 7985.0 |
| 2019-06-25 07:10:00 | SPY | ETF | 293.45 | 293.49 | 293.42 | 293.49 | 20234.0 |
| 2019-06-25 07:15:00 | SPY | ETF | 293.45 | 293.52 | 293.45 | 293.52 | 14400.0 |
| 2019-06-25 07:20:00 | SPY | ETF | 293.5 | 293.52 | 293.5 | 293.5 | 2700.0 |
| 2019-06-25 07:25:00 | SPY | ETF | 293.5 | 293.5 | 293.5 | 293.5 | 673.0 |
| 2019-06-25 07:30:00 | SPY | ETF | 293.47 | 293.47 | 293.47 | 293.47 | 5000.0 |
| 2019-06-25 07:35:00 | SPY | ETF | 293.45 | 293.45 | 293.44 | 293.44 | 900.0 |
| 2019-06-25 07:40:00 | SPY | ETF | 293.44 | 293.45 | 293.32 | 293.32 | 103200.0 |
| 2019-06-25 07:45:00 | SPY | ETF | 293.35 | 293.45 | 293.34 | 293.45 | 5399.0 |
| 2019-06-25 07:50:00 | SPY | ETF | 293.44 | 293.5 | 293.44 | 293.48 | 15450.0 |
| 2019-06-25 07:55:00 | SPY | ETF | 293.5 | 293.5 | 293.48 | 293.48 | 7630.0 |
| 2019-06-25 08:00:00 | SPY | ETF | 293.49 | 293.56 | 292.93 | 293.49 | 121648.0 |
| 2019-06-25 08:05:00 | SPY | ETF | 293.43 | 293.44 | 293.34 | 293.44 | 7009.0 |
| 2019-06-25 08:10:00 | SPY | ETF | 293.43 | 293.46 | 293.4 | 293.46 | 11314.0 |
| 2019-06-25 08:15:00 | SPY | ETF | 293.44 | 293.45 | 293.42 | 293.45 | 3100.0 |
| 2019-06-25 08:20:00 | SPY | ETF | 293.45 | 293.48 | 293.45 | 293.48 | 5002.0 |
| 2019-06-25 08:25:00 | SPY | ETF | 293.49 | 293.49 | 293.4 | 293.4 | 3600.0 |
| 2019-06-25 08:30:00 | SPY | ETF | 293.38 | 293.43 | 293.37 | 293.41 | 8671.0 |
| 2019-06-25 08:35:00 | SPY | ETF | 293.43 | 293.52 | 293.43 | 293.52 | 7643.0 |
| 2019-06-25 08:40:00 | SPY | ETF | 293.54 | 293.54 | 293.5 | 293.54 | 6948.0 |
| 2019-06-25 08:45:00 | SPY | ETF | 293.51 | 293.57 | 293.51 | 293.57 | 2509.0 |
| 2019-06-25 08:50:00 | SPY | ETF | 293.56 | 293.74 | 293.56 | 293.73 | 11636.0 |
| 2019-06-25 08:55:00 | SPY | ETF | 293.73 | 293.73 | 293.68 | 293.69 | 6890.0 |
| 2019-06-25 09:00:00 | SPY | ETF | 293.69 | 293.8 | 293.69 | 293.75 | 10878.0 |
| 2019-06-25 09:05:00 | SPY | ETF | 293.75 | 293.82 | 293.75 | 293.82 | 7561.0 |
> showing 50 of 62,960 rows — these rows as CSV