PREVIEW / etf_5min / 2018-12-06
file: by_date/etf_5min/2018/2018-12-06.parquet size: 1.7 MB rows: 72,484
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-12-06 04:00:00 | SPY | ETF | 267.63 | 267.63 | 266.98 | 267.13 | 70823.0 |
| 2018-12-06 04:05:00 | SPY | ETF | 266.94 | 267.19 | 266.94 | 267.15 | 6455.0 |
| 2018-12-06 04:10:00 | SPY | ETF | 266.96 | 267.23 | 266.96 | 267.13 | 5830.0 |
| 2018-12-06 04:15:00 | SPY | ETF | 267.3 | 267.35 | 267.3 | 267.31 | 1600.0 |
| 2018-12-06 04:20:00 | SPY | ETF | 267.06 | 267.18 | 267.06 | 267.08 | 5550.0 |
| 2018-12-06 04:25:00 | SPY | ETF | 267.01 | 267.16 | 266.99 | 266.99 | 14777.0 |
| 2018-12-06 04:30:00 | SPY | ETF | 267.06 | 267.13 | 267.0 | 267.0 | 15344.0 |
| 2018-12-06 04:35:00 | SPY | ETF | 266.99 | 266.99 | 266.73 | 266.73 | 18524.0 |
| 2018-12-06 04:40:00 | SPY | ETF | 266.82 | 266.83 | 266.55 | 266.65 | 29910.0 |
| 2018-12-06 04:45:00 | SPY | ETF | 266.58 | 266.58 | 266.3 | 266.3 | 4195.0 |
| 2018-12-06 04:50:00 | SPY | ETF | 266.4 | 266.4 | 266.17 | 266.27 | 21396.0 |
| 2018-12-06 04:55:00 | SPY | ETF | 266.18 | 266.18 | 265.52 | 265.58 | 28310.0 |
| 2018-12-06 05:00:00 | SPY | ETF | 265.67 | 265.83 | 265.37 | 265.59 | 39442.0 |
| 2018-12-06 05:05:00 | SPY | ETF | 265.55 | 265.74 | 265.55 | 265.74 | 12105.0 |
| 2018-12-06 05:10:00 | SPY | ETF | 265.69 | 265.8 | 265.54 | 265.65 | 11064.0 |
| 2018-12-06 05:15:00 | SPY | ETF | 265.66 | 265.68 | 265.55 | 265.67 | 5230.0 |
| 2018-12-06 05:20:00 | SPY | ETF | 265.73 | 265.82 | 265.73 | 265.75 | 1560.0 |
| 2018-12-06 05:25:00 | SPY | ETF | 265.82 | 265.82 | 265.5 | 265.52 | 10022.0 |
| 2018-12-06 05:30:00 | SPY | ETF | 265.48 | 265.6 | 265.4 | 265.6 | 35240.0 |
| 2018-12-06 05:35:00 | SPY | ETF | 265.6 | 266.1 | 265.6 | 266.07 | 53368.0 |
| 2018-12-06 05:40:00 | SPY | ETF | 266.05 | 266.1 | 265.88 | 265.88 | 5197.0 |
| 2018-12-06 05:45:00 | SPY | ETF | 265.83 | 265.83 | 265.52 | 265.57 | 16572.0 |
| 2018-12-06 05:50:00 | SPY | ETF | 265.69 | 265.69 | 265.54 | 265.6 | 4994.0 |
| 2018-12-06 05:55:00 | SPY | ETF | 265.6 | 265.9 | 265.56 | 265.84 | 7385.0 |
| 2018-12-06 06:00:00 | SPY | ETF | 265.72 | 265.92 | 265.69 | 265.86 | 15953.0 |
| 2018-12-06 06:05:00 | SPY | ETF | 265.93 | 265.99 | 265.76 | 265.91 | 11945.0 |
| 2018-12-06 06:10:00 | SPY | ETF | 265.86 | 266.12 | 265.86 | 266.12 | 11826.0 |
| 2018-12-06 06:15:00 | SPY | ETF | 266.0 | 266.13 | 265.95 | 266.1 | 3355.0 |
| 2018-12-06 06:20:00 | SPY | ETF | 266.02 | 266.2 | 266.02 | 266.08 | 6188.0 |
| 2018-12-06 06:25:00 | SPY | ETF | 266.16 | 266.49 | 266.1 | 266.15 | 26350.0 |
| 2018-12-06 06:30:00 | SPY | ETF | 266.26 | 266.3 | 265.88 | 265.88 | 15599.0 |
| 2018-12-06 06:35:00 | SPY | ETF | 265.88 | 265.88 | 265.5 | 265.63 | 47562.0 |
| 2018-12-06 06:40:00 | SPY | ETF | 265.59 | 265.82 | 265.59 | 265.68 | 32238.0 |
| 2018-12-06 06:45:00 | SPY | ETF | 265.7 | 265.99 | 265.7 | 265.78 | 75136.0 |
| 2018-12-06 06:50:00 | SPY | ETF | 265.81 | 265.85 | 265.58 | 265.6 | 36305.0 |
| 2018-12-06 06:55:00 | SPY | ETF | 265.64 | 265.98 | 265.64 | 265.98 | 6424.0 |
| 2018-12-06 07:00:00 | SPY | ETF | 265.98 | 266.09 | 265.92 | 266.09 | 56455.0 |
| 2018-12-06 07:05:00 | SPY | ETF | 266.07 | 266.39 | 266.07 | 266.34 | 40690.0 |
| 2018-12-06 07:10:00 | SPY | ETF | 266.32 | 266.47 | 266.21 | 266.29 | 21206.0 |
| 2018-12-06 07:15:00 | SPY | ETF | 266.3 | 266.4 | 266.22 | 266.4 | 13252.0 |
| 2018-12-06 07:20:00 | SPY | ETF | 266.4 | 266.67 | 266.39 | 266.53 | 58711.0 |
| 2018-12-06 07:25:00 | SPY | ETF | 266.5 | 266.61 | 266.39 | 266.5 | 44992.0 |
| 2018-12-06 07:30:00 | SPY | ETF | 266.46 | 266.73 | 266.42 | 266.59 | 47989.0 |
| 2018-12-06 07:35:00 | SPY | ETF | 266.58 | 266.72 | 266.5 | 266.55 | 17430.0 |
| 2018-12-06 07:40:00 | SPY | ETF | 266.54 | 266.55 | 266.3 | 266.3 | 33824.0 |
| 2018-12-06 07:45:00 | SPY | ETF | 266.34 | 266.34 | 266.02 | 266.06 | 29790.0 |
| 2018-12-06 07:50:00 | SPY | ETF | 266.06 | 266.58 | 266.02 | 266.51 | 49342.0 |
| 2018-12-06 07:55:00 | SPY | ETF | 266.55 | 266.7 | 266.33 | 266.34 | 76606.0 |
| 2018-12-06 08:00:00 | SPY | ETF | 266.3201 | 268.55 | 265.69 | 266.51 | 94754.0 |
| 2018-12-06 08:05:00 | SPY | ETF | 266.56 | 266.6 | 266.35 | 266.44 | 77348.0 |
> showing 50 of 72,484 rows — these rows as CSV