PREVIEW / etf_1hour / 2015-07-20
file: by_date/etf_1hour/2015/2015-07-20.parquet size: 243 KB rows: 7,811
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-20 04:00:00 | SPY | ETF | 212.64 | 212.81 | 212.59 | 212.75 | 70171.0 |
| 2015-07-20 05:00:00 | SPY | ETF | 212.74 | 212.77 | 212.64 | 212.71 | 6409.0 |
| 2015-07-20 06:00:00 | SPY | ETF | 212.71 | 212.8 | 212.66 | 212.68 | 40629.0 |
| 2015-07-20 07:00:00 | SPY | ETF | 212.65 | 212.75 | 212.62 | 212.72 | 91047.0 |
| 2015-07-20 08:00:00 | SPY | ETF | 212.66 | 212.75 | 212.58 | 212.6 | 334038.0 |
| 2015-07-20 09:00:00 | SPY | ETF | 212.6 | 212.8 | 212.27 | 212.38 | 11748979.0 |
| 2015-07-20 10:00:00 | SPY | ETF | 212.38 | 212.69 | 212.21 | 212.64 | 8625319.0 |
| 2015-07-20 11:00:00 | SPY | ETF | 212.64 | 212.895 | 212.6201 | 212.81 | 6992956.0 |
| 2015-07-20 12:00:00 | SPY | ETF | 212.8 | 212.99 | 212.76 | 212.92 | 4434941.0 |
| 2015-07-20 13:00:00 | SPY | ETF | 212.92 | 213.05 | 212.7801 | 212.82 | 5920005.0 |
| 2015-07-20 14:00:00 | SPY | ETF | 212.82 | 213.12 | 212.81 | 212.97 | 8982119.0 |
| 2015-07-20 15:00:00 | SPY | ETF | 212.97 | 213.18 | 212.52 | 212.61 | 16000766.0 |
| 2015-07-20 16:00:00 | SPY | ETF | 212.61 | 212.82 | 212.2722 | 212.73 | 6529028.0 |
| 2015-07-20 17:00:00 | SPY | ETF | 212.73 | 212.82 | 212.59 | 212.72 | 135096.0 |
| 2015-07-20 18:00:00 | SPY | ETF | 212.69 | 212.69 | 212.55 | 212.64 | 119723.0 |
| 2015-07-20 19:00:00 | SPY | ETF | 212.63 | 212.69 | 212.62 | 212.69 | 25117.0 |
| 2015-07-20 04:00:00 | QQQ | ETF | 113.56 | 113.7 | 113.56 | 113.58 | 81200.0 |
| 2015-07-20 07:00:00 | QQQ | ETF | 113.7 | 113.79 | 113.5 | 113.77 | 27040.0 |
| 2015-07-20 08:00:00 | QQQ | ETF | 113.79 | 113.85 | 113.76 | 113.8 | 134591.0 |
| 2015-07-20 09:00:00 | QQQ | ETF | 113.83 | 114.01 | 113.52 | 113.701 | 3455586.0 |
| 2015-07-20 10:00:00 | QQQ | ETF | 113.71 | 113.93 | 113.48 | 113.9 | 3094899.0 |
| 2015-07-20 11:00:00 | QQQ | ETF | 113.9 | 114.049 | 113.87 | 113.97 | 3521481.0 |
| 2015-07-20 12:00:00 | QQQ | ETF | 113.97 | 114.11 | 113.9 | 114.08 | 2690520.0 |
| 2015-07-20 13:00:00 | QQQ | ETF | 114.08 | 114.225 | 114.05 | 114.08 | 2318542.0 |
| 2015-07-20 14:00:00 | QQQ | ETF | 114.08 | 114.34 | 114.05 | 114.3 | 2213859.0 |
| 2015-07-20 15:00:00 | QQQ | ETF | 114.3 | 114.39 | 113.92 | 113.98 | 4864755.0 |
| 2015-07-20 16:00:00 | QQQ | ETF | 113.98 | 114.06 | 113.4 | 114.01 | 1079133.0 |
| 2015-07-20 17:00:00 | QQQ | ETF | 114.01 | 114.08 | 113.98 | 114.04 | 26119.0 |
| 2015-07-20 18:00:00 | QQQ | ETF | 114.05 | 114.05 | 113.95 | 113.95 | 6955.0 |
| 2015-07-20 19:00:00 | QQQ | ETF | 113.99 | 114.05 | 113.98 | 114.03 | 7630.0 |
| 2015-07-20 04:00:00 | IWM | ETF | 125.9 | 125.9 | 125.9 | 125.9 | 800.0 |
| 2015-07-20 07:00:00 | IWM | ETF | 125.96 | 125.96 | 125.96 | 125.96 | 1000.0 |
| 2015-07-20 08:00:00 | IWM | ETF | 125.97 | 125.99 | 125.84 | 125.86 | 55216.0 |
| 2015-07-20 09:00:00 | IWM | ETF | 125.84 | 125.95 | 125.18 | 125.34 | 2489068.0 |
| 2015-07-20 10:00:00 | IWM | ETF | 125.335 | 125.36 | 124.76 | 125.29 | 4930695.0 |
| 2015-07-20 11:00:00 | IWM | ETF | 125.3 | 125.7 | 125.055 | 125.15 | 2948268.0 |
| 2015-07-20 12:00:00 | IWM | ETF | 125.14 | 125.32 | 125.125 | 125.225 | 960074.0 |
| 2015-07-20 13:00:00 | IWM | ETF | 125.23 | 125.31 | 124.965 | 125.13 | 1785264.0 |
| 2015-07-20 14:00:00 | IWM | ETF | 125.12 | 125.31 | 125.01 | 125.065 | 1417595.0 |
| 2015-07-20 15:00:00 | IWM | ETF | 125.065 | 125.19 | 124.78 | 125.07 | 4210452.0 |
| 2015-07-20 16:00:00 | IWM | ETF | 125.08 | 125.24 | 125.02 | 125.15 | 1379695.0 |
| 2015-07-20 17:00:00 | IWM | ETF | 125.08 | 125.16 | 125.08 | 125.14 | 9520.0 |
| 2015-07-20 18:00:00 | IWM | ETF | 125.06 | 125.06 | 125.03 | 125.03 | 3847.0 |
| 2015-07-20 19:00:00 | IWM | ETF | 124.9 | 124.9 | 124.9 | 124.9 | 400.0 |
| 2015-07-20 08:00:00 | DIA | ETF | 180.68 | 180.87 | 180.68 | 180.8 | 11650.0 |
| 2015-07-20 09:00:00 | DIA | ETF | 180.89 | 180.95 | 180.45 | 180.48 | 591282.0 |
| 2015-07-20 10:00:00 | DIA | ETF | 180.5 | 180.7501 | 180.36 | 180.72 | 525319.0 |
| 2015-07-20 11:00:00 | DIA | ETF | 180.73 | 180.99 | 180.69 | 180.87 | 297824.0 |
| 2015-07-20 12:00:00 | DIA | ETF | 180.87 | 181.0 | 180.84 | 180.89 | 172969.0 |
| 2015-07-20 13:00:00 | DIA | ETF | 180.92 | 181.02 | 180.82 | 180.83 | 269578.0 |
> showing 50 of 7,811 rows — these rows as CSV