PREVIEW / etf_1hour / 2015-05-22
file: by_date/etf_1hour/2015/2015-05-22.parquet size: 233 KB rows: 7,449
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-05-22 04:00:00 | SPY | ETF | 213.43 | 213.43 | 213.43 | 213.43 | 200.0 |
| 2015-05-22 05:00:00 | SPY | ETF | 213.42 | 213.42 | 213.26 | 213.32 | 7200.0 |
| 2015-05-22 06:00:00 | SPY | ETF | 213.31 | 213.39 | 213.22 | 213.39 | 10558.0 |
| 2015-05-22 07:00:00 | SPY | ETF | 213.41 | 213.51 | 213.33 | 213.51 | 181613.0 |
| 2015-05-22 08:00:00 | SPY | ETF | 213.5 | 213.52 | 212.9 | 213.07 | 1210984.0 |
| 2015-05-22 09:00:00 | SPY | ETF | 213.07 | 213.34 | 212.91 | 213.23 | 7571001.0 |
| 2015-05-22 10:00:00 | SPY | ETF | 213.24 | 213.43 | 213.14 | 213.37 | 7379885.0 |
| 2015-05-22 11:00:00 | SPY | ETF | 213.37 | 213.4 | 212.92 | 213.16 | 6295798.0 |
| 2015-05-22 12:00:00 | SPY | ETF | 213.16 | 213.27 | 213.03 | 213.24 | 3125567.0 |
| 2015-05-22 13:00:00 | SPY | ETF | 213.22 | 213.54 | 213.07 | 213.33 | 6435844.0 |
| 2015-05-22 14:00:00 | SPY | ETF | 213.33 | 213.35 | 213.15 | 213.27 | 4825220.0 |
| 2015-05-22 15:00:00 | SPY | ETF | 213.27 | 213.44 | 212.92 | 212.97 | 13336828.0 |
| 2015-05-22 16:00:00 | SPY | ETF | 212.98 | 213.2915 | 212.85 | 213.01 | 6195993.0 |
| 2015-05-22 17:00:00 | SPY | ETF | 213.01 | 213.02 | 212.9 | 212.94 | 165310.0 |
| 2015-05-22 18:00:00 | SPY | ETF | 212.92 | 212.94 | 212.9 | 212.94 | 12435.0 |
| 2015-05-22 19:00:00 | SPY | ETF | 212.94 | 212.94 | 212.91 | 212.94 | 10551.0 |
| 2015-05-22 06:00:00 | QQQ | ETF | 110.56 | 110.6 | 110.56 | 110.6 | 700.0 |
| 2015-05-22 07:00:00 | QQQ | ETF | 110.64 | 110.65 | 110.58 | 110.62 | 20600.0 |
| 2015-05-22 08:00:00 | QQQ | ETF | 110.62 | 110.7 | 110.41 | 110.53 | 228788.0 |
| 2015-05-22 09:00:00 | QQQ | ETF | 110.51 | 110.76 | 110.38 | 110.65 | 2355804.0 |
| 2015-05-22 10:00:00 | QQQ | ETF | 110.66 | 110.81 | 110.62 | 110.765 | 1569132.0 |
| 2015-05-22 11:00:00 | QQQ | ETF | 110.765 | 110.79 | 110.48 | 110.6162 | 2007855.0 |
| 2015-05-22 12:00:00 | QQQ | ETF | 110.62 | 110.73 | 110.58 | 110.66 | 683877.0 |
| 2015-05-22 13:00:00 | QQQ | ETF | 110.66 | 110.87 | 110.59 | 110.76 | 1658685.0 |
| 2015-05-22 14:00:00 | QQQ | ETF | 110.76 | 110.76 | 110.603 | 110.69 | 758625.0 |
| 2015-05-22 15:00:00 | QQQ | ETF | 110.69 | 110.8 | 110.48 | 110.5 | 2707070.0 |
| 2015-05-22 16:00:00 | QQQ | ETF | 110.51 | 110.55 | 110.41 | 110.5 | 507962.0 |
| 2015-05-22 17:00:00 | QQQ | ETF | 110.5 | 110.58 | 110.5 | 110.58 | 2167.0 |
| 2015-05-22 18:00:00 | QQQ | ETF | 110.56 | 110.56 | 110.51 | 110.56 | 1265.0 |
| 2015-05-22 19:00:00 | QQQ | ETF | 110.47 | 110.54 | 110.47 | 110.54 | 1000.0 |
| 2015-05-22 07:00:00 | IWM | ETF | 124.9 | 124.92 | 124.9 | 124.92 | 4300.0 |
| 2015-05-22 08:00:00 | IWM | ETF | 124.93 | 124.97 | 124.67 | 124.77 | 135320.0 |
| 2015-05-22 09:00:00 | IWM | ETF | 124.77 | 125.1 | 124.67 | 125.06 | 1266432.0 |
| 2015-05-22 10:00:00 | IWM | ETF | 125.065 | 125.24 | 124.76 | 124.99 | 2151705.0 |
| 2015-05-22 11:00:00 | IWM | ETF | 124.985 | 125.04 | 124.0 | 124.41 | 4412844.0 |
| 2015-05-22 12:00:00 | IWM | ETF | 124.41 | 124.75 | 124.36 | 124.57 | 2305069.0 |
| 2015-05-22 13:00:00 | IWM | ETF | 124.56 | 124.81 | 124.46 | 124.525 | 2525579.0 |
| 2015-05-22 14:00:00 | IWM | ETF | 124.525 | 124.68 | 124.29 | 124.54 | 1941489.0 |
| 2015-05-22 15:00:00 | IWM | ETF | 124.54 | 124.75 | 124.43 | 124.44 | 3562811.0 |
| 2015-05-22 16:00:00 | IWM | ETF | 124.44 | 124.46 | 124.34 | 124.44 | 980466.0 |
| 2015-05-22 18:00:00 | IWM | ETF | 124.32 | 124.43 | 124.26 | 124.43 | 742.0 |
| 2015-05-22 19:00:00 | IWM | ETF | 124.4 | 124.4 | 124.4 | 124.4 | 250.0 |
| 2015-05-22 08:00:00 | DIA | ETF | 182.45 | 182.53 | 182.44 | 182.53 | 2734.0 |
| 2015-05-22 09:00:00 | DIA | ETF | 182.44 | 182.74 | 182.4 | 182.48 | 310613.0 |
| 2015-05-22 10:00:00 | DIA | ETF | 182.5 | 182.67 | 182.45 | 182.52 | 286401.0 |
| 2015-05-22 11:00:00 | DIA | ETF | 182.53 | 182.53 | 182.04 | 182.25 | 528591.0 |
| 2015-05-22 12:00:00 | DIA | ETF | 182.26 | 182.45 | 182.175 | 182.41 | 153191.0 |
| 2015-05-22 13:00:00 | DIA | ETF | 182.4 | 182.73 | 182.29 | 182.55 | 425683.0 |
| 2015-05-22 14:00:00 | DIA | ETF | 182.55 | 182.56 | 182.41 | 182.54 | 170465.0 |
| 2015-05-22 15:00:00 | DIA | ETF | 182.53 | 182.66 | 182.23 | 182.25 | 357668.0 |
> showing 50 of 7,449 rows — these rows as CSV