PREVIEW / etf_1hour / 2015-07-02
file: by_date/etf_1hour/2015/2015-07-02.parquet size: 238 KB rows: 7,669
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-07-02 04:00:00 | SPY | ETF | 207.88 | 208.13 | 207.39 | 208.1 | 16900.0 |
| 2015-07-02 05:00:00 | SPY | ETF | 207.96 | 207.99 | 207.76 | 207.98 | 26110.0 |
| 2015-07-02 06:00:00 | SPY | ETF | 207.91 | 208.09 | 207.87 | 208.03 | 51862.0 |
| 2015-07-02 07:00:00 | SPY | ETF | 208.03 | 208.11 | 207.85 | 208.02 | 139417.0 |
| 2015-07-02 08:00:00 | SPY | ETF | 208.01 | 208.48 | 206.03 | 208.24 | 1516378.0 |
| 2015-07-02 09:00:00 | SPY | ETF | 208.22 | 208.27 | 207.5 | 207.85 | 12218994.0 |
| 2015-07-02 10:00:00 | SPY | ETF | 207.86 | 208.01 | 207.48 | 207.675 | 11213147.0 |
| 2015-07-02 11:00:00 | SPY | ETF | 207.67 | 207.7 | 207.1 | 207.23 | 11228462.0 |
| 2015-07-02 12:00:00 | SPY | ETF | 207.23 | 207.33 | 206.89 | 207.0799 | 9795189.0 |
| 2015-07-02 13:00:00 | SPY | ETF | 207.07 | 207.17 | 206.83 | 206.955 | 8266257.0 |
| 2015-07-02 14:00:00 | SPY | ETF | 206.955 | 207.28 | 206.81 | 207.2014 | 8070719.0 |
| 2015-07-02 15:00:00 | SPY | ETF | 207.21 | 207.64 | 207.0601 | 207.3 | 24907239.0 |
| 2015-07-02 16:00:00 | SPY | ETF | 207.29 | 207.975 | 207.24 | 207.47 | 10319639.0 |
| 2015-07-02 17:00:00 | SPY | ETF | 207.48 | 207.55 | 207.45 | 207.52 | 62370.0 |
| 2015-07-02 18:00:00 | SPY | ETF | 207.49 | 207.55 | 207.45 | 207.46 | 61693.0 |
| 2015-07-02 19:00:00 | SPY | ETF | 207.47 | 207.47 | 207.37 | 207.45 | 30951.0 |
| 2015-07-02 04:00:00 | QQQ | ETF | 108.08 | 108.13 | 108.08 | 108.12 | 597.0 |
| 2015-07-02 06:00:00 | QQQ | ETF | 108.22 | 108.22 | 108.16 | 108.16 | 4800.0 |
| 2015-07-02 07:00:00 | QQQ | ETF | 108.18 | 108.19 | 108.08 | 108.16 | 61708.0 |
| 2015-07-02 08:00:00 | QQQ | ETF | 108.16 | 108.42 | 108.13 | 108.31 | 189119.0 |
| 2015-07-02 09:00:00 | QQQ | ETF | 108.32 | 108.32 | 108.04 | 108.06 | 2966564.0 |
| 2015-07-02 10:00:00 | QQQ | ETF | 108.06 | 108.13 | 107.84 | 107.9801 | 2384467.0 |
| 2015-07-02 11:00:00 | QQQ | ETF | 107.99 | 107.99 | 107.725 | 107.79 | 1882254.0 |
| 2015-07-02 12:00:00 | QQQ | ETF | 107.8 | 107.83 | 107.62 | 107.76 | 1280115.0 |
| 2015-07-02 13:00:00 | QQQ | ETF | 107.76 | 107.83 | 107.6301 | 107.7461 | 1368881.0 |
| 2015-07-02 14:00:00 | QQQ | ETF | 107.74 | 107.935 | 107.69 | 107.9 | 1160138.0 |
| 2015-07-02 15:00:00 | QQQ | ETF | 107.91 | 108.16 | 107.8 | 107.97 | 3214328.0 |
| 2015-07-02 16:00:00 | QQQ | ETF | 107.93 | 108.13 | 107.93 | 108.1 | 2072603.0 |
| 2015-07-02 17:00:00 | QQQ | ETF | 108.12 | 108.12 | 108.0 | 108.1 | 25350.0 |
| 2015-07-02 18:00:00 | QQQ | ETF | 108.08 | 108.13 | 108.06 | 108.1 | 21735.0 |
| 2015-07-02 19:00:00 | QQQ | ETF | 108.09 | 108.11 | 108.05 | 108.11 | 5292.0 |
| 2015-07-02 07:00:00 | IWM | ETF | 124.8 | 124.83 | 124.77 | 124.77 | 3600.0 |
| 2015-07-02 08:00:00 | IWM | ETF | 124.76 | 125.02 | 124.69 | 124.88 | 173460.0 |
| 2015-07-02 09:00:00 | IWM | ETF | 124.88 | 124.96 | 124.28 | 124.4225 | 2628547.0 |
| 2015-07-02 10:00:00 | IWM | ETF | 124.43 | 124.6 | 124.03 | 124.22 | 3616479.0 |
| 2015-07-02 11:00:00 | IWM | ETF | 124.22 | 124.23 | 123.67 | 123.82 | 3002582.0 |
| 2015-07-02 12:00:00 | IWM | ETF | 123.83 | 123.88 | 123.57 | 123.6199 | 1893376.0 |
| 2015-07-02 13:00:00 | IWM | ETF | 123.62 | 123.68 | 123.37 | 123.54 | 2203156.0 |
| 2015-07-02 14:00:00 | IWM | ETF | 123.55 | 123.94 | 123.45 | 123.895 | 2202730.0 |
| 2015-07-02 15:00:00 | IWM | ETF | 123.8968 | 124.11 | 123.72 | 123.82 | 4756185.0 |
| 2015-07-02 16:00:00 | IWM | ETF | 123.81 | 124.0 | 123.5013 | 123.96 | 3883724.0 |
| 2015-07-02 17:00:00 | IWM | ETF | 123.99 | 124.0 | 123.97 | 123.99 | 12227.0 |
| 2015-07-02 18:00:00 | IWM | ETF | 124.02 | 124.02 | 124.02 | 124.02 | 200.0 |
| 2015-07-02 08:00:00 | DIA | ETF | 177.7 | 178.0 | 177.7 | 177.94 | 4895.0 |
| 2015-07-02 09:00:00 | DIA | ETF | 177.84 | 178.05 | 177.66 | 177.69 | 1165674.0 |
| 2015-07-02 10:00:00 | DIA | ETF | 177.7 | 177.79 | 177.31 | 177.48 | 627777.0 |
| 2015-07-02 11:00:00 | DIA | ETF | 177.48 | 177.49 | 176.99 | 177.11 | 489559.0 |
| 2015-07-02 12:00:00 | DIA | ETF | 177.11 | 177.2 | 176.73 | 176.89 | 368800.0 |
| 2015-07-02 13:00:00 | DIA | ETF | 176.89 | 176.9599 | 176.75 | 176.79 | 320205.0 |
| 2015-07-02 14:00:00 | DIA | ETF | 176.79 | 177.0 | 176.65 | 176.95 | 233409.0 |
> showing 50 of 7,669 rows — these rows as CSV