PREVIEW / etf_1hour / 2015-10-20
file: by_date/etf_1hour/2015/2015-10-20.parquet size: 232 KB rows: 7,423
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-20 04:00:00 | SPY | ETF | 203.45 | 203.45 | 202.66 | 202.68 | 16166.0 |
| 2015-10-20 05:00:00 | SPY | ETF | 202.63 | 202.8 | 202.57 | 202.69 | 11962.0 |
| 2015-10-20 06:00:00 | SPY | ETF | 202.7 | 202.82 | 202.62 | 202.78 | 18425.0 |
| 2015-10-20 07:00:00 | SPY | ETF | 202.73 | 203.03 | 202.73 | 203.01 | 70000.0 |
| 2015-10-20 08:00:00 | SPY | ETF | 203.02 | 203.2 | 202.73 | 202.99 | 520663.0 |
| 2015-10-20 09:00:00 | SPY | ETF | 202.99 | 203.28 | 202.64 | 203.2589 | 8274938.0 |
| 2015-10-20 10:00:00 | SPY | ETF | 203.26 | 203.84 | 203.13 | 203.7 | 14031225.0 |
| 2015-10-20 11:00:00 | SPY | ETF | 203.7 | 203.71 | 202.91 | 203.09 | 9258097.0 |
| 2015-10-20 12:00:00 | SPY | ETF | 203.085 | 203.24 | 202.75 | 203.05 | 7206849.0 |
| 2015-10-20 13:00:00 | SPY | ETF | 203.05 | 203.17 | 202.5471 | 202.75 | 6142985.0 |
| 2015-10-20 14:00:00 | SPY | ETF | 202.75 | 203.22 | 202.6 | 203.22 | 7891386.0 |
| 2015-10-20 15:00:00 | SPY | ETF | 203.22 | 203.36 | 202.86 | 203.07 | 17289130.0 |
| 2015-10-20 16:00:00 | SPY | ETF | 203.09 | 203.12 | 202.62 | 202.67 | 7011577.0 |
| 2015-10-20 17:00:00 | SPY | ETF | 202.7 | 202.75 | 202.65 | 202.65 | 79379.0 |
| 2015-10-20 18:00:00 | SPY | ETF | 202.65 | 202.65 | 202.3 | 202.59 | 169795.0 |
| 2015-10-20 19:00:00 | SPY | ETF | 202.62 | 202.69 | 202.54 | 202.55 | 30554.0 |
| 2015-10-20 04:00:00 | QQQ | ETF | 108.66 | 108.66 | 108.5 | 108.57 | 6613.0 |
| 2015-10-20 05:00:00 | QQQ | ETF | 108.42 | 108.42 | 108.42 | 108.42 | 6250.0 |
| 2015-10-20 06:00:00 | QQQ | ETF | 108.46 | 108.51 | 108.44 | 108.5 | 7243.0 |
| 2015-10-20 07:00:00 | QQQ | ETF | 108.53 | 108.63 | 108.53 | 108.62 | 5118.0 |
| 2015-10-20 08:00:00 | QQQ | ETF | 108.61 | 108.73 | 108.53 | 108.65 | 51162.0 |
| 2015-10-20 09:00:00 | QQQ | ETF | 108.65 | 108.72 | 108.27 | 108.55 | 2734471.0 |
| 2015-10-20 10:00:00 | QQQ | ETF | 108.57 | 108.78 | 108.5 | 108.64 | 3247802.0 |
| 2015-10-20 11:00:00 | QQQ | ETF | 108.64 | 108.64 | 108.21 | 108.34 | 3054626.0 |
| 2015-10-20 12:00:00 | QQQ | ETF | 108.33 | 108.45 | 108.0311 | 108.36 | 2658110.0 |
| 2015-10-20 13:00:00 | QQQ | ETF | 108.35 | 108.35 | 107.81 | 107.97 | 2286415.0 |
| 2015-10-20 14:00:00 | QQQ | ETF | 107.97 | 108.23 | 107.85 | 108.23 | 2170733.0 |
| 2015-10-20 15:00:00 | QQQ | ETF | 108.23 | 108.31 | 108.01 | 108.19 | 3132983.0 |
| 2015-10-20 16:00:00 | QQQ | ETF | 108.2 | 108.22 | 108.02 | 108.03 | 601638.0 |
| 2015-10-20 17:00:00 | QQQ | ETF | 108.02 | 108.02 | 108.02 | 108.02 | 196.0 |
| 2015-10-20 18:00:00 | QQQ | ETF | 108.01 | 108.01 | 107.87 | 108.0 | 57237.0 |
| 2015-10-20 19:00:00 | QQQ | ETF | 108.02 | 108.07 | 107.99 | 107.99 | 8000.0 |
| 2015-10-20 07:00:00 | IWM | ETF | 115.46 | 115.55 | 115.46 | 115.55 | 1100.0 |
| 2015-10-20 08:00:00 | IWM | ETF | 115.46 | 115.71 | 115.46 | 115.53 | 37999.0 |
| 2015-10-20 09:00:00 | IWM | ETF | 115.56 | 116.0 | 115.32 | 115.97 | 1602562.0 |
| 2015-10-20 10:00:00 | IWM | ETF | 115.97 | 116.3 | 115.8501 | 116.0 | 3983919.0 |
| 2015-10-20 11:00:00 | IWM | ETF | 116.0 | 116.015 | 115.4 | 115.55 | 1969120.0 |
| 2015-10-20 12:00:00 | IWM | ETF | 115.54 | 115.66 | 115.03 | 115.37 | 1920089.0 |
| 2015-10-20 13:00:00 | IWM | ETF | 115.36 | 115.51 | 115.06 | 115.24 | 1654577.0 |
| 2015-10-20 14:00:00 | IWM | ETF | 115.23 | 115.72 | 115.13 | 115.69 | 2071598.0 |
| 2015-10-20 15:00:00 | IWM | ETF | 115.7 | 115.75 | 115.4 | 115.51 | 2946272.0 |
| 2015-10-20 16:00:00 | IWM | ETF | 115.51 | 116.0291 | 115.18 | 115.2 | 1068491.0 |
| 2015-10-20 17:00:00 | IWM | ETF | 115.18 | 115.22 | 115.17 | 115.17 | 17707.0 |
| 2015-10-20 18:00:00 | IWM | ETF | 115.16 | 115.16 | 115.1 | 115.1 | 3050.0 |
| 2015-10-20 19:00:00 | IWM | ETF | 115.29 | 115.29 | 115.25 | 115.25 | 1050.0 |
| 2015-10-20 07:00:00 | DIA | ETF | 171.6 | 171.6 | 171.6 | 171.6 | 500.0 |
| 2015-10-20 08:00:00 | DIA | ETF | 171.79 | 171.88 | 171.72 | 171.79 | 7767.0 |
| 2015-10-20 09:00:00 | DIA | ETF | 171.59 | 171.75 | 171.24 | 171.68 | 724129.0 |
| 2015-10-20 10:00:00 | DIA | ETF | 171.68 | 172.39 | 171.57 | 172.31 | 742730.0 |
| 2015-10-20 11:00:00 | DIA | ETF | 172.32 | 172.35 | 171.84 | 171.97 | 734737.0 |
> showing 50 of 7,423 rows — these rows as CSV