PREVIEW / etf_1hour / 2017-01-10
file: by_date/etf_1hour/2017/2017-01-10.parquet size: 272 KB rows: 8,807
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-01-10 04:00:00 | SPY | ETF | 226.46 | 226.47 | 226.4 | 226.47 | 601.0 |
| 2017-01-10 05:00:00 | SPY | ETF | 226.53 | 226.7 | 226.53 | 226.66 | 5566.0 |
| 2017-01-10 06:00:00 | SPY | ETF | 226.63 | 226.69 | 226.61 | 226.61 | 1302.0 |
| 2017-01-10 07:00:00 | SPY | ETF | 226.55 | 226.64 | 226.48 | 226.48 | 68639.0 |
| 2017-01-10 08:00:00 | SPY | ETF | 226.6 | 226.61 | 226.43 | 226.49 | 199203.0 |
| 2017-01-10 09:00:00 | SPY | ETF | 226.54 | 226.57 | 226.01 | 226.27 | 6086845.0 |
| 2017-01-10 10:00:00 | SPY | ETF | 226.27 | 226.79 | 226.25 | 226.685 | 9290543.0 |
| 2017-01-10 11:00:00 | SPY | ETF | 226.689 | 227.29 | 226.6709 | 227.16 | 6990286.0 |
| 2017-01-10 12:00:00 | SPY | ETF | 227.16 | 227.45 | 227.15 | 227.18 | 8059348.0 |
| 2017-01-10 13:00:00 | SPY | ETF | 227.18 | 227.25 | 226.56 | 226.62 | 5143835.0 |
| 2017-01-10 14:00:00 | SPY | ETF | 226.61 | 226.72 | 226.38 | 226.595 | 7868697.0 |
| 2017-01-10 15:00:00 | SPY | ETF | 226.6 | 226.96 | 226.37 | 226.43 | 11664954.0 |
| 2017-01-10 16:00:00 | SPY | ETF | 226.43 | 226.57 | 226.37 | 226.44 | 6859457.0 |
| 2017-01-10 17:00:00 | SPY | ETF | 226.44 | 226.47 | 226.34 | 226.4 | 250033.0 |
| 2017-01-10 18:00:00 | SPY | ETF | 226.4 | 226.48 | 226.33 | 226.39 | 352059.0 |
| 2017-01-10 19:00:00 | SPY | ETF | 226.4 | 226.52 | 226.38 | 226.46 | 64208.0 |
| 2017-01-10 05:00:00 | QQQ | ETF | 122.43 | 122.45 | 122.43 | 122.45 | 298.0 |
| 2017-01-10 06:00:00 | QQQ | ETF | 122.42 | 122.42 | 122.42 | 122.42 | 878.0 |
| 2017-01-10 07:00:00 | QQQ | ETF | 122.38 | 122.43 | 122.38 | 122.42 | 31550.0 |
| 2017-01-10 08:00:00 | QQQ | ETF | 122.42 | 122.42 | 122.32 | 122.35 | 63545.0 |
| 2017-01-10 09:00:00 | QQQ | ETF | 122.35 | 122.5 | 122.1 | 122.29 | 2764141.0 |
| 2017-01-10 10:00:00 | QQQ | ETF | 122.28 | 122.51 | 122.19 | 122.47 | 2011928.0 |
| 2017-01-10 11:00:00 | QQQ | ETF | 122.47 | 122.95 | 122.45 | 122.84 | 2483235.0 |
| 2017-01-10 12:00:00 | QQQ | ETF | 122.85 | 122.97 | 122.78 | 122.7999 | 1177797.0 |
| 2017-01-10 13:00:00 | QQQ | ETF | 122.7939 | 122.9 | 122.56 | 122.59 | 1185410.0 |
| 2017-01-10 14:00:00 | QQQ | ETF | 122.59 | 122.72 | 122.5 | 122.63 | 2067975.0 |
| 2017-01-10 15:00:00 | QQQ | ETF | 122.63 | 122.81 | 122.58 | 122.6 | 2665235.0 |
| 2017-01-10 16:00:00 | QQQ | ETF | 122.59 | 122.64 | 122.56 | 122.62 | 607012.0 |
| 2017-01-10 18:00:00 | QQQ | ETF | 122.6 | 122.63 | 122.59 | 122.59 | 400.0 |
| 2017-01-10 19:00:00 | QQQ | ETF | 122.6 | 122.65 | 122.55 | 122.6 | 5534.0 |
| 2017-01-10 04:00:00 | IWM | ETF | 134.83 | 134.85 | 134.76 | 134.76 | 507.0 |
| 2017-01-10 05:00:00 | IWM | ETF | 134.85 | 134.85 | 134.85 | 134.85 | 700.0 |
| 2017-01-10 06:00:00 | IWM | ETF | 134.92 | 134.92 | 134.92 | 134.92 | 100.0 |
| 2017-01-10 07:00:00 | IWM | ETF | 134.83 | 134.88 | 134.79 | 134.79 | 25123.0 |
| 2017-01-10 08:00:00 | IWM | ETF | 134.81 | 134.9 | 134.7 | 134.89 | 46454.0 |
| 2017-01-10 09:00:00 | IWM | ETF | 134.99 | 135.36 | 134.76 | 135.295 | 2395568.0 |
| 2017-01-10 10:00:00 | IWM | ETF | 135.3 | 135.9 | 134.98 | 135.6693 | 2661878.0 |
| 2017-01-10 11:00:00 | IWM | ETF | 135.67 | 136.38 | 135.67 | 136.02 | 3352893.0 |
| 2017-01-10 12:00:00 | IWM | ETF | 136.02 | 136.24 | 135.92 | 135.95 | 1549806.0 |
| 2017-01-10 13:00:00 | IWM | ETF | 135.96 | 136.03 | 135.54 | 135.59 | 1420797.0 |
| 2017-01-10 14:00:00 | IWM | ETF | 135.59 | 135.805 | 135.37 | 135.76 | 1406085.0 |
| 2017-01-10 15:00:00 | IWM | ETF | 135.76 | 136.23 | 135.76 | 136.12 | 3678215.0 |
| 2017-01-10 16:00:00 | IWM | ETF | 136.09 | 136.2 | 136.01 | 136.03 | 1251696.0 |
| 2017-01-10 17:00:00 | IWM | ETF | 136.05 | 136.06 | 136.01 | 136.04 | 7627.0 |
| 2017-01-10 18:00:00 | IWM | ETF | 136.07 | 136.08 | 136.05 | 136.07 | 5018.0 |
| 2017-01-10 19:00:00 | IWM | ETF | 136.07 | 136.1 | 136.06 | 136.06 | 2800.0 |
| 2017-01-10 08:00:00 | DIA | ETF | 198.75 | 198.75 | 198.75 | 198.75 | 100.0 |
| 2017-01-10 09:00:00 | DIA | ETF | 198.66 | 198.72 | 198.21 | 198.44 | 437921.0 |
| 2017-01-10 10:00:00 | DIA | ETF | 198.45 | 198.96 | 198.42 | 198.87 | 318528.0 |
| 2017-01-10 11:00:00 | DIA | ETF | 198.88 | 199.309 | 198.88 | 199.16 | 353886.0 |
> showing 50 of 8,807 rows — these rows as CSV