PREVIEW / etf_1hour / 2017-12-22
file: by_date/etf_1hour/2017/2017-12-22.parquet size: 282 KB rows: 9,279
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 |
|---|---|---|---|---|---|---|---|
| 2017-12-22 04:00:00 | SPY | ETF | 267.8 | 267.91 | 267.8 | 267.8 | 4333.0 |
| 2017-12-22 05:00:00 | SPY | ETF | 267.84 | 267.84 | 267.74 | 267.74 | 1600.0 |
| 2017-12-22 06:00:00 | SPY | ETF | 267.74 | 267.85 | 267.74 | 267.77 | 19000.0 |
| 2017-12-22 07:00:00 | SPY | ETF | 267.82 | 267.85 | 267.64 | 267.64 | 27917.0 |
| 2017-12-22 08:00:00 | SPY | ETF | 267.84 | 267.84 | 267.55 | 267.56 | 50587.0 |
| 2017-12-22 09:00:00 | SPY | ETF | 267.56 | 267.68 | 267.22 | 267.6 | 5096711.0 |
| 2017-12-22 10:00:00 | SPY | ETF | 267.61 | 267.615 | 267.23 | 267.286 | 6408775.0 |
| 2017-12-22 11:00:00 | SPY | ETF | 267.28 | 267.3 | 266.9 | 267.0845 | 7606187.0 |
| 2017-12-22 12:00:00 | SPY | ETF | 267.08 | 267.24 | 267.05 | 267.13 | 2461955.0 |
| 2017-12-22 13:00:00 | SPY | ETF | 267.135 | 267.5492 | 267.11 | 267.355 | 5783271.0 |
| 2017-12-22 14:00:00 | SPY | ETF | 267.36 | 267.49 | 267.23 | 267.44 | 6215138.0 |
| 2017-12-22 15:00:00 | SPY | ETF | 267.435 | 267.56 | 267.31 | 267.48 | 13402119.0 |
| 2017-12-22 16:00:00 | SPY | ETF | 267.48 | 267.52 | 267.1 | 267.23 | 26162648.0 |
| 2017-12-22 17:00:00 | SPY | ETF | 267.23 | 267.45 | 267.18 | 267.36 | 225137.0 |
| 2017-12-22 18:00:00 | SPY | ETF | 267.37 | 267.38 | 267.31 | 267.38 | 4658.0 |
| 2017-12-22 19:00:00 | SPY | ETF | 267.33 | 267.35 | 267.27 | 267.35 | 6547.0 |
| 2017-12-22 04:00:00 | QQQ | ETF | 157.71 | 157.71 | 157.69 | 157.69 | 10500.0 |
| 2017-12-22 05:00:00 | QQQ | ETF | 157.69 | 157.69 | 157.64 | 157.64 | 4200.0 |
| 2017-12-22 06:00:00 | QQQ | ETF | 157.61 | 157.63 | 157.59 | 157.63 | 1600.0 |
| 2017-12-22 07:00:00 | QQQ | ETF | 157.67 | 157.67 | 157.52 | 157.52 | 45000.0 |
| 2017-12-22 08:00:00 | QQQ | ETF | 157.55 | 157.6 | 157.51 | 157.53 | 165244.0 |
| 2017-12-22 09:00:00 | QQQ | ETF | 157.51 | 157.56 | 156.95 | 157.39 | 2445457.0 |
| 2017-12-22 10:00:00 | QQQ | ETF | 157.39 | 157.42 | 157.1 | 157.32 | 1782934.0 |
| 2017-12-22 11:00:00 | QQQ | ETF | 157.32 | 157.35 | 157.1 | 157.18 | 1998894.0 |
| 2017-12-22 12:00:00 | QQQ | ETF | 157.17 | 157.19 | 157.06 | 157.13 | 1192443.0 |
| 2017-12-22 13:00:00 | QQQ | ETF | 157.13 | 157.33 | 157.12 | 157.29 | 1679462.0 |
| 2017-12-22 14:00:00 | QQQ | ETF | 157.3 | 157.38 | 157.21 | 157.3667 | 1293914.0 |
| 2017-12-22 15:00:00 | QQQ | ETF | 157.37 | 157.41 | 157.24 | 157.37 | 3620361.0 |
| 2017-12-22 16:00:00 | QQQ | ETF | 157.36 | 157.37 | 157.18 | 157.22 | 3557819.0 |
| 2017-12-22 17:00:00 | QQQ | ETF | 157.23 | 157.25 | 157.19 | 157.19 | 4087.0 |
| 2017-12-22 19:00:00 | QQQ | ETF | 157.23 | 157.25 | 157.2 | 157.25 | 1790.0 |
| 2017-12-22 04:00:00 | IWM | ETF | 153.81 | 153.81 | 153.81 | 153.81 | 700.0 |
| 2017-12-22 07:00:00 | IWM | ETF | 153.73 | 153.73 | 153.49 | 153.49 | 2310.0 |
| 2017-12-22 08:00:00 | IWM | ETF | 153.48 | 153.48 | 153.34 | 153.34 | 15139.0 |
| 2017-12-22 09:00:00 | IWM | ETF | 153.36 | 153.47 | 152.86 | 153.16 | 2709468.0 |
| 2017-12-22 10:00:00 | IWM | ETF | 153.1699 | 153.19 | 152.8 | 153.1 | 1289011.0 |
| 2017-12-22 11:00:00 | IWM | ETF | 153.09 | 153.23 | 152.91 | 153.07 | 901344.0 |
| 2017-12-22 12:00:00 | IWM | ETF | 153.05 | 153.21 | 153.02 | 153.12 | 485579.0 |
| 2017-12-22 13:00:00 | IWM | ETF | 153.11 | 153.31 | 153.11 | 153.25 | 711522.0 |
| 2017-12-22 14:00:00 | IWM | ETF | 153.2448 | 153.35 | 153.1539 | 153.2 | 909702.0 |
| 2017-12-22 15:00:00 | IWM | ETF | 153.21 | 153.23 | 152.965 | 153.19 | 3182997.0 |
| 2017-12-22 16:00:00 | IWM | ETF | 153.19 | 153.21 | 152.89 | 152.98 | 1987971.0 |
| 2017-12-22 17:00:00 | IWM | ETF | 153.0 | 153.05 | 153.0 | 153.05 | 700.0 |
| 2017-12-22 06:00:00 | DIA | ETF | 247.8 | 247.8 | 247.78 | 247.78 | 1000.0 |
| 2017-12-22 07:00:00 | DIA | ETF | 247.76 | 247.76 | 247.6 | 247.6 | 699.0 |
| 2017-12-22 08:00:00 | DIA | ETF | 247.44 | 247.44 | 247.38 | 247.4 | 2248.0 |
| 2017-12-22 09:00:00 | DIA | ETF | 247.36 | 247.59 | 247.26 | 247.48 | 280733.0 |
| 2017-12-22 10:00:00 | DIA | ETF | 247.51 | 247.61 | 247.28 | 247.31 | 234591.0 |
| 2017-12-22 11:00:00 | DIA | ETF | 247.3 | 247.37 | 246.97 | 247.14 | 253335.0 |
| 2017-12-22 12:00:00 | DIA | ETF | 247.13 | 247.27 | 246.99 | 247.0501 | 187376.0 |
> showing 50 of 9,279 rows — these rows as CSV