PREVIEW / etf_1hour / 2017-11-14
file: by_date/etf_1hour/2017/2017-11-14.parquet size: 284 KB rows: 9,384
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-11-14 04:00:00 | SPY | ETF | 258.1 | 258.1 | 257.95 | 257.95 | 1212.0 |
| 2017-11-14 05:00:00 | SPY | ETF | 258.02 | 258.02 | 257.87 | 257.92 | 14370.0 |
| 2017-11-14 06:00:00 | SPY | ETF | 257.95 | 258.07 | 257.89 | 258.02 | 10010.0 |
| 2017-11-14 07:00:00 | SPY | ETF | 257.97 | 257.97 | 257.6 | 257.76 | 275958.0 |
| 2017-11-14 08:00:00 | SPY | ETF | 257.97 | 257.97 | 257.51 | 257.52 | 348533.0 |
| 2017-11-14 09:00:00 | SPY | ETF | 257.53 | 257.67 | 257.16 | 257.24 | 6473461.0 |
| 2017-11-14 10:00:00 | SPY | ETF | 257.235 | 257.85 | 256.52 | 257.695 | 13356492.0 |
| 2017-11-14 11:00:00 | SPY | ETF | 257.7 | 257.78 | 257.48 | 257.74 | 5832071.0 |
| 2017-11-14 12:00:00 | SPY | ETF | 257.74 | 257.84 | 257.14 | 257.31 | 6604016.0 |
| 2017-11-14 13:00:00 | SPY | ETF | 257.3 | 257.66 | 257.08 | 257.51 | 4881872.0 |
| 2017-11-14 14:00:00 | SPY | ETF | 257.52 | 257.73 | 257.45 | 257.68 | 3456037.0 |
| 2017-11-14 15:00:00 | SPY | ETF | 257.68 | 257.81 | 257.45 | 257.75 | 9754971.0 |
| 2017-11-14 16:00:00 | SPY | ETF | 257.74 | 257.86 | 257.72 | 257.79 | 8339023.0 |
| 2017-11-14 17:00:00 | SPY | ETF | 257.76 | 257.7726 | 257.68 | 257.71 | 859416.0 |
| 2017-11-14 18:00:00 | SPY | ETF | 257.7 | 257.71 | 257.5 | 257.51 | 91680.0 |
| 2017-11-14 19:00:00 | SPY | ETF | 257.55 | 257.55 | 256.96 | 257.23 | 127562.0 |
| 2017-11-14 04:00:00 | QQQ | ETF | 153.73 | 153.79 | 153.64 | 153.79 | 4600.0 |
| 2017-11-14 05:00:00 | QQQ | ETF | 153.78 | 153.8 | 153.78 | 153.8 | 5500.0 |
| 2017-11-14 06:00:00 | QQQ | ETF | 153.79 | 153.81 | 153.79 | 153.8 | 15000.0 |
| 2017-11-14 07:00:00 | QQQ | ETF | 153.72 | 153.72 | 153.5 | 153.64 | 83504.0 |
| 2017-11-14 08:00:00 | QQQ | ETF | 153.76 | 153.76 | 153.44 | 153.44 | 131538.0 |
| 2017-11-14 09:00:00 | QQQ | ETF | 153.45 | 153.5 | 152.94 | 153.03 | 3089628.0 |
| 2017-11-14 10:00:00 | QQQ | ETF | 153.02 | 153.49 | 152.57 | 153.31 | 5785306.0 |
| 2017-11-14 11:00:00 | QQQ | ETF | 153.31 | 153.46 | 153.23 | 153.44 | 1951959.0 |
| 2017-11-14 12:00:00 | QQQ | ETF | 153.43 | 153.5 | 152.7599 | 152.88 | 1337796.0 |
| 2017-11-14 13:00:00 | QQQ | ETF | 152.87 | 153.15 | 152.61 | 153.09 | 1744369.0 |
| 2017-11-14 14:00:00 | QQQ | ETF | 153.1 | 153.245 | 153.033 | 153.21 | 904427.0 |
| 2017-11-14 15:00:00 | QQQ | ETF | 153.21 | 153.37 | 153.11 | 153.31 | 3080612.0 |
| 2017-11-14 16:00:00 | QQQ | ETF | 153.31 | 153.36 | 153.24 | 153.27 | 412650.0 |
| 2017-11-14 17:00:00 | QQQ | ETF | 153.26 | 153.34 | 153.26 | 153.33 | 43621.0 |
| 2017-11-14 18:00:00 | QQQ | ETF | 153.3 | 153.32 | 153.16 | 153.16 | 46266.0 |
| 2017-11-14 19:00:00 | QQQ | ETF | 153.18 | 153.18 | 152.87 | 153.05 | 31549.0 |
| 2017-11-14 05:00:00 | IWM | ETF | 146.26 | 146.32 | 146.26 | 146.32 | 1503.0 |
| 2017-11-14 06:00:00 | IWM | ETF | 146.29 | 146.29 | 146.29 | 146.29 | 503.0 |
| 2017-11-14 07:00:00 | IWM | ETF | 146.16 | 146.21 | 146.02 | 146.17 | 41805.0 |
| 2017-11-14 08:00:00 | IWM | ETF | 146.14 | 146.28 | 146.08 | 146.08 | 28271.0 |
| 2017-11-14 09:00:00 | IWM | ETF | 146.08 | 146.49 | 145.88 | 146.19 | 1820864.0 |
| 2017-11-14 10:00:00 | IWM | ETF | 146.19 | 146.46 | 145.73 | 146.28 | 3443880.0 |
| 2017-11-14 11:00:00 | IWM | ETF | 146.29 | 146.32 | 145.78 | 145.94 | 1893850.0 |
| 2017-11-14 12:00:00 | IWM | ETF | 145.93 | 146.01 | 145.59 | 145.76 | 1204495.0 |
| 2017-11-14 13:00:00 | IWM | ETF | 145.745 | 146.06 | 145.63 | 145.98 | 1117561.0 |
| 2017-11-14 14:00:00 | IWM | ETF | 145.97 | 146.27 | 145.92 | 146.2199 | 1643745.0 |
| 2017-11-14 15:00:00 | IWM | ETF | 146.21 | 146.43 | 146.14 | 146.23 | 2639408.0 |
| 2017-11-14 16:00:00 | IWM | ETF | 146.21 | 146.27 | 146.1 | 146.17 | 1868466.0 |
| 2017-11-14 17:00:00 | IWM | ETF | 146.2 | 146.2 | 146.1 | 146.11 | 4298.0 |
| 2017-11-14 18:00:00 | IWM | ETF | 146.11 | 146.11 | 145.91 | 145.99 | 7356.0 |
| 2017-11-14 19:00:00 | IWM | ETF | 145.85 | 145.86 | 145.6 | 145.78 | 16623.0 |
| 2017-11-14 06:00:00 | DIA | ETF | 234.6 | 234.6 | 234.6 | 234.6 | 100.0 |
| 2017-11-14 07:00:00 | DIA | ETF | 234.5 | 234.5 | 234.2 | 234.32 | 10494.0 |
| 2017-11-14 08:00:00 | DIA | ETF | 234.26 | 234.29 | 234.12 | 234.12 | 4390.0 |
> showing 50 of 9,384 rows — these rows as CSV