PREVIEW / etf_1hour / 2015-07-21
file: by_date/etf_1hour/2015/2015-07-21.parquet size: 242 KB rows: 7,728
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-07-21 04:00:00 | SPY | ETF | 212.73 | 212.87 | 212.65 | 212.65 | 17900.0 |
| 2015-07-21 05:00:00 | SPY | ETF | 212.65 | 212.78 | 212.64 | 212.78 | 13600.0 |
| 2015-07-21 06:00:00 | SPY | ETF | 212.75 | 212.8 | 212.74 | 212.79 | 28593.0 |
| 2015-07-21 07:00:00 | SPY | ETF | 212.8 | 212.83 | 212.68 | 212.7 | 74562.0 |
| 2015-07-21 08:00:00 | SPY | ETF | 212.68 | 212.74 | 212.47 | 212.47 | 262401.0 |
| 2015-07-21 09:00:00 | SPY | ETF | 212.46 | 212.69 | 212.32 | 212.69 | 8003058.0 |
| 2015-07-21 10:00:00 | SPY | ETF | 212.69 | 212.74 | 211.94 | 212.095 | 10298531.0 |
| 2015-07-21 11:00:00 | SPY | ETF | 212.0801 | 212.14 | 211.7 | 211.88 | 9965900.0 |
| 2015-07-21 12:00:00 | SPY | ETF | 211.88 | 212.03 | 211.63 | 211.78 | 9304419.0 |
| 2015-07-21 13:00:00 | SPY | ETF | 211.775 | 211.775 | 211.48 | 211.62 | 6089170.0 |
| 2015-07-21 14:00:00 | SPY | ETF | 211.62 | 211.885 | 211.39 | 211.605 | 8487572.0 |
| 2015-07-21 15:00:00 | SPY | ETF | 211.61 | 211.97 | 211.47 | 211.75 | 15890565.0 |
| 2015-07-21 16:00:00 | SPY | ETF | 211.75 | 212.11 | 211.28 | 211.39 | 8040483.0 |
| 2015-07-21 17:00:00 | SPY | ETF | 211.4 | 211.4 | 211.2 | 211.32 | 448400.0 |
| 2015-07-21 18:00:00 | SPY | ETF | 211.33 | 211.44 | 211.27 | 211.28 | 162884.0 |
| 2015-07-21 19:00:00 | SPY | ETF | 211.28 | 211.32 | 211.25 | 211.28 | 40501.0 |
| 2015-07-21 04:00:00 | QQQ | ETF | 114.03 | 114.15 | 114.0 | 114.15 | 566.0 |
| 2015-07-21 06:00:00 | QQQ | ETF | 114.1 | 114.2 | 114.1 | 114.2 | 3950.0 |
| 2015-07-21 07:00:00 | QQQ | ETF | 114.2 | 114.22 | 114.14 | 114.14 | 35298.0 |
| 2015-07-21 08:00:00 | QQQ | ETF | 114.16 | 114.26 | 114.03 | 114.03 | 152158.0 |
| 2015-07-21 09:00:00 | QQQ | ETF | 114.02 | 114.14 | 113.75 | 114.14 | 3261111.0 |
| 2015-07-21 10:00:00 | QQQ | ETF | 114.14 | 114.2 | 113.58 | 113.74 | 4938012.0 |
| 2015-07-21 11:00:00 | QQQ | ETF | 113.73 | 113.93 | 113.6 | 113.8799 | 2918723.0 |
| 2015-07-21 12:00:00 | QQQ | ETF | 113.87 | 114.07 | 113.79 | 113.87 | 1837181.0 |
| 2015-07-21 13:00:00 | QQQ | ETF | 113.865 | 113.91 | 113.67 | 113.87 | 1745569.0 |
| 2015-07-21 14:00:00 | QQQ | ETF | 113.87 | 113.9908 | 113.66 | 113.89 | 2954890.0 |
| 2015-07-21 15:00:00 | QQQ | ETF | 113.89 | 114.05 | 113.78 | 113.87 | 4256604.0 |
| 2015-07-21 16:00:00 | QQQ | ETF | 113.88 | 114.05 | 112.64 | 112.78 | 3771062.0 |
| 2015-07-21 17:00:00 | QQQ | ETF | 112.76 | 112.76 | 112.53 | 112.73 | 499058.0 |
| 2015-07-21 18:00:00 | QQQ | ETF | 112.75 | 112.82 | 112.62 | 112.62 | 162805.0 |
| 2015-07-21 19:00:00 | QQQ | ETF | 112.62 | 112.66 | 112.6 | 112.64 | 79682.0 |
| 2015-07-21 07:00:00 | IWM | ETF | 125.26 | 125.26 | 125.26 | 125.26 | 10000.0 |
| 2015-07-21 08:00:00 | IWM | ETF | 125.25 | 125.25 | 125.05 | 125.09 | 20350.0 |
| 2015-07-21 09:00:00 | IWM | ETF | 125.03 | 125.8 | 125.0 | 125.67 | 2806932.0 |
| 2015-07-21 10:00:00 | IWM | ETF | 125.67 | 125.7 | 124.455 | 124.585 | 4267621.0 |
| 2015-07-21 11:00:00 | IWM | ETF | 124.57 | 124.595 | 124.11 | 124.37 | 4573407.0 |
| 2015-07-21 12:00:00 | IWM | ETF | 124.36 | 125.05 | 124.34 | 124.6044 | 3359036.0 |
| 2015-07-21 13:00:00 | IWM | ETF | 124.5899 | 124.6099 | 124.25 | 124.51 | 1891547.0 |
| 2015-07-21 14:00:00 | IWM | ETF | 124.51 | 124.69 | 124.27 | 124.47 | 1965240.0 |
| 2015-07-21 15:00:00 | IWM | ETF | 124.47 | 124.63 | 124.33 | 124.48 | 3717094.0 |
| 2015-07-21 16:00:00 | IWM | ETF | 124.48 | 124.62 | 124.11 | 124.49 | 1886649.0 |
| 2015-07-21 17:00:00 | IWM | ETF | 124.19 | 124.49 | 124.12 | 124.17 | 24328.0 |
| 2015-07-21 18:00:00 | IWM | ETF | 124.2 | 124.2 | 124.15 | 124.18 | 971.0 |
| 2015-07-21 19:00:00 | IWM | ETF | 124.15 | 124.15 | 124.15 | 124.15 | 625.0 |
| 2015-07-21 07:00:00 | DIA | ETF | 180.37 | 180.37 | 180.33 | 180.33 | 1900.0 |
| 2015-07-21 08:00:00 | DIA | ETF | 180.33 | 180.33 | 179.96 | 179.96 | 6210.0 |
| 2015-07-21 09:00:00 | DIA | ETF | 179.93 | 179.94 | 179.42 | 179.6 | 775620.0 |
| 2015-07-21 10:00:00 | DIA | ETF | 179.6 | 179.629 | 178.79 | 178.959 | 918969.0 |
| 2015-07-21 11:00:00 | DIA | ETF | 178.95 | 178.99 | 178.63 | 178.71 | 756065.0 |
| 2015-07-21 12:00:00 | DIA | ETF | 178.71 | 178.82 | 178.56 | 178.73 | 488011.0 |
> showing 50 of 7,728 rows — these rows as CSV