PREVIEW / etf_1hour / 2015-08-31
file: by_date/etf_1hour/2015/2015-08-31.parquet size: 248 KB rows: 7,945
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-08-31 04:00:00 | SPY | ETF | 197.87 | 197.87 | 197.35 | 197.57 | 65668.0 |
| 2015-08-31 05:00:00 | SPY | ETF | 197.56 | 198.06 | 197.47 | 197.92 | 33649.0 |
| 2015-08-31 06:00:00 | SPY | ETF | 198.0 | 198.39 | 197.8 | 198.1 | 105773.0 |
| 2015-08-31 07:00:00 | SPY | ETF | 198.09 | 198.26 | 197.93 | 198.17 | 263842.0 |
| 2015-08-31 08:00:00 | SPY | ETF | 198.19 | 198.44 | 197.0 | 197.9 | 1182388.0 |
| 2015-08-31 09:00:00 | SPY | ETF | 197.86 | 199.3404 | 197.43 | 197.48 | 18218169.0 |
| 2015-08-31 10:00:00 | SPY | ETF | 197.48 | 198.4399 | 197.01 | 197.97 | 22577770.0 |
| 2015-08-31 11:00:00 | SPY | ETF | 197.96 | 199.125 | 197.46 | 198.52 | 23102267.0 |
| 2015-08-31 12:00:00 | SPY | ETF | 198.525 | 199.05 | 198.35 | 198.52 | 8770491.0 |
| 2015-08-31 13:00:00 | SPY | ETF | 198.5308 | 198.73 | 197.93 | 198.15 | 10470750.0 |
| 2015-08-31 14:00:00 | SPY | ETF | 198.16 | 198.4 | 197.19 | 197.35 | 15802944.0 |
| 2015-08-31 15:00:00 | SPY | ETF | 197.35 | 199.035 | 197.32 | 197.6 | 32397966.0 |
| 2015-08-31 16:00:00 | SPY | ETF | 197.63 | 197.8475 | 197.01 | 197.31 | 15413227.0 |
| 2015-08-31 17:00:00 | SPY | ETF | 197.31 | 199.3526 | 197.26 | 197.31 | 1011242.0 |
| 2015-08-31 18:00:00 | SPY | ETF | 197.31 | 197.67 | 196.81 | 196.98 | 2742368.0 |
| 2015-08-31 19:00:00 | SPY | ETF | 196.97 | 196.99 | 196.17 | 196.33 | 213910.0 |
| 2015-08-31 04:00:00 | QQQ | ETF | 104.96 | 104.96 | 104.69 | 104.8 | 1830.0 |
| 2015-08-31 05:00:00 | QQQ | ETF | 104.95 | 105.1 | 104.95 | 105.07 | 300.0 |
| 2015-08-31 06:00:00 | QQQ | ETF | 104.91 | 105.2 | 104.91 | 105.1 | 5100.0 |
| 2015-08-31 07:00:00 | QQQ | ETF | 105.09 | 105.22 | 105.02 | 105.2 | 17960.0 |
| 2015-08-31 08:00:00 | QQQ | ETF | 105.21 | 105.31 | 104.91 | 104.95 | 140525.0 |
| 2015-08-31 09:00:00 | QQQ | ETF | 104.99 | 105.44 | 104.73 | 104.76 | 4587314.0 |
| 2015-08-31 10:00:00 | QQQ | ETF | 104.77 | 105.3 | 104.36 | 105.0 | 5020740.0 |
| 2015-08-31 11:00:00 | QQQ | ETF | 105.0 | 105.58 | 104.64 | 105.3 | 4673974.0 |
| 2015-08-31 12:00:00 | QQQ | ETF | 105.3 | 105.61 | 105.23 | 105.41 | 1996432.0 |
| 2015-08-31 13:00:00 | QQQ | ETF | 105.41 | 105.5 | 104.91 | 104.96 | 2833195.0 |
| 2015-08-31 14:00:00 | QQQ | ETF | 104.97 | 105.14 | 104.05 | 104.18 | 4611974.0 |
| 2015-08-31 15:00:00 | QQQ | ETF | 104.18 | 104.73 | 104.15 | 104.33 | 8142678.0 |
| 2015-08-31 16:00:00 | QQQ | ETF | 104.34 | 104.35 | 104.11 | 104.23 | 2281230.0 |
| 2015-08-31 17:00:00 | QQQ | ETF | 104.24 | 104.26 | 104.18 | 104.18 | 60997.0 |
| 2015-08-31 18:00:00 | QQQ | ETF | 104.26 | 104.26 | 103.96 | 104.06 | 29810.0 |
| 2015-08-31 19:00:00 | QQQ | ETF | 104.05 | 104.07 | 103.6 | 103.66 | 33711.0 |
| 2015-08-31 04:00:00 | IWM | ETF | 114.88 | 114.9 | 114.79 | 114.9 | 1630.0 |
| 2015-08-31 05:00:00 | IWM | ETF | 114.89 | 114.98 | 114.89 | 114.98 | 3000.0 |
| 2015-08-31 06:00:00 | IWM | ETF | 115.2 | 115.2 | 115.05 | 115.05 | 2100.0 |
| 2015-08-31 07:00:00 | IWM | ETF | 115.1 | 115.22 | 114.96 | 115.2 | 5400.0 |
| 2015-08-31 08:00:00 | IWM | ETF | 115.17 | 115.3 | 114.98 | 115.04 | 86390.0 |
| 2015-08-31 09:00:00 | IWM | ETF | 115.07 | 115.51 | 114.95 | 115.06 | 3734739.0 |
| 2015-08-31 10:00:00 | IWM | ETF | 115.075 | 115.74 | 114.76 | 115.36 | 4416941.0 |
| 2015-08-31 11:00:00 | IWM | ETF | 115.35 | 115.98 | 115.1 | 115.4523 | 3514815.0 |
| 2015-08-31 12:00:00 | IWM | ETF | 115.45 | 115.81 | 115.44 | 115.53 | 1445546.0 |
| 2015-08-31 13:00:00 | IWM | ETF | 115.53 | 115.69 | 115.18 | 115.415 | 2189570.0 |
| 2015-08-31 14:00:00 | IWM | ETF | 115.42 | 115.52 | 114.8 | 114.95 | 2931821.0 |
| 2015-08-31 15:00:00 | IWM | ETF | 114.95 | 115.45 | 114.88 | 115.16 | 6052970.0 |
| 2015-08-31 16:00:00 | IWM | ETF | 115.17 | 115.25 | 114.94 | 115.04 | 2672917.0 |
| 2015-08-31 17:00:00 | IWM | ETF | 115.06 | 115.2 | 114.99 | 115.0 | 91400.0 |
| 2015-08-31 18:00:00 | IWM | ETF | 115.0 | 115.12 | 114.9 | 114.9 | 5900.0 |
| 2015-08-31 19:00:00 | IWM | ETF | 114.98 | 115.0 | 114.66 | 114.66 | 7803.0 |
| 2015-08-31 04:00:00 | DIA | ETF | 165.58 | 165.58 | 165.01 | 165.01 | 300.0 |
| 2015-08-31 05:00:00 | DIA | ETF | 165.07 | 165.31 | 165.07 | 165.31 | 200.0 |
> showing 50 of 7,945 rows — these rows as CSV