PREVIEW / etf_1hour / 2017-03-27
file: by_date/etf_1hour/2017/2017-03-27.parquet size: 278 KB rows: 8,996
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-03-27 04:00:00 | SPY | ETF | 232.1 | 232.35 | 231.82 | 232.28 | 30286.0 |
| 2017-03-27 05:00:00 | SPY | ETF | 232.25 | 232.44 | 232.25 | 232.25 | 12579.0 |
| 2017-03-27 06:00:00 | SPY | ETF | 232.27 | 232.42 | 232.16 | 232.36 | 43615.0 |
| 2017-03-27 07:00:00 | SPY | ETF | 232.42 | 232.55 | 232.3 | 232.34 | 292907.0 |
| 2017-03-27 08:00:00 | SPY | ETF | 232.34 | 232.52 | 232.12 | 232.19 | 1667488.0 |
| 2017-03-27 09:00:00 | SPY | ETF | 232.18 | 232.61 | 231.61 | 232.47 | 13892507.0 |
| 2017-03-27 10:00:00 | SPY | ETF | 232.47 | 232.88 | 232.14 | 232.84 | 13376552.0 |
| 2017-03-27 11:00:00 | SPY | ETF | 232.84 | 233.38 | 232.6 | 233.21 | 11781128.0 |
| 2017-03-27 12:00:00 | SPY | ETF | 233.21 | 233.63 | 233.11 | 233.52 | 5982280.0 |
| 2017-03-27 13:00:00 | SPY | ETF | 233.52 | 233.82 | 233.2 | 233.29 | 6238048.0 |
| 2017-03-27 14:00:00 | SPY | ETF | 233.29 | 233.6 | 233.02 | 233.56 | 8237766.0 |
| 2017-03-27 15:00:00 | SPY | ETF | 233.55 | 233.92 | 233.47 | 233.58 | 18560924.0 |
| 2017-03-27 16:00:00 | SPY | ETF | 233.57 | 233.79 | 233.481 | 233.79 | 5646519.0 |
| 2017-03-27 17:00:00 | SPY | ETF | 233.77 | 233.87 | 233.62 | 233.85 | 366840.0 |
| 2017-03-27 18:00:00 | SPY | ETF | 233.85 | 233.86 | 233.74 | 233.81 | 84155.0 |
| 2017-03-27 19:00:00 | SPY | ETF | 233.8 | 234.02 | 233.8 | 233.98 | 111986.0 |
| 2017-03-27 04:00:00 | QQQ | ETF | 129.72 | 130.35 | 129.57 | 129.76 | 9960.0 |
| 2017-03-27 05:00:00 | QQQ | ETF | 129.78 | 129.93 | 129.78 | 129.89 | 17334.0 |
| 2017-03-27 06:00:00 | QQQ | ETF | 129.85 | 129.96 | 129.82 | 129.96 | 11207.0 |
| 2017-03-27 07:00:00 | QQQ | ETF | 130.0 | 130.0 | 129.94 | 129.94 | 32155.0 |
| 2017-03-27 08:00:00 | QQQ | ETF | 129.91 | 129.97 | 129.83 | 129.96 | 132706.0 |
| 2017-03-27 09:00:00 | QQQ | ETF | 129.93 | 129.97 | 129.4 | 129.93 | 3991056.0 |
| 2017-03-27 10:00:00 | QQQ | ETF | 129.91 | 130.4 | 129.81 | 130.35 | 2723087.0 |
| 2017-03-27 11:00:00 | QQQ | ETF | 130.34 | 130.68 | 130.18 | 130.6 | 2809830.0 |
| 2017-03-27 12:00:00 | QQQ | ETF | 130.6 | 130.95 | 130.52 | 130.88 | 1166444.0 |
| 2017-03-27 13:00:00 | QQQ | ETF | 130.86 | 131.05 | 130.73 | 130.78 | 2034355.0 |
| 2017-03-27 14:00:00 | QQQ | ETF | 130.78 | 130.99 | 130.67 | 130.961 | 1402459.0 |
| 2017-03-27 15:00:00 | QQQ | ETF | 130.96 | 131.07 | 130.8 | 130.85 | 2695982.0 |
| 2017-03-27 16:00:00 | QQQ | ETF | 130.84 | 131.0 | 130.82 | 131.0 | 577441.0 |
| 2017-03-27 17:00:00 | QQQ | ETF | 130.99 | 131.02 | 130.98 | 131.02 | 23157.0 |
| 2017-03-27 18:00:00 | QQQ | ETF | 130.99 | 131.06 | 130.99 | 131.01 | 32233.0 |
| 2017-03-27 19:00:00 | QQQ | ETF | 131.05 | 131.16 | 131.05 | 131.09 | 13413.0 |
| 2017-03-27 04:00:00 | IWM | ETF | 132.88 | 133.0 | 132.72 | 132.9 | 8736.0 |
| 2017-03-27 05:00:00 | IWM | ETF | 132.9 | 133.01 | 132.9 | 133.01 | 4123.0 |
| 2017-03-27 06:00:00 | IWM | ETF | 132.94 | 133.04 | 132.92 | 133.04 | 1603.0 |
| 2017-03-27 07:00:00 | IWM | ETF | 133.08 | 133.14 | 132.99 | 133.0 | 67351.0 |
| 2017-03-27 08:00:00 | IWM | ETF | 133.03 | 133.06 | 132.84 | 133.0 | 84374.0 |
| 2017-03-27 09:00:00 | IWM | ETF | 132.92 | 133.25 | 132.4 | 133.02 | 5336637.0 |
| 2017-03-27 10:00:00 | IWM | ETF | 133.0275 | 133.8 | 132.77 | 133.69 | 4180216.0 |
| 2017-03-27 11:00:00 | IWM | ETF | 133.7 | 134.07 | 133.4 | 133.77 | 3787989.0 |
| 2017-03-27 12:00:00 | IWM | ETF | 133.76 | 134.35 | 133.69 | 134.26 | 2007941.0 |
| 2017-03-27 13:00:00 | IWM | ETF | 134.25 | 134.55 | 134.01 | 134.09 | 2252403.0 |
| 2017-03-27 14:00:00 | IWM | ETF | 134.09 | 134.49 | 133.98 | 134.47 | 2449560.0 |
| 2017-03-27 15:00:00 | IWM | ETF | 134.47 | 135.07 | 134.47 | 134.74 | 5922298.0 |
| 2017-03-27 16:00:00 | IWM | ETF | 134.74 | 135.01 | 134.68 | 135.01 | 754345.0 |
| 2017-03-27 17:00:00 | IWM | ETF | 135.01 | 135.02 | 134.74 | 134.99 | 89430.0 |
| 2017-03-27 18:00:00 | IWM | ETF | 135.02 | 135.02 | 134.98 | 134.98 | 3079.0 |
| 2017-03-27 19:00:00 | IWM | ETF | 134.98 | 135.14 | 134.98 | 135.1 | 6621.0 |
| 2017-03-27 04:00:00 | DIA | ETF | 205.16 | 205.16 | 204.49 | 204.49 | 1200.0 |
| 2017-03-27 07:00:00 | DIA | ETF | 204.56 | 204.68 | 204.56 | 204.61 | 325.0 |
> showing 50 of 8,996 rows — these rows as CSV