PREVIEW / etf_1hour / 2017-02-24
file: by_date/etf_1hour/2017/2017-02-24.parquet size: 275 KB rows: 8,934
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-02-24 04:00:00 | SPY | ETF | 236.17 | 236.3 | 236.15 | 236.3 | 721.0 |
| 2017-02-24 05:00:00 | SPY | ETF | 236.22 | 236.22 | 235.82 | 235.98 | 24368.0 |
| 2017-02-24 06:00:00 | SPY | ETF | 235.95 | 235.95 | 235.32 | 235.35 | 580705.0 |
| 2017-02-24 07:00:00 | SPY | ETF | 235.4 | 235.63 | 235.35 | 235.35 | 378947.0 |
| 2017-02-24 08:00:00 | SPY | ETF | 235.52 | 235.6 | 235.31 | 235.4 | 803369.0 |
| 2017-02-24 09:00:00 | SPY | ETF | 235.41 | 235.96 | 235.21 | 235.94 | 9309113.0 |
| 2017-02-24 10:00:00 | SPY | ETF | 235.94 | 236.18 | 235.61 | 236.01 | 11450810.0 |
| 2017-02-24 11:00:00 | SPY | ETF | 236.0 | 236.24 | 235.805 | 235.835 | 6379390.0 |
| 2017-02-24 12:00:00 | SPY | ETF | 235.83 | 236.22 | 235.81 | 236.12 | 6229327.0 |
| 2017-02-24 13:00:00 | SPY | ETF | 236.115 | 236.15 | 235.835 | 236.075 | 5067116.0 |
| 2017-02-24 14:00:00 | SPY | ETF | 236.08 | 236.14 | 235.95 | 235.98 | 4679517.0 |
| 2017-02-24 15:00:00 | SPY | ETF | 235.98 | 236.7932 | 235.9 | 236.78 | 21615856.0 |
| 2017-02-24 16:00:00 | SPY | ETF | 236.79 | 236.8399 | 236.44 | 236.68 | 14138444.0 |
| 2017-02-24 17:00:00 | SPY | ETF | 236.67 | 236.74 | 236.65 | 236.68 | 84685.0 |
| 2017-02-24 18:00:00 | SPY | ETF | 236.69 | 236.71 | 236.66 | 236.71 | 32379.0 |
| 2017-02-24 19:00:00 | SPY | ETF | 236.72 | 236.74 | 236.69 | 236.74 | 35498.0 |
| 2017-02-24 04:00:00 | QQQ | ETF | 129.73 | 129.8 | 129.73 | 129.8 | 2097.0 |
| 2017-02-24 05:00:00 | QQQ | ETF | 129.72 | 129.72 | 129.55 | 129.59 | 11848.0 |
| 2017-02-24 06:00:00 | QQQ | ETF | 129.58 | 129.58 | 129.24 | 129.27 | 66290.0 |
| 2017-02-24 07:00:00 | QQQ | ETF | 129.26 | 129.41 | 129.25 | 129.29 | 77462.0 |
| 2017-02-24 08:00:00 | QQQ | ETF | 129.37 | 129.37 | 129.21 | 129.25 | 189527.0 |
| 2017-02-24 09:00:00 | QQQ | ETF | 129.3 | 129.74 | 129.22 | 129.73 | 4460871.0 |
| 2017-02-24 10:00:00 | QQQ | ETF | 129.73 | 129.85 | 129.43 | 129.72 | 3392784.0 |
| 2017-02-24 11:00:00 | QQQ | ETF | 129.71 | 129.87 | 129.6 | 129.62 | 1673186.0 |
| 2017-02-24 12:00:00 | QQQ | ETF | 129.61 | 129.86 | 129.6 | 129.82 | 874200.0 |
| 2017-02-24 13:00:00 | QQQ | ETF | 129.81 | 129.83 | 129.68 | 129.8 | 919270.0 |
| 2017-02-24 14:00:00 | QQQ | ETF | 129.8 | 129.9375 | 129.772 | 129.86 | 754132.0 |
| 2017-02-24 15:00:00 | QQQ | ETF | 129.87 | 130.26 | 129.8 | 130.26 | 3960116.0 |
| 2017-02-24 16:00:00 | QQQ | ETF | 130.26 | 130.3006 | 130.17 | 130.26 | 1396388.0 |
| 2017-02-24 17:00:00 | QQQ | ETF | 130.25 | 130.28 | 130.22 | 130.26 | 5249.0 |
| 2017-02-24 19:00:00 | QQQ | ETF | 130.26 | 130.27 | 130.22 | 130.22 | 2998.0 |
| 2017-02-24 05:00:00 | IWM | ETF | 138.1 | 138.1 | 138.1 | 138.1 | 100.0 |
| 2017-02-24 06:00:00 | IWM | ETF | 137.81 | 137.91 | 137.63 | 137.63 | 7100.0 |
| 2017-02-24 07:00:00 | IWM | ETF | 137.63 | 137.84 | 137.54 | 137.54 | 40502.0 |
| 2017-02-24 08:00:00 | IWM | ETF | 137.74 | 137.74 | 137.4 | 137.51 | 125118.0 |
| 2017-02-24 09:00:00 | IWM | ETF | 137.49 | 138.28 | 137.29 | 138.2 | 4120723.0 |
| 2017-02-24 10:00:00 | IWM | ETF | 138.19 | 138.44 | 137.85 | 138.4199 | 3868132.0 |
| 2017-02-24 11:00:00 | IWM | ETF | 138.41 | 138.58 | 138.09 | 138.13 | 2555755.0 |
| 2017-02-24 12:00:00 | IWM | ETF | 138.12 | 138.61 | 138.09 | 138.37 | 1611693.0 |
| 2017-02-24 13:00:00 | IWM | ETF | 138.36 | 138.43 | 138.07 | 138.4 | 1339395.0 |
| 2017-02-24 14:00:00 | IWM | ETF | 138.39 | 138.5 | 138.275 | 138.35 | 1136809.0 |
| 2017-02-24 15:00:00 | IWM | ETF | 138.36 | 138.65 | 138.18 | 138.63 | 3646649.0 |
| 2017-02-24 16:00:00 | IWM | ETF | 138.65 | 138.67 | 138.45 | 138.57 | 2268988.0 |
| 2017-02-24 17:00:00 | IWM | ETF | 138.55 | 138.64 | 138.51 | 138.64 | 4126.0 |
| 2017-02-24 18:00:00 | IWM | ETF | 138.63 | 138.63 | 138.63 | 138.63 | 199.0 |
| 2017-02-24 19:00:00 | IWM | ETF | 138.65 | 138.65 | 138.65 | 138.65 | 593.0 |
| 2017-02-24 05:00:00 | DIA | ETF | 207.61 | 207.61 | 207.61 | 207.61 | 200.0 |
| 2017-02-24 06:00:00 | DIA | ETF | 207.33 | 207.4 | 207.02 | 207.02 | 7557.0 |
| 2017-02-24 07:00:00 | DIA | ETF | 207.16 | 207.25 | 207.02 | 207.02 | 4045.0 |
| 2017-02-24 08:00:00 | DIA | ETF | 207.13 | 207.25 | 206.97 | 207.1 | 20819.0 |
> showing 50 of 8,934 rows — these rows as CSV