PREVIEW / etf_1hour / 2015-10-16
file: by_date/etf_1hour/2015/2015-10-16.parquet size: 238 KB rows: 7,572
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-16 04:00:00 | SPY | ETF | 202.66 | 202.8 | 202.42 | 202.77 | 19428.0 |
| 2015-10-16 05:00:00 | SPY | ETF | 202.65 | 202.78 | 202.57 | 202.57 | 4976.0 |
| 2015-10-16 06:00:00 | SPY | ETF | 202.65 | 202.65 | 202.19 | 202.24 | 122575.0 |
| 2015-10-16 07:00:00 | SPY | ETF | 202.27 | 202.41 | 202.06 | 202.37 | 166670.0 |
| 2015-10-16 08:00:00 | SPY | ETF | 202.35 | 202.67 | 202.19 | 202.41 | 544743.0 |
| 2015-10-16 09:00:00 | SPY | ETF | 202.43 | 203.02 | 202.41 | 202.63 | 16897673.0 |
| 2015-10-16 10:00:00 | SPY | ETF | 202.64 | 202.86 | 202.23 | 202.528 | 16485740.0 |
| 2015-10-16 11:00:00 | SPY | ETF | 202.53 | 202.96 | 202.48 | 202.9421 | 7482967.0 |
| 2015-10-16 12:00:00 | SPY | ETF | 202.945 | 202.96 | 202.265 | 202.51 | 7178114.0 |
| 2015-10-16 13:00:00 | SPY | ETF | 202.51 | 202.6 | 202.07 | 202.1 | 9763027.0 |
| 2015-10-16 14:00:00 | SPY | ETF | 202.0963 | 202.88 | 201.92 | 202.74 | 11569994.0 |
| 2015-10-16 15:00:00 | SPY | ETF | 202.74 | 203.29 | 202.7 | 203.14 | 25219030.0 |
| 2015-10-16 16:00:00 | SPY | ETF | 203.15 | 203.35 | 202.7059 | 203.34 | 10646592.0 |
| 2015-10-16 17:00:00 | SPY | ETF | 203.34 | 203.44 | 203.29 | 203.36 | 624420.0 |
| 2015-10-16 18:00:00 | SPY | ETF | 203.35 | 203.38 | 203.25 | 203.36 | 48593.0 |
| 2015-10-16 19:00:00 | SPY | ETF | 203.36 | 203.36 | 203.31 | 203.36 | 22528.0 |
| 2015-10-16 04:00:00 | QQQ | ETF | 107.77 | 108.06 | 107.77 | 108.03 | 13635.0 |
| 2015-10-16 05:00:00 | QQQ | ETF | 108.02 | 108.04 | 108.01 | 108.04 | 2000.0 |
| 2015-10-16 06:00:00 | QQQ | ETF | 108.02 | 108.02 | 107.75 | 107.78 | 4900.0 |
| 2015-10-16 07:00:00 | QQQ | ETF | 107.74 | 107.8 | 107.68 | 107.8 | 11777.0 |
| 2015-10-16 08:00:00 | QQQ | ETF | 107.78 | 107.82 | 107.68 | 107.75 | 104857.0 |
| 2015-10-16 09:00:00 | QQQ | ETF | 107.74 | 107.95 | 107.58 | 107.71 | 4163039.0 |
| 2015-10-16 10:00:00 | QQQ | ETF | 107.71 | 107.96 | 107.55 | 107.88 | 3302962.0 |
| 2015-10-16 11:00:00 | QQQ | ETF | 107.88 | 108.0483 | 107.8001 | 108.01 | 2135938.0 |
| 2015-10-16 12:00:00 | QQQ | ETF | 108.01 | 108.019 | 107.54 | 107.74 | 1499034.0 |
| 2015-10-16 13:00:00 | QQQ | ETF | 107.73 | 107.8 | 107.49 | 107.51 | 1611060.0 |
| 2015-10-16 14:00:00 | QQQ | ETF | 107.52 | 107.91 | 107.3794 | 107.75 | 2493014.0 |
| 2015-10-16 15:00:00 | QQQ | ETF | 107.74 | 108.18 | 107.74 | 108.14 | 5822220.0 |
| 2015-10-16 16:00:00 | QQQ | ETF | 108.14 | 108.4 | 108.1 | 108.4 | 1342645.0 |
| 2015-10-16 17:00:00 | QQQ | ETF | 108.39 | 108.39 | 108.33 | 108.37 | 446131.0 |
| 2015-10-16 18:00:00 | QQQ | ETF | 108.36 | 108.38 | 108.33 | 108.34 | 6015.0 |
| 2015-10-16 19:00:00 | QQQ | ETF | 108.34 | 108.36 | 108.34 | 108.36 | 9478.0 |
| 2015-10-16 04:00:00 | IWM | ETF | 115.72 | 115.87 | 115.53 | 115.87 | 44352.0 |
| 2015-10-16 05:00:00 | IWM | ETF | 115.74 | 115.76 | 115.73 | 115.73 | 700.0 |
| 2015-10-16 06:00:00 | IWM | ETF | 115.5 | 115.59 | 115.49 | 115.49 | 11000.0 |
| 2015-10-16 07:00:00 | IWM | ETF | 115.56 | 115.59 | 115.43 | 115.59 | 36200.0 |
| 2015-10-16 08:00:00 | IWM | ETF | 115.53 | 115.63 | 115.5 | 115.55 | 115751.0 |
| 2015-10-16 09:00:00 | IWM | ETF | 115.55 | 115.8 | 115.17 | 115.33 | 3185170.0 |
| 2015-10-16 10:00:00 | IWM | ETF | 115.33 | 115.52 | 115.02 | 115.41 | 3874395.0 |
| 2015-10-16 11:00:00 | IWM | ETF | 115.415 | 115.56 | 115.11 | 115.52 | 2068503.0 |
| 2015-10-16 12:00:00 | IWM | ETF | 115.52 | 115.55 | 114.84 | 115.02 | 2171452.0 |
| 2015-10-16 13:00:00 | IWM | ETF | 115.01 | 115.04 | 114.54 | 114.57 | 2254415.0 |
| 2015-10-16 14:00:00 | IWM | ETF | 114.57 | 115.515 | 114.43 | 115.33 | 4817585.0 |
| 2015-10-16 15:00:00 | IWM | ETF | 115.33 | 115.57 | 115.21 | 115.41 | 5021888.0 |
| 2015-10-16 16:00:00 | IWM | ETF | 115.41 | 115.5 | 115.1 | 115.19 | 2387502.0 |
| 2015-10-16 17:00:00 | IWM | ETF | 115.18 | 115.23 | 115.13 | 115.23 | 194807.0 |
| 2015-10-16 18:00:00 | IWM | ETF | 115.22 | 115.23 | 115.22 | 115.23 | 400.0 |
| 2015-10-16 19:00:00 | IWM | ETF | 115.16 | 115.19 | 115.16 | 115.17 | 1247.0 |
| 2015-10-16 06:00:00 | DIA | ETF | 171.24 | 171.24 | 171.1 | 171.13 | 7193.0 |
| 2015-10-16 07:00:00 | DIA | ETF | 171.05 | 171.08 | 171.0 | 171.08 | 5700.0 |
> showing 50 of 7,572 rows — these rows as CSV