PREVIEW / etf_1hour / 2017-05-22
file: by_date/etf_1hour/2017/2017-05-22.parquet size: 275 KB rows: 9,013
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 |
|---|---|---|---|---|---|---|---|
| 2017-05-22 04:00:00 | SPY | ETF | 238.37 | 238.57 | 238.32 | 238.47 | 17238.0 |
| 2017-05-22 05:00:00 | SPY | ETF | 238.49 | 238.51 | 238.17 | 238.32 | 25179.0 |
| 2017-05-22 06:00:00 | SPY | ETF | 238.32 | 238.52 | 238.26 | 238.5 | 85654.0 |
| 2017-05-22 07:00:00 | SPY | ETF | 238.47 | 238.66 | 238.45 | 238.63 | 212805.0 |
| 2017-05-22 08:00:00 | SPY | ETF | 238.63 | 238.73 | 238.5 | 238.67 | 336582.0 |
| 2017-05-22 09:00:00 | SPY | ETF | 238.68 | 239.36 | 238.3165 | 239.23 | 7971411.0 |
| 2017-05-22 10:00:00 | SPY | ETF | 239.24 | 239.38 | 238.82 | 238.955 | 7641570.0 |
| 2017-05-22 11:00:00 | SPY | ETF | 238.95 | 239.27 | 238.87 | 239.265 | 5426136.0 |
| 2017-05-22 12:00:00 | SPY | ETF | 239.265 | 239.62 | 239.235 | 239.3999 | 5305924.0 |
| 2017-05-22 13:00:00 | SPY | ETF | 239.3985 | 239.54 | 239.34 | 239.35 | 3323495.0 |
| 2017-05-22 14:00:00 | SPY | ETF | 239.35 | 239.54 | 239.27 | 239.4362 | 4150007.0 |
| 2017-05-22 15:00:00 | SPY | ETF | 239.435 | 239.71 | 239.41 | 239.53 | 11130048.0 |
| 2017-05-22 16:00:00 | SPY | ETF | 239.52 | 239.67 | 239.48 | 239.67 | 7291155.0 |
| 2017-05-22 17:00:00 | SPY | ETF | 239.65 | 239.67 | 239.6 | 239.62 | 197177.0 |
| 2017-05-22 18:00:00 | SPY | ETF | 239.62 | 239.73 | 239.27 | 239.29 | 424622.0 |
| 2017-05-22 19:00:00 | SPY | ETF | 239.32 | 239.32 | 239.03 | 239.06 | 288315.0 |
| 2017-05-22 04:00:00 | QQQ | ETF | 138.0 | 138.0 | 137.9 | 138.0 | 3151.0 |
| 2017-05-22 05:00:00 | QQQ | ETF | 138.0 | 138.03 | 137.79 | 137.82 | 21451.0 |
| 2017-05-22 06:00:00 | QQQ | ETF | 137.94 | 137.97 | 137.85 | 137.97 | 2067.0 |
| 2017-05-22 07:00:00 | QQQ | ETF | 137.95 | 138.03 | 137.95 | 137.99 | 7800.0 |
| 2017-05-22 08:00:00 | QQQ | ETF | 138.03 | 138.04 | 137.85 | 138.04 | 49080.0 |
| 2017-05-22 09:00:00 | QQQ | ETF | 138.04 | 138.63 | 138.04 | 138.58 | 2805457.0 |
| 2017-05-22 10:00:00 | QQQ | ETF | 138.575 | 138.67 | 138.48 | 138.56 | 3071690.0 |
| 2017-05-22 11:00:00 | QQQ | ETF | 138.55 | 138.82 | 138.515 | 138.8 | 1883757.0 |
| 2017-05-22 12:00:00 | QQQ | ETF | 138.8 | 138.95 | 138.7461 | 138.86 | 1731631.0 |
| 2017-05-22 13:00:00 | QQQ | ETF | 138.86 | 138.9 | 138.76 | 138.7929 | 1078012.0 |
| 2017-05-22 14:00:00 | QQQ | ETF | 138.79 | 138.955 | 138.72 | 138.92 | 2166252.0 |
| 2017-05-22 15:00:00 | QQQ | ETF | 138.918 | 139.075 | 138.89 | 139.01 | 3993022.0 |
| 2017-05-22 16:00:00 | QQQ | ETF | 139.01 | 139.08 | 138.902 | 139.08 | 991403.0 |
| 2017-05-22 17:00:00 | QQQ | ETF | 139.02 | 139.13 | 138.99 | 139.08 | 25393.0 |
| 2017-05-22 18:00:00 | QQQ | ETF | 139.08 | 139.11 | 138.81 | 138.81 | 39378.0 |
| 2017-05-22 19:00:00 | QQQ | ETF | 138.83 | 138.85 | 138.7 | 138.73 | 28541.0 |
| 2017-05-22 04:00:00 | IWM | ETF | 136.0 | 136.0 | 136.0 | 136.0 | 100.0 |
| 2017-05-22 05:00:00 | IWM | ETF | 135.9 | 135.9 | 135.68 | 135.68 | 3700.0 |
| 2017-05-22 06:00:00 | IWM | ETF | 135.98 | 135.98 | 135.75 | 135.96 | 5900.0 |
| 2017-05-22 07:00:00 | IWM | ETF | 135.94 | 136.07 | 135.94 | 136.03 | 17665.0 |
| 2017-05-22 08:00:00 | IWM | ETF | 136.04 | 136.2 | 135.95 | 136.15 | 58495.0 |
| 2017-05-22 09:00:00 | IWM | ETF | 136.17 | 136.81 | 136.15 | 136.55 | 2915428.0 |
| 2017-05-22 10:00:00 | IWM | ETF | 136.56 | 136.9 | 136.16 | 136.3 | 2342592.0 |
| 2017-05-22 11:00:00 | IWM | ETF | 136.28 | 136.69 | 136.22 | 136.6 | 1625177.0 |
| 2017-05-22 12:00:00 | IWM | ETF | 136.6 | 136.88 | 136.5 | 136.54 | 1612241.0 |
| 2017-05-22 13:00:00 | IWM | ETF | 136.5265 | 136.65 | 136.44 | 136.515 | 1722755.0 |
| 2017-05-22 14:00:00 | IWM | ETF | 136.51 | 136.78 | 136.44 | 136.65 | 1380294.0 |
| 2017-05-22 15:00:00 | IWM | ETF | 136.65 | 137.2 | 136.61 | 136.95 | 5077962.0 |
| 2017-05-22 16:00:00 | IWM | ETF | 136.96 | 137.05 | 136.88 | 137.04 | 901139.0 |
| 2017-05-22 17:00:00 | IWM | ETF | 137.02 | 137.06 | 137.01 | 137.01 | 8741.0 |
| 2017-05-22 18:00:00 | IWM | ETF | 137.01 | 137.05 | 136.86 | 136.86 | 43452.0 |
| 2017-05-22 19:00:00 | IWM | ETF | 136.86 | 136.9 | 136.63 | 136.63 | 17609.0 |
| 2017-05-22 05:00:00 | DIA | ETF | 207.9 | 207.9 | 207.7 | 207.7 | 700.0 |
| 2017-05-22 07:00:00 | DIA | ETF | 208.0 | 208.0 | 208.0 | 208.0 | 451.0 |
> showing 50 of 9,013 rows — these rows as CSV