PREVIEW / etf_1hour / 2017-01-11
file: by_date/etf_1hour/2017/2017-01-11.parquet size: 273 KB rows: 8,782
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-11 04:00:00 | SPY | ETF | 226.15 | 226.52 | 226.06 | 226.52 | 35140.0 |
| 2017-01-11 05:00:00 | SPY | ETF | 226.51 | 226.51 | 226.42 | 226.48 | 5407.0 |
| 2017-01-11 06:00:00 | SPY | ETF | 226.46 | 226.53 | 226.36 | 226.53 | 16847.0 |
| 2017-01-11 07:00:00 | SPY | ETF | 226.48 | 226.51 | 226.15 | 226.15 | 77352.0 |
| 2017-01-11 08:00:00 | SPY | ETF | 226.48 | 226.48 | 226.12 | 226.26 | 158329.0 |
| 2017-01-11 09:00:00 | SPY | ETF | 226.25 | 226.81 | 226.25 | 226.8 | 5932338.0 |
| 2017-01-11 10:00:00 | SPY | ETF | 226.81 | 227.0078 | 226.48 | 226.68 | 8574851.0 |
| 2017-01-11 11:00:00 | SPY | ETF | 226.685 | 227.02 | 225.59 | 226.68 | 14320205.0 |
| 2017-01-11 12:00:00 | SPY | ETF | 226.68 | 226.83 | 225.83 | 226.2659 | 9697861.0 |
| 2017-01-11 13:00:00 | SPY | ETF | 226.26 | 226.45 | 225.64 | 226.33 | 10771192.0 |
| 2017-01-11 14:00:00 | SPY | ETF | 226.34 | 226.73 | 226.22 | 226.625 | 5641681.0 |
| 2017-01-11 15:00:00 | SPY | ETF | 226.625 | 227.07 | 226.61 | 227.06 | 10736027.0 |
| 2017-01-11 16:00:00 | SPY | ETF | 227.07 | 227.22 | 226.46 | 227.15 | 7649378.0 |
| 2017-01-11 17:00:00 | SPY | ETF | 227.14 | 227.18 | 227.07 | 227.11 | 257519.0 |
| 2017-01-11 18:00:00 | SPY | ETF | 227.09 | 227.09 | 227.02 | 227.05 | 57415.0 |
| 2017-01-11 19:00:00 | SPY | ETF | 227.07 | 227.07 | 226.88 | 226.94 | 42895.0 |
| 2017-01-11 04:00:00 | QQQ | ETF | 122.5 | 122.5 | 122.5 | 122.5 | 1032.0 |
| 2017-01-11 06:00:00 | QQQ | ETF | 122.72 | 122.72 | 122.68 | 122.72 | 1598.0 |
| 2017-01-11 07:00:00 | QQQ | ETF | 122.71 | 122.71 | 122.57 | 122.59 | 8098.0 |
| 2017-01-11 08:00:00 | QQQ | ETF | 122.55 | 122.62 | 122.53 | 122.62 | 17093.0 |
| 2017-01-11 09:00:00 | QQQ | ETF | 122.59 | 122.74 | 122.51 | 122.7 | 2266173.0 |
| 2017-01-11 10:00:00 | QQQ | ETF | 122.72 | 122.89 | 122.56 | 122.76 | 2193539.0 |
| 2017-01-11 11:00:00 | QQQ | ETF | 122.77 | 122.88 | 122.02 | 122.64 | 3957081.0 |
| 2017-01-11 12:00:00 | QQQ | ETF | 122.65 | 122.74 | 122.23 | 122.44 | 2354937.0 |
| 2017-01-11 13:00:00 | QQQ | ETF | 122.43 | 122.47 | 122.06 | 122.4 | 2130463.0 |
| 2017-01-11 14:00:00 | QQQ | ETF | 122.41 | 122.8 | 122.345 | 122.77 | 1920718.0 |
| 2017-01-11 15:00:00 | QQQ | ETF | 122.76 | 122.93 | 122.73 | 122.92 | 2868420.0 |
| 2017-01-11 16:00:00 | QQQ | ETF | 122.92 | 122.98 | 122.89 | 122.97 | 1203925.0 |
| 2017-01-11 17:00:00 | QQQ | ETF | 123.0 | 123.0 | 122.91 | 122.91 | 4314.0 |
| 2017-01-11 18:00:00 | QQQ | ETF | 122.91 | 122.91 | 122.85 | 122.85 | 6985.0 |
| 2017-01-11 19:00:00 | QQQ | ETF | 122.87 | 122.87 | 122.77 | 122.79 | 7245.0 |
| 2017-01-11 04:00:00 | IWM | ETF | 136.0 | 136.0 | 136.0 | 136.0 | 100.0 |
| 2017-01-11 05:00:00 | IWM | ETF | 136.09 | 136.09 | 136.04 | 136.04 | 1563.0 |
| 2017-01-11 07:00:00 | IWM | ETF | 135.89 | 135.89 | 135.88 | 135.89 | 6000.0 |
| 2017-01-11 08:00:00 | IWM | ETF | 135.9 | 136.18 | 135.87 | 136.15 | 332409.0 |
| 2017-01-11 09:00:00 | IWM | ETF | 136.16 | 136.54 | 135.53 | 136.21 | 2385593.0 |
| 2017-01-11 10:00:00 | IWM | ETF | 136.21 | 136.68 | 135.95 | 136.27 | 3978988.0 |
| 2017-01-11 11:00:00 | IWM | ETF | 136.27 | 136.79 | 135.42 | 136.44 | 4696814.0 |
| 2017-01-11 12:00:00 | IWM | ETF | 136.44 | 136.5 | 135.72 | 136.02 | 2706866.0 |
| 2017-01-11 13:00:00 | IWM | ETF | 136.03 | 136.11 | 135.44 | 136.0 | 3210328.0 |
| 2017-01-11 14:00:00 | IWM | ETF | 136.01 | 136.28 | 135.805 | 136.06 | 2331069.0 |
| 2017-01-11 15:00:00 | IWM | ETF | 136.06 | 136.48 | 136.05 | 136.34 | 3208511.0 |
| 2017-01-11 16:00:00 | IWM | ETF | 136.33 | 136.68 | 136.06 | 136.68 | 2100461.0 |
| 2017-01-11 17:00:00 | IWM | ETF | 136.63 | 136.63 | 136.63 | 136.63 | 200.0 |
| 2017-01-11 18:00:00 | IWM | ETF | 136.57 | 136.6 | 136.52 | 136.6 | 1886.0 |
| 2017-01-11 19:00:00 | IWM | ETF | 136.52 | 136.52 | 136.46 | 136.51 | 2173.0 |
| 2017-01-11 07:00:00 | DIA | ETF | 198.4 | 198.4 | 198.4 | 198.4 | 100.0 |
| 2017-01-11 08:00:00 | DIA | ETF | 198.43 | 198.47 | 198.39 | 198.47 | 2417.0 |
| 2017-01-11 09:00:00 | DIA | ETF | 198.5 | 199.0801 | 198.5 | 199.0801 | 619436.0 |
| 2017-01-11 10:00:00 | DIA | ETF | 199.09 | 199.47 | 198.9 | 199.21 | 821970.0 |
> showing 50 of 8,782 rows — these rows as CSV