PREVIEW / etf_1hour / 2015-10-21
file: by_date/etf_1hour/2015/2015-10-21.parquet size: 238 KB rows: 7,577
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-10-21 04:00:00 | SPY | ETF | 202.8 | 203.18 | 202.8 | 203.17 | 52046.0 |
| 2015-10-21 05:00:00 | SPY | ETF | 203.17 | 203.64 | 203.17 | 203.52 | 25845.0 |
| 2015-10-21 06:00:00 | SPY | ETF | 203.52 | 203.85 | 203.5 | 203.62 | 116293.0 |
| 2015-10-21 07:00:00 | SPY | ETF | 203.58 | 203.75 | 203.5 | 203.63 | 510858.0 |
| 2015-10-21 08:00:00 | SPY | ETF | 203.62 | 203.73 | 203.54 | 203.61 | 345325.0 |
| 2015-10-21 09:00:00 | SPY | ETF | 203.61 | 203.79 | 203.25 | 203.43 | 10089452.0 |
| 2015-10-21 10:00:00 | SPY | ETF | 203.42 | 203.42 | 202.52 | 203.095 | 18106426.0 |
| 2015-10-21 11:00:00 | SPY | ETF | 203.09 | 203.5 | 202.58 | 203.285 | 11969339.0 |
| 2015-10-21 12:00:00 | SPY | ETF | 203.29 | 203.47 | 203.08 | 203.09 | 6624952.0 |
| 2015-10-21 13:00:00 | SPY | ETF | 203.09 | 203.09 | 201.93 | 202.25 | 17510956.0 |
| 2015-10-21 14:00:00 | SPY | ETF | 202.25 | 203.07 | 202.06 | 202.76 | 11760030.0 |
| 2015-10-21 15:00:00 | SPY | ETF | 202.77 | 203.05 | 201.65 | 201.82 | 18141128.0 |
| 2015-10-21 16:00:00 | SPY | ETF | 201.82 | 201.98 | 201.44 | 201.78 | 5673956.0 |
| 2015-10-21 17:00:00 | SPY | ETF | 201.74 | 201.87 | 201.68 | 201.74 | 588342.0 |
| 2015-10-21 18:00:00 | SPY | ETF | 201.77 | 201.85 | 201.69 | 201.69 | 105059.0 |
| 2015-10-21 19:00:00 | SPY | ETF | 201.72 | 201.75 | 201.56 | 201.72 | 35571.0 |
| 2015-10-21 04:00:00 | QQQ | ETF | 108.09 | 108.19 | 108.09 | 108.19 | 6650.0 |
| 2015-10-21 05:00:00 | QQQ | ETF | 108.27 | 108.51 | 108.27 | 108.48 | 21204.0 |
| 2015-10-21 06:00:00 | QQQ | ETF | 108.46 | 108.61 | 108.44 | 108.58 | 2738.0 |
| 2015-10-21 07:00:00 | QQQ | ETF | 108.48 | 108.61 | 108.47 | 108.53 | 52743.0 |
| 2015-10-21 08:00:00 | QQQ | ETF | 108.54 | 108.74 | 108.54 | 108.66 | 94352.0 |
| 2015-10-21 09:00:00 | QQQ | ETF | 108.67 | 108.84 | 108.36 | 108.639 | 3281583.0 |
| 2015-10-21 10:00:00 | QQQ | ETF | 108.62 | 108.62 | 107.92 | 108.39 | 4944910.0 |
| 2015-10-21 11:00:00 | QQQ | ETF | 108.4 | 108.7 | 107.98 | 108.5462 | 3163339.0 |
| 2015-10-21 12:00:00 | QQQ | ETF | 108.545 | 108.67 | 108.3 | 108.301 | 1440871.0 |
| 2015-10-21 13:00:00 | QQQ | ETF | 108.3001 | 108.3001 | 107.55 | 107.77 | 4255189.0 |
| 2015-10-21 14:00:00 | QQQ | ETF | 107.77 | 108.329 | 107.67 | 108.0767 | 3296029.0 |
| 2015-10-21 15:00:00 | QQQ | ETF | 108.08 | 108.3 | 107.48 | 107.56 | 4809792.0 |
| 2015-10-21 16:00:00 | QQQ | ETF | 107.55 | 107.64 | 107.35 | 107.58 | 686079.0 |
| 2015-10-21 17:00:00 | QQQ | ETF | 107.6 | 107.64 | 107.57 | 107.57 | 1011.0 |
| 2015-10-21 18:00:00 | QQQ | ETF | 107.53 | 107.67 | 107.52 | 107.66 | 10029.0 |
| 2015-10-21 19:00:00 | QQQ | ETF | 107.55 | 107.62 | 107.55 | 107.59 | 4300.0 |
| 2015-10-21 06:00:00 | IWM | ETF | 116.0 | 116.0 | 115.9 | 115.94 | 10000.0 |
| 2015-10-21 07:00:00 | IWM | ETF | 115.96 | 115.97 | 115.9 | 115.93 | 12700.0 |
| 2015-10-21 08:00:00 | IWM | ETF | 115.93 | 116.0 | 115.91 | 115.92 | 85968.0 |
| 2015-10-21 09:00:00 | IWM | ETF | 115.93 | 116.03 | 115.3 | 115.36 | 2067574.0 |
| 2015-10-21 10:00:00 | IWM | ETF | 115.36 | 115.36 | 114.53 | 115.11 | 5735404.0 |
| 2015-10-21 11:00:00 | IWM | ETF | 115.12 | 115.33 | 114.55 | 114.85 | 3855852.0 |
| 2015-10-21 12:00:00 | IWM | ETF | 114.84 | 115.05 | 114.63 | 114.64 | 2086950.0 |
| 2015-10-21 13:00:00 | IWM | ETF | 114.63 | 114.63 | 113.75 | 114.075 | 6378958.0 |
| 2015-10-21 14:00:00 | IWM | ETF | 114.06 | 114.9 | 113.98 | 114.4 | 3096436.0 |
| 2015-10-21 15:00:00 | IWM | ETF | 114.4 | 114.68 | 113.65 | 113.74 | 5982781.0 |
| 2015-10-21 16:00:00 | IWM | ETF | 113.73 | 115.3923 | 113.63 | 113.78 | 1717411.0 |
| 2015-10-21 17:00:00 | IWM | ETF | 113.82 | 113.82 | 113.8 | 113.8 | 44070.0 |
| 2015-10-21 18:00:00 | IWM | ETF | 113.82 | 113.9 | 113.79 | 113.79 | 33500.0 |
| 2015-10-21 19:00:00 | IWM | ETF | 113.79 | 113.87 | 113.79 | 113.83 | 5450.0 |
| 2015-10-21 07:00:00 | DIA | ETF | 172.61 | 172.61 | 172.61 | 172.61 | 600.0 |
| 2015-10-21 08:00:00 | DIA | ETF | 172.5 | 172.52 | 172.45 | 172.45 | 2045.0 |
| 2015-10-21 09:00:00 | DIA | ETF | 172.37 | 172.6599 | 172.28 | 172.35 | 732627.0 |
| 2015-10-21 10:00:00 | DIA | ETF | 172.32 | 172.36 | 171.9 | 172.33 | 799577.0 |
> showing 50 of 7,577 rows — these rows as CSV