PREVIEW / etf_1hour / 2015-11-30
file: by_date/etf_1hour/2015/2015-11-30.parquet size: 241 KB rows: 7,799
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 |
|---|---|---|---|---|---|---|---|
| 2015-11-30 04:00:00 | SPY | ETF | 209.42 | 209.88 | 209.42 | 209.59 | 10201.0 |
| 2015-11-30 05:00:00 | SPY | ETF | 209.62 | 209.62 | 209.45 | 209.57 | 5141.0 |
| 2015-11-30 06:00:00 | SPY | ETF | 209.62 | 210.06 | 209.62 | 209.77 | 42800.0 |
| 2015-11-30 07:00:00 | SPY | ETF | 209.78 | 210.19 | 209.75 | 210.13 | 195784.0 |
| 2015-11-30 08:00:00 | SPY | ETF | 210.12 | 210.18 | 209.29 | 210.09 | 618214.0 |
| 2015-11-30 09:00:00 | SPY | ETF | 210.1 | 210.12 | 209.14 | 209.1733 | 9632704.0 |
| 2015-11-30 10:00:00 | SPY | ETF | 209.17 | 209.51 | 209.02 | 209.2249 | 12385298.0 |
| 2015-11-30 11:00:00 | SPY | ETF | 209.22 | 209.49 | 208.72 | 208.84 | 9489461.0 |
| 2015-11-30 12:00:00 | SPY | ETF | 208.84 | 209.12 | 208.75 | 208.935 | 7067978.0 |
| 2015-11-30 13:00:00 | SPY | ETF | 208.93 | 209.48 | 208.83 | 209.375 | 9695607.0 |
| 2015-11-30 14:00:00 | SPY | ETF | 209.38 | 209.41 | 208.81 | 208.84 | 9054637.0 |
| 2015-11-30 15:00:00 | SPY | ETF | 208.83 | 208.98 | 208.56 | 208.67 | 32732983.0 |
| 2015-11-30 16:00:00 | SPY | ETF | 208.67 | 209.23 | 208.5172 | 209.22 | 19113627.0 |
| 2015-11-30 17:00:00 | SPY | ETF | 209.19 | 209.26 | 208.69 | 209.23 | 812142.0 |
| 2015-11-30 18:00:00 | SPY | ETF | 209.23 | 209.6 | 208.69 | 209.43 | 155074.0 |
| 2015-11-30 19:00:00 | SPY | ETF | 209.41 | 209.65 | 209.39 | 209.57 | 244299.0 |
| 2015-11-30 04:00:00 | QQQ | ETF | 114.25 | 114.25 | 114.25 | 114.25 | 100.0 |
| 2015-11-30 06:00:00 | QQQ | ETF | 114.41 | 114.65 | 114.38 | 114.6 | 3200.0 |
| 2015-11-30 07:00:00 | QQQ | ETF | 114.55 | 114.77 | 114.55 | 114.77 | 9560.0 |
| 2015-11-30 08:00:00 | QQQ | ETF | 114.75 | 114.78 | 114.71 | 114.73 | 118445.0 |
| 2015-11-30 09:00:00 | QQQ | ETF | 114.74 | 114.74 | 114.2 | 114.2298 | 2476754.0 |
| 2015-11-30 10:00:00 | QQQ | ETF | 114.2299 | 114.39 | 114.01 | 114.15 | 2324531.0 |
| 2015-11-30 11:00:00 | QQQ | ETF | 114.15 | 114.28 | 113.7 | 113.75 | 2429134.0 |
| 2015-11-30 12:00:00 | QQQ | ETF | 113.74 | 113.87 | 113.65 | 113.81 | 1595342.0 |
| 2015-11-30 13:00:00 | QQQ | ETF | 113.8099 | 114.315 | 113.6801 | 114.25 | 2391193.0 |
| 2015-11-30 14:00:00 | QQQ | ETF | 114.25 | 114.35 | 114.0 | 114.015 | 1824398.0 |
| 2015-11-30 15:00:00 | QQQ | ETF | 114.02 | 114.3001 | 113.845 | 114.0 | 8336677.0 |
| 2015-11-30 16:00:00 | QQQ | ETF | 114.0 | 114.3 | 113.97 | 114.28 | 804329.0 |
| 2015-11-30 17:00:00 | QQQ | ETF | 114.23 | 114.24 | 114.02 | 114.22 | 1909904.0 |
| 2015-11-30 18:00:00 | QQQ | ETF | 114.26 | 114.46 | 114.26 | 114.37 | 54474.0 |
| 2015-11-30 19:00:00 | QQQ | ETF | 114.37 | 114.51 | 114.37 | 114.45 | 23490.0 |
| 2015-11-30 05:00:00 | IWM | ETF | 119.84 | 119.84 | 119.84 | 119.84 | 100.0 |
| 2015-11-30 07:00:00 | IWM | ETF | 120.09 | 120.3 | 120.09 | 120.3 | 41209.0 |
| 2015-11-30 08:00:00 | IWM | ETF | 120.22 | 120.27 | 120.16 | 120.16 | 108723.0 |
| 2015-11-30 09:00:00 | IWM | ETF | 120.15 | 120.18 | 119.5799 | 119.68 | 2539287.0 |
| 2015-11-30 10:00:00 | IWM | ETF | 119.68 | 119.9767 | 119.61 | 119.78 | 3596371.0 |
| 2015-11-30 11:00:00 | IWM | ETF | 119.78 | 119.92 | 119.46 | 119.55 | 3203091.0 |
| 2015-11-30 12:00:00 | IWM | ETF | 119.54 | 119.59 | 119.19 | 119.2 | 1930033.0 |
| 2015-11-30 13:00:00 | IWM | ETF | 119.19 | 119.47 | 119.09 | 119.32 | 1794556.0 |
| 2015-11-30 14:00:00 | IWM | ETF | 119.32 | 119.5 | 119.12 | 119.15 | 1356895.0 |
| 2015-11-30 15:00:00 | IWM | ETF | 119.1501 | 119.55 | 119.05 | 119.105 | 5296872.0 |
| 2015-11-30 16:00:00 | IWM | ETF | 119.1 | 119.5491 | 119.07 | 119.51 | 4675653.0 |
| 2015-11-30 17:00:00 | IWM | ETF | 119.53 | 119.53 | 119.1 | 119.45 | 1514625.0 |
| 2015-11-30 18:00:00 | IWM | ETF | 119.52 | 119.59 | 119.45 | 119.58 | 1190.0 |
| 2015-11-30 19:00:00 | IWM | ETF | 119.47 | 119.6 | 119.47 | 119.6 | 1000.0 |
| 2015-11-30 08:00:00 | DIA | ETF | 178.44 | 178.52 | 178.42 | 178.43 | 1700.0 |
| 2015-11-30 09:00:00 | DIA | ETF | 178.41 | 178.44 | 177.58 | 177.62 | 604516.0 |
| 2015-11-30 10:00:00 | DIA | ETF | 177.62 | 177.97 | 177.52 | 177.758 | 573256.0 |
| 2015-11-30 11:00:00 | DIA | ETF | 177.76 | 177.9301 | 177.2 | 177.28 | 467428.0 |
| 2015-11-30 12:00:00 | DIA | ETF | 177.28 | 177.56 | 177.2 | 177.44 | 308803.0 |
> showing 50 of 7,799 rows — these rows as CSV