PREVIEW / etf_5min / 2018-10-03
file: by_date/etf_5min/2018/2018-10-03.parquet size: 1.5 MB rows: 61,429
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 |
|---|---|---|---|---|---|---|---|
| 2018-10-03 04:00:00 | SPY | ETF | 292.18 | 292.18 | 292.18 | 292.18 | 255.0 |
| 2018-10-03 04:05:00 | SPY | ETF | 292.24 | 292.24 | 292.24 | 292.24 | 188.0 |
| 2018-10-03 04:25:00 | SPY | ETF | 292.22 | 292.22 | 292.19 | 292.22 | 5500.0 |
| 2018-10-03 04:35:00 | SPY | ETF | 292.28 | 292.3 | 292.28 | 292.3 | 749.0 |
| 2018-10-03 04:40:00 | SPY | ETF | 292.22 | 292.3 | 292.22 | 292.3 | 5349.0 |
| 2018-10-03 05:00:00 | SPY | ETF | 292.27 | 292.27 | 292.27 | 292.27 | 310.0 |
| 2018-10-03 05:05:00 | SPY | ETF | 292.25 | 292.25 | 292.25 | 292.25 | 100.0 |
| 2018-10-03 05:15:00 | SPY | ETF | 292.15 | 292.15 | 292.15 | 292.15 | 400.0 |
| 2018-10-03 05:20:00 | SPY | ETF | 291.99 | 291.99 | 291.99 | 291.99 | 10000.0 |
| 2018-10-03 05:35:00 | SPY | ETF | 292.18 | 292.18 | 292.16 | 292.16 | 1100.0 |
| 2018-10-03 05:40:00 | SPY | ETF | 292.16 | 292.16 | 292.16 | 292.16 | 200.0 |
| 2018-10-03 05:50:00 | SPY | ETF | 292.21 | 292.21 | 292.21 | 292.21 | 600.0 |
| 2018-10-03 06:00:00 | SPY | ETF | 292.32 | 292.32 | 292.32 | 292.32 | 1060.0 |
| 2018-10-03 06:05:00 | SPY | ETF | 292.35 | 292.35 | 292.29 | 292.29 | 2450.0 |
| 2018-10-03 06:10:00 | SPY | ETF | 292.35 | 292.35 | 292.35 | 292.35 | 300.0 |
| 2018-10-03 06:15:00 | SPY | ETF | 292.38 | 292.38 | 292.26 | 292.26 | 10600.0 |
| 2018-10-03 06:20:00 | SPY | ETF | 292.29 | 292.34 | 292.28 | 292.34 | 5500.0 |
| 2018-10-03 06:25:00 | SPY | ETF | 292.37 | 292.37 | 292.3 | 292.31 | 1700.0 |
| 2018-10-03 06:30:00 | SPY | ETF | 292.29 | 292.34 | 292.29 | 292.34 | 1300.0 |
| 2018-10-03 06:35:00 | SPY | ETF | 292.26 | 292.34 | 292.26 | 292.34 | 1600.0 |
| 2018-10-03 06:40:00 | SPY | ETF | 292.31 | 292.35 | 292.31 | 292.35 | 1100.0 |
| 2018-10-03 06:45:00 | SPY | ETF | 292.31 | 292.4 | 292.31 | 292.33 | 9800.0 |
| 2018-10-03 06:50:00 | SPY | ETF | 292.28 | 292.32 | 292.28 | 292.32 | 700.0 |
| 2018-10-03 06:55:00 | SPY | ETF | 292.29 | 292.29 | 292.29 | 292.29 | 1000.0 |
| 2018-10-03 07:00:00 | SPY | ETF | 292.3 | 292.34 | 292.28 | 292.31 | 5075.0 |
| 2018-10-03 07:05:00 | SPY | ETF | 292.34 | 292.37 | 292.33 | 292.36 | 2960.0 |
| 2018-10-03 07:10:00 | SPY | ETF | 292.42 | 292.5 | 292.42 | 292.45 | 18591.0 |
| 2018-10-03 07:15:00 | SPY | ETF | 292.47 | 292.47 | 292.47 | 292.47 | 6388.0 |
| 2018-10-03 07:20:00 | SPY | ETF | 292.49 | 292.59 | 292.49 | 292.57 | 24905.0 |
| 2018-10-03 07:25:00 | SPY | ETF | 292.55 | 292.56 | 292.51 | 292.52 | 7985.0 |
| 2018-10-03 07:30:00 | SPY | ETF | 292.53 | 292.55 | 292.51 | 292.53 | 4521.0 |
| 2018-10-03 07:35:00 | SPY | ETF | 292.56 | 292.56 | 292.47 | 292.5 | 16675.0 |
| 2018-10-03 07:40:00 | SPY | ETF | 292.57 | 292.59 | 292.57 | 292.59 | 1970.0 |
| 2018-10-03 07:45:00 | SPY | ETF | 292.55 | 292.56 | 292.55 | 292.56 | 799.0 |
| 2018-10-03 07:50:00 | SPY | ETF | 292.52 | 292.54 | 292.52 | 292.53 | 300.0 |
| 2018-10-03 07:55:00 | SPY | ETF | 292.51 | 292.56 | 292.5 | 292.53 | 11700.0 |
| 2018-10-03 08:00:00 | SPY | ETF | 291.56 | 292.59 | 291.56 | 292.56 | 16132.0 |
| 2018-10-03 08:05:00 | SPY | ETF | 292.59 | 292.6 | 292.58 | 292.58 | 4750.0 |
| 2018-10-03 08:10:00 | SPY | ETF | 292.62 | 292.63 | 292.61 | 292.62 | 3685.0 |
| 2018-10-03 08:15:00 | SPY | ETF | 292.5 | 292.72 | 292.5 | 292.68 | 36719.0 |
| 2018-10-03 08:20:00 | SPY | ETF | 292.7 | 292.7 | 292.6 | 292.63 | 26049.0 |
| 2018-10-03 08:25:00 | SPY | ETF | 292.6 | 292.66 | 292.53 | 292.53 | 18355.0 |
| 2018-10-03 08:30:00 | SPY | ETF | 292.53 | 292.59 | 292.53 | 292.57 | 63088.0 |
| 2018-10-03 08:35:00 | SPY | ETF | 292.58 | 292.6 | 292.58 | 292.58 | 66940.0 |
| 2018-10-03 08:40:00 | SPY | ETF | 292.59 | 292.73 | 292.59 | 292.71 | 48264.0 |
| 2018-10-03 08:45:00 | SPY | ETF | 292.72 | 292.72 | 292.68 | 292.7 | 23819.0 |
| 2018-10-03 08:50:00 | SPY | ETF | 292.7 | 292.74 | 292.69 | 292.71 | 14807.0 |
| 2018-10-03 08:55:00 | SPY | ETF | 292.71 | 292.74 | 292.67 | 292.74 | 10369.0 |
| 2018-10-03 09:00:00 | SPY | ETF | 292.71 | 292.72 | 292.65 | 292.65 | 16789.0 |
| 2018-10-03 09:05:00 | SPY | ETF | 292.66 | 292.67 | 292.61 | 292.61 | 24538.0 |
> showing 50 of 61,429 rows — these rows as CSV