PREVIEW / etf_1hour / 2015-05-20
file: by_date/etf_1hour/2015/2015-05-20.parquet size: 237 KB rows: 7,561
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-20 04:00:00 | SPY | ETF | 212.9 | 212.9 | 212.76 | 212.77 | 1100.0 |
| 2015-05-20 05:00:00 | SPY | ETF | 212.81 | 212.93 | 212.81 | 212.82 | 24916.0 |
| 2015-05-20 06:00:00 | SPY | ETF | 212.85 | 213.12 | 212.85 | 213.09 | 24530.0 |
| 2015-05-20 07:00:00 | SPY | ETF | 213.02 | 213.14 | 212.9 | 212.94 | 159060.0 |
| 2015-05-20 08:00:00 | SPY | ETF | 212.94 | 213.2 | 212.85 | 213.11 | 518413.0 |
| 2015-05-20 09:00:00 | SPY | ETF | 213.11 | 213.24 | 212.504 | 212.62 | 8973122.0 |
| 2015-05-20 10:00:00 | SPY | ETF | 212.62 | 213.19 | 212.53 | 213.02 | 9379833.0 |
| 2015-05-20 11:00:00 | SPY | ETF | 213.03 | 213.13 | 212.68 | 212.813 | 8983162.0 |
| 2015-05-20 12:00:00 | SPY | ETF | 212.82 | 213.1 | 212.78 | 212.93 | 4942969.0 |
| 2015-05-20 13:00:00 | SPY | ETF | 212.925 | 212.95 | 212.74 | 212.87 | 2883964.0 |
| 2015-05-20 14:00:00 | SPY | ETF | 212.87 | 213.78 | 212.84 | 213.43 | 16758982.0 |
| 2015-05-20 15:00:00 | SPY | ETF | 213.43 | 213.48 | 212.72 | 212.86 | 18142371.0 |
| 2015-05-20 16:00:00 | SPY | ETF | 212.86 | 212.93 | 212.7 | 212.74 | 4226461.0 |
| 2015-05-20 17:00:00 | SPY | ETF | 212.73 | 212.88 | 212.59 | 212.63 | 1137238.0 |
| 2015-05-20 18:00:00 | SPY | ETF | 212.63 | 212.63 | 212.17 | 212.37 | 253708.0 |
| 2015-05-20 19:00:00 | SPY | ETF | 212.37 | 212.39 | 212.27 | 212.33 | 31783.0 |
| 2015-05-20 06:00:00 | QQQ | ETF | 110.0 | 110.05 | 110.0 | 110.04 | 21100.0 |
| 2015-05-20 07:00:00 | QQQ | ETF | 110.01 | 110.03 | 109.92 | 109.93 | 25626.0 |
| 2015-05-20 08:00:00 | QQQ | ETF | 110.02 | 110.07 | 109.92 | 110.01 | 37038.0 |
| 2015-05-20 09:00:00 | QQQ | ETF | 110.03 | 110.07 | 109.425 | 109.54 | 2587625.0 |
| 2015-05-20 10:00:00 | QQQ | ETF | 109.53 | 110.01 | 109.44 | 109.91 | 2207807.0 |
| 2015-05-20 11:00:00 | QQQ | ETF | 109.9 | 109.97 | 109.77 | 109.87 | 1184318.0 |
| 2015-05-20 12:00:00 | QQQ | ETF | 109.87 | 110.05 | 109.86 | 109.96 | 862246.0 |
| 2015-05-20 13:00:00 | QQQ | ETF | 109.965 | 110.02 | 109.88 | 110.0 | 780991.0 |
| 2015-05-20 14:00:00 | QQQ | ETF | 109.98 | 110.67 | 109.98 | 110.39 | 4722140.0 |
| 2015-05-20 15:00:00 | QQQ | ETF | 110.4 | 110.43 | 109.82 | 110.0 | 3998164.0 |
| 2015-05-20 16:00:00 | QQQ | ETF | 110.01 | 110.06 | 109.9 | 109.92 | 295920.0 |
| 2015-05-20 17:00:00 | QQQ | ETF | 109.9 | 110.01 | 109.82 | 109.831 | 969790.0 |
| 2015-05-20 18:00:00 | QQQ | ETF | 109.83 | 109.83 | 109.56 | 109.61 | 25646.0 |
| 2015-05-20 19:00:00 | QQQ | ETF | 109.67 | 109.68 | 109.61 | 109.62 | 29091.0 |
| 2015-05-20 04:00:00 | IWM | ETF | 125.05 | 125.05 | 125.05 | 125.05 | 366.0 |
| 2015-05-20 07:00:00 | IWM | ETF | 125.16 | 125.16 | 125.02 | 125.06 | 9400.0 |
| 2015-05-20 08:00:00 | IWM | ETF | 125.031 | 125.22 | 125.031 | 125.2 | 37724.0 |
| 2015-05-20 09:00:00 | IWM | ETF | 125.19 | 125.23 | 124.385 | 124.54 | 2726887.0 |
| 2015-05-20 10:00:00 | IWM | ETF | 124.55 | 124.975 | 124.34 | 124.84 | 2986863.0 |
| 2015-05-20 11:00:00 | IWM | ETF | 124.842 | 124.91 | 124.66 | 124.78 | 1682359.0 |
| 2015-05-20 12:00:00 | IWM | ETF | 124.79 | 125.02 | 124.75 | 124.92 | 1118404.0 |
| 2015-05-20 13:00:00 | IWM | ETF | 124.9125 | 124.95 | 124.73 | 124.87 | 1620530.0 |
| 2015-05-20 14:00:00 | IWM | ETF | 124.87 | 125.4625 | 124.865 | 125.195 | 3623573.0 |
| 2015-05-20 15:00:00 | IWM | ETF | 125.2099 | 125.3225 | 124.865 | 125.1 | 2913995.0 |
| 2015-05-20 16:00:00 | IWM | ETF | 125.1 | 125.15 | 124.99 | 124.99 | 576512.0 |
| 2015-05-20 17:00:00 | IWM | ETF | 125.0 | 125.11 | 124.9 | 124.94 | 873959.0 |
| 2015-05-20 18:00:00 | IWM | ETF | 124.91 | 124.95 | 124.76 | 124.95 | 2000.0 |
| 2015-05-20 19:00:00 | IWM | ETF | 124.9 | 124.9 | 124.9 | 124.9 | 2000.0 |
| 2015-05-20 08:00:00 | DIA | ETF | 182.95 | 182.95 | 182.93 | 182.93 | 500.0 |
| 2015-05-20 09:00:00 | DIA | ETF | 183.17 | 183.24 | 182.58 | 182.68 | 542359.0 |
| 2015-05-20 10:00:00 | DIA | ETF | 182.66 | 183.19 | 182.62 | 183.01 | 455122.0 |
| 2015-05-20 11:00:00 | DIA | ETF | 183.01 | 183.11 | 182.66 | 182.77 | 312301.0 |
| 2015-05-20 12:00:00 | DIA | ETF | 182.76 | 182.99 | 182.74 | 182.8 | 207686.0 |
| 2015-05-20 13:00:00 | DIA | ETF | 182.81 | 182.83 | 182.58 | 182.64 | 195526.0 |
> showing 50 of 7,561 rows — these rows as CSV