PREVIEW / etf_5min / 2018-10-12
file: by_date/etf_5min/2018/2018-10-12.parquet size: 1.6 MB rows: 67,521
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-12 04:00:00 | SPY | ETF | 276.5 | 277.0 | 276.5 | 276.85 | 10120.0 |
| 2018-10-12 04:05:00 | SPY | ETF | 276.8 | 276.8 | 276.58 | 276.73 | 18300.0 |
| 2018-10-12 04:10:00 | SPY | ETF | 276.7 | 276.7 | 276.51 | 276.57 | 13369.0 |
| 2018-10-12 04:15:00 | SPY | ETF | 276.63 | 276.74 | 276.43 | 276.47 | 11072.0 |
| 2018-10-12 04:20:00 | SPY | ETF | 276.45 | 276.5 | 276.08 | 276.08 | 4180.0 |
| 2018-10-12 04:25:00 | SPY | ETF | 276.09 | 276.33 | 276.08 | 276.33 | 4636.0 |
| 2018-10-12 04:30:00 | SPY | ETF | 276.13 | 276.16 | 275.93 | 275.93 | 4530.0 |
| 2018-10-12 04:35:00 | SPY | ETF | 275.91 | 276.2 | 275.91 | 276.2 | 3205.0 |
| 2018-10-12 04:40:00 | SPY | ETF | 276.08 | 276.1 | 275.95 | 275.99 | 13425.0 |
| 2018-10-12 04:45:00 | SPY | ETF | 276.08 | 276.09 | 275.98 | 275.98 | 1000.0 |
| 2018-10-12 04:50:00 | SPY | ETF | 275.93 | 276.16 | 275.93 | 276.1 | 15750.0 |
| 2018-10-12 04:55:00 | SPY | ETF | 276.05 | 276.05 | 275.74 | 275.76 | 23185.0 |
| 2018-10-12 05:00:00 | SPY | ETF | 275.77 | 275.79 | 275.68 | 275.7 | 20860.0 |
| 2018-10-12 05:05:00 | SPY | ETF | 275.72 | 275.9 | 275.7 | 275.9 | 9488.0 |
| 2018-10-12 05:10:00 | SPY | ETF | 275.79 | 275.85 | 275.65 | 275.65 | 1300.0 |
| 2018-10-12 05:15:00 | SPY | ETF | 275.65 | 275.82 | 275.62 | 275.72 | 11255.0 |
| 2018-10-12 05:20:00 | SPY | ETF | 275.57 | 275.65 | 275.42 | 275.65 | 6273.0 |
| 2018-10-12 05:25:00 | SPY | ETF | 275.65 | 275.97 | 275.65 | 275.97 | 4758.0 |
| 2018-10-12 05:30:00 | SPY | ETF | 275.89 | 276.11 | 275.89 | 276.09 | 5665.0 |
| 2018-10-12 05:35:00 | SPY | ETF | 276.12 | 276.12 | 275.97 | 276.01 | 10186.0 |
| 2018-10-12 05:40:00 | SPY | ETF | 276.04 | 276.21 | 276.04 | 276.16 | 13803.0 |
| 2018-10-12 05:45:00 | SPY | ETF | 276.16 | 276.18 | 276.1 | 276.16 | 1970.0 |
| 2018-10-12 05:50:00 | SPY | ETF | 276.08 | 276.08 | 275.94 | 275.94 | 6870.0 |
| 2018-10-12 05:55:00 | SPY | ETF | 275.91 | 276.03 | 275.88 | 276.0 | 12400.0 |
| 2018-10-12 06:00:00 | SPY | ETF | 275.94 | 275.99 | 275.84 | 275.88 | 6906.0 |
| 2018-10-12 06:05:00 | SPY | ETF | 275.94 | 276.0 | 275.83 | 275.94 | 7955.0 |
| 2018-10-12 06:10:00 | SPY | ETF | 275.93 | 276.18 | 275.93 | 276.17 | 6915.0 |
| 2018-10-12 06:15:00 | SPY | ETF | 276.1 | 276.18 | 276.1 | 276.13 | 6200.0 |
| 2018-10-12 06:20:00 | SPY | ETF | 275.88 | 275.88 | 275.6 | 275.74 | 22676.0 |
| 2018-10-12 06:25:00 | SPY | ETF | 275.64 | 275.94 | 275.56 | 275.94 | 17262.0 |
| 2018-10-12 06:30:00 | SPY | ETF | 275.98 | 276.0 | 275.88 | 276.0 | 25825.0 |
| 2018-10-12 06:35:00 | SPY | ETF | 276.0 | 276.25 | 276.0 | 276.21 | 12772.0 |
| 2018-10-12 06:40:00 | SPY | ETF | 276.2 | 276.27 | 276.19 | 276.2 | 26367.0 |
| 2018-10-12 06:45:00 | SPY | ETF | 276.19 | 276.53 | 276.19 | 276.34 | 33255.0 |
| 2018-10-12 06:50:00 | SPY | ETF | 276.49 | 276.55 | 276.38 | 276.42 | 30140.0 |
| 2018-10-12 06:55:00 | SPY | ETF | 276.35 | 276.52 | 276.35 | 276.45 | 25325.0 |
| 2018-10-12 07:00:00 | SPY | ETF | 276.49 | 276.49 | 276.3 | 276.45 | 64322.0 |
| 2018-10-12 07:05:00 | SPY | ETF | 276.4 | 276.43 | 276.33 | 276.4 | 18725.0 |
| 2018-10-12 07:10:00 | SPY | ETF | 276.4 | 276.52 | 276.25 | 276.52 | 56487.0 |
| 2018-10-12 07:15:00 | SPY | ETF | 276.54 | 276.62 | 276.39 | 276.59 | 43698.0 |
| 2018-10-12 07:20:00 | SPY | ETF | 276.58 | 276.81 | 276.53 | 276.69 | 147352.0 |
| 2018-10-12 07:25:00 | SPY | ETF | 276.7 | 276.8 | 276.59 | 276.59 | 19753.0 |
| 2018-10-12 07:30:00 | SPY | ETF | 276.56 | 276.6 | 276.42 | 276.51 | 10072.0 |
| 2018-10-12 07:35:00 | SPY | ETF | 276.51 | 276.63 | 276.45 | 276.45 | 26474.0 |
| 2018-10-12 07:40:00 | SPY | ETF | 276.53 | 276.61 | 276.49 | 276.55 | 19035.0 |
| 2018-10-12 07:45:00 | SPY | ETF | 276.51 | 276.63 | 276.34 | 276.46 | 81636.0 |
| 2018-10-12 07:50:00 | SPY | ETF | 276.48 | 276.48 | 276.17 | 276.21 | 53062.0 |
| 2018-10-12 07:55:00 | SPY | ETF | 276.21 | 276.29 | 276.07 | 276.24 | 99182.0 |
| 2018-10-12 08:00:00 | SPY | ETF | 276.4 | 277.32 | 275.88 | 276.38 | 62427.0 |
| 2018-10-12 08:05:00 | SPY | ETF | 276.44 | 276.55 | 276.38 | 276.5 | 38064.0 |
> showing 50 of 67,521 rows — these rows as CSV