PREVIEW / etf_1hour / 2015-06-29
file: by_date/etf_1hour/2015/2015-06-29.parquet size: 260 KB rows: 8,364
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-06-29 04:00:00 | SPY | ETF | 208.05 | 208.37 | 207.65 | 208.3 | 76773.0 |
| 2015-06-29 05:00:00 | SPY | ETF | 208.11 | 208.35 | 207.77 | 207.9 | 50663.0 |
| 2015-06-29 06:00:00 | SPY | ETF | 207.83 | 207.91 | 207.41 | 207.78 | 286778.0 |
| 2015-06-29 07:00:00 | SPY | ETF | 207.8 | 208.06 | 207.61 | 208.0 | 684582.0 |
| 2015-06-29 08:00:00 | SPY | ETF | 208.0 | 208.05 | 206.805 | 207.94 | 1996308.0 |
| 2015-06-29 09:00:00 | SPY | ETF | 207.93 | 208.82 | 207.32 | 208.3 | 23239981.0 |
| 2015-06-29 10:00:00 | SPY | ETF | 208.29 | 208.73 | 207.71 | 207.7599 | 18901467.0 |
| 2015-06-29 11:00:00 | SPY | ETF | 207.76 | 207.81 | 207.24 | 207.5 | 19344272.0 |
| 2015-06-29 12:00:00 | SPY | ETF | 207.5 | 207.625 | 207.0 | 207.12 | 14590168.0 |
| 2015-06-29 13:00:00 | SPY | ETF | 207.12 | 209.828 | 206.7 | 206.86 | 19773559.0 |
| 2015-06-29 14:00:00 | SPY | ETF | 206.845 | 206.86 | 206.05 | 206.21 | 26815813.0 |
| 2015-06-29 15:00:00 | SPY | ETF | 206.21 | 206.36 | 205.33 | 205.44 | 49544018.0 |
| 2015-06-29 16:00:00 | SPY | ETF | 205.39 | 205.9 | 205.36 | 205.85 | 13809550.0 |
| 2015-06-29 17:00:00 | SPY | ETF | 205.85 | 205.96 | 205.42 | 205.94 | 2448754.0 |
| 2015-06-29 18:00:00 | SPY | ETF | 205.96 | 205.97 | 205.72 | 205.9 | 170009.0 |
| 2015-06-29 19:00:00 | SPY | ETF | 205.9 | 206.0 | 205.87 | 205.98 | 167154.0 |
| 2015-06-29 04:00:00 | QQQ | ETF | 108.32 | 108.32 | 108.0 | 108.15 | 18457.0 |
| 2015-06-29 05:00:00 | QQQ | ETF | 108.28 | 108.28 | 108.02 | 108.04 | 7765.0 |
| 2015-06-29 06:00:00 | QQQ | ETF | 108.03 | 108.05 | 107.84 | 107.84 | 6200.0 |
| 2015-06-29 07:00:00 | QQQ | ETF | 108.01 | 108.14 | 107.93 | 108.12 | 113132.0 |
| 2015-06-29 08:00:00 | QQQ | ETF | 108.12 | 108.14 | 107.94 | 108.08 | 110746.0 |
| 2015-06-29 09:00:00 | QQQ | ETF | 108.09 | 108.66 | 107.89 | 108.345 | 7292161.0 |
| 2015-06-29 10:00:00 | QQQ | ETF | 108.345 | 108.58 | 108.01 | 108.04 | 5135836.0 |
| 2015-06-29 11:00:00 | QQQ | ETF | 108.04 | 108.08 | 107.71 | 107.8599 | 4305984.0 |
| 2015-06-29 12:00:00 | QQQ | ETF | 107.855 | 107.97 | 107.66 | 107.74 | 2313750.0 |
| 2015-06-29 13:00:00 | QQQ | ETF | 107.73 | 107.73 | 107.43 | 107.51 | 3031605.0 |
| 2015-06-29 14:00:00 | QQQ | ETF | 107.5 | 107.52 | 107.0 | 107.07 | 5817605.0 |
| 2015-06-29 15:00:00 | QQQ | ETF | 107.0688 | 107.1699 | 106.64 | 106.73 | 11906675.0 |
| 2015-06-29 16:00:00 | QQQ | ETF | 106.68 | 107.01 | 106.636 | 106.99 | 1405539.0 |
| 2015-06-29 17:00:00 | QQQ | ETF | 106.99 | 106.99 | 106.69 | 106.97 | 645969.0 |
| 2015-06-29 18:00:00 | QQQ | ETF | 107.0 | 107.04 | 106.7 | 107.02 | 190129.0 |
| 2015-06-29 19:00:00 | QQQ | ETF | 107.02 | 107.05 | 106.99 | 107.01 | 91090.0 |
| 2015-06-29 04:00:00 | IWM | ETF | 126.41 | 126.43 | 126.24 | 126.24 | 1775.0 |
| 2015-06-29 05:00:00 | IWM | ETF | 126.08 | 126.38 | 126.08 | 126.38 | 15000.0 |
| 2015-06-29 06:00:00 | IWM | ETF | 126.07 | 126.35 | 126.07 | 126.35 | 26800.0 |
| 2015-06-29 07:00:00 | IWM | ETF | 126.48 | 126.5 | 126.32 | 126.36 | 157857.0 |
| 2015-06-29 08:00:00 | IWM | ETF | 126.41 | 126.62 | 126.37 | 126.54 | 273258.0 |
| 2015-06-29 09:00:00 | IWM | ETF | 126.52 | 127.07 | 126.17 | 126.54 | 5576487.0 |
| 2015-06-29 10:00:00 | IWM | ETF | 126.535 | 126.99 | 126.18 | 126.2 | 3897860.0 |
| 2015-06-29 11:00:00 | IWM | ETF | 126.19 | 126.26 | 125.86 | 126.11 | 3912515.0 |
| 2015-06-29 12:00:00 | IWM | ETF | 126.125 | 126.17 | 125.67 | 125.77 | 2158395.0 |
| 2015-06-29 13:00:00 | IWM | ETF | 125.77 | 125.77 | 125.41 | 125.47 | 3451595.0 |
| 2015-06-29 14:00:00 | IWM | ETF | 125.47 | 125.5 | 124.83 | 124.9 | 5665895.0 |
| 2015-06-29 15:00:00 | IWM | ETF | 124.9 | 124.95 | 124.11 | 124.31 | 11180005.0 |
| 2015-06-29 16:00:00 | IWM | ETF | 124.3 | 126.1923 | 124.207 | 124.59 | 5122179.0 |
| 2015-06-29 17:00:00 | IWM | ETF | 124.59 | 124.65 | 124.28 | 124.55 | 79048.0 |
| 2015-06-29 18:00:00 | IWM | ETF | 124.28 | 124.84 | 124.28 | 124.84 | 54649.0 |
| 2015-06-29 19:00:00 | IWM | ETF | 124.52 | 124.52 | 124.51 | 124.51 | 270.0 |
| 2015-06-29 04:00:00 | DIA | ETF | 177.4 | 177.4 | 177.4 | 177.4 | 100.0 |
| 2015-06-29 06:00:00 | DIA | ETF | 177.4 | 177.4 | 177.4 | 177.4 | 100.0 |
> showing 50 of 8,364 rows — these rows as CSV