PREVIEW / etf_1hour / 2015-10-09
file: by_date/etf_1hour/2015/2015-10-09.parquet size: 239 KB rows: 7,644
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-10-09 04:00:00 | SPY | ETF | 200.81 | 201.02 | 200.58 | 201.0 | 57284.0 |
| 2015-10-09 05:00:00 | SPY | ETF | 201.0 | 201.34 | 200.96 | 201.16 | 15765.0 |
| 2015-10-09 06:00:00 | SPY | ETF | 201.09 | 201.65 | 201.09 | 201.54 | 34370.0 |
| 2015-10-09 07:00:00 | SPY | ETF | 201.51 | 201.68 | 201.33 | 201.67 | 475511.0 |
| 2015-10-09 08:00:00 | SPY | ETF | 201.65 | 202.05 | 201.06 | 201.77 | 1323706.0 |
| 2015-10-09 09:00:00 | SPY | ETF | 201.75 | 201.9 | 201.21 | 201.6396 | 11121185.0 |
| 2015-10-09 10:00:00 | SPY | ETF | 201.64 | 201.82 | 200.94 | 201.79 | 15097557.0 |
| 2015-10-09 11:00:00 | SPY | ETF | 201.79 | 201.89 | 201.14 | 201.38 | 9937925.0 |
| 2015-10-09 12:00:00 | SPY | ETF | 201.38 | 201.56 | 200.77 | 200.95 | 8948369.0 |
| 2015-10-09 13:00:00 | SPY | ETF | 200.96 | 201.12 | 200.58 | 200.89 | 10481653.0 |
| 2015-10-09 14:00:00 | SPY | ETF | 200.89 | 201.23 | 200.6911 | 201.21 | 8586105.0 |
| 2015-10-09 15:00:00 | SPY | ETF | 201.215 | 201.52 | 200.96 | 201.36 | 24449719.0 |
| 2015-10-09 16:00:00 | SPY | ETF | 201.36 | 201.47 | 201.26 | 201.36 | 13097900.0 |
| 2015-10-09 17:00:00 | SPY | ETF | 201.35 | 201.39 | 201.26 | 201.35 | 933244.0 |
| 2015-10-09 18:00:00 | SPY | ETF | 201.33 | 201.34 | 201.27 | 201.32 | 30766.0 |
| 2015-10-09 19:00:00 | SPY | ETF | 201.3 | 201.31 | 201.29 | 201.3 | 31326.0 |
| 2015-10-09 04:00:00 | QQQ | ETF | 105.75 | 105.86 | 105.69 | 105.83 | 16600.0 |
| 2015-10-09 05:00:00 | QQQ | ETF | 106.02 | 106.06 | 106.01 | 106.05 | 1544.0 |
| 2015-10-09 06:00:00 | QQQ | ETF | 105.95 | 106.2 | 105.95 | 106.2 | 2230.0 |
| 2015-10-09 07:00:00 | QQQ | ETF | 106.05 | 106.2 | 106.05 | 106.15 | 6342.0 |
| 2015-10-09 08:00:00 | QQQ | ETF | 106.12 | 106.42 | 106.06 | 106.26 | 106289.0 |
| 2015-10-09 09:00:00 | QQQ | ETF | 106.23 | 106.42 | 105.81 | 106.2025 | 3026399.0 |
| 2015-10-09 10:00:00 | QQQ | ETF | 106.21 | 106.68 | 105.85 | 106.655 | 6044522.0 |
| 2015-10-09 11:00:00 | QQQ | ETF | 106.65 | 106.73 | 106.24 | 106.46 | 2483624.0 |
| 2015-10-09 12:00:00 | QQQ | ETF | 106.46 | 106.5714 | 106.09 | 106.23 | 1881248.0 |
| 2015-10-09 13:00:00 | QQQ | ETF | 106.24 | 106.37 | 106.01 | 106.145 | 1708759.0 |
| 2015-10-09 14:00:00 | QQQ | ETF | 106.17 | 106.46 | 106.105 | 106.43 | 1339180.0 |
| 2015-10-09 15:00:00 | QQQ | ETF | 106.45 | 106.58 | 106.3027 | 106.51 | 3474679.0 |
| 2015-10-09 16:00:00 | QQQ | ETF | 106.52 | 106.53 | 106.1783 | 106.44 | 710892.0 |
| 2015-10-09 17:00:00 | QQQ | ETF | 106.4301 | 106.5 | 106.41 | 106.41 | 3933.0 |
| 2015-10-09 18:00:00 | QQQ | ETF | 106.45 | 106.45 | 106.39 | 106.39 | 2960.0 |
| 2015-10-09 19:00:00 | QQQ | ETF | 106.34 | 106.37 | 106.34 | 106.36 | 5032.0 |
| 2015-10-09 05:00:00 | IWM | ETF | 115.52 | 115.52 | 115.52 | 115.52 | 200.0 |
| 2015-10-09 07:00:00 | IWM | ETF | 115.82 | 115.83 | 115.68 | 115.68 | 11300.0 |
| 2015-10-09 08:00:00 | IWM | ETF | 115.8 | 116.01 | 115.8 | 115.9 | 61762.0 |
| 2015-10-09 09:00:00 | IWM | ETF | 115.85 | 116.04 | 115.53 | 115.82 | 3858905.0 |
| 2015-10-09 10:00:00 | IWM | ETF | 115.82 | 116.01 | 115.395 | 116.0 | 3937999.0 |
| 2015-10-09 11:00:00 | IWM | ETF | 115.985 | 116.14 | 115.54 | 115.78 | 2326368.0 |
| 2015-10-09 12:00:00 | IWM | ETF | 115.78 | 115.93 | 115.43 | 115.695 | 2655914.0 |
| 2015-10-09 13:00:00 | IWM | ETF | 115.7 | 115.84 | 115.51 | 115.64 | 1660999.0 |
| 2015-10-09 14:00:00 | IWM | ETF | 115.65 | 115.76 | 115.4 | 115.72 | 2008828.0 |
| 2015-10-09 15:00:00 | IWM | ETF | 115.73 | 115.86 | 115.575 | 115.71 | 4355523.0 |
| 2015-10-09 16:00:00 | IWM | ETF | 115.74 | 115.76 | 115.63 | 115.68 | 967656.0 |
| 2015-10-09 17:00:00 | IWM | ETF | 115.63 | 115.79 | 115.62 | 115.74 | 12576.0 |
| 2015-10-09 04:00:00 | DIA | ETF | 170.3 | 170.3 | 169.97 | 169.97 | 17700.0 |
| 2015-10-09 07:00:00 | DIA | ETF | 170.64 | 170.74 | 170.64 | 170.74 | 1450.0 |
| 2015-10-09 08:00:00 | DIA | ETF | 170.8 | 171.02 | 170.72 | 170.83 | 31284.0 |
| 2015-10-09 09:00:00 | DIA | ETF | 170.8 | 170.97 | 170.402 | 170.76 | 794712.0 |
| 2015-10-09 10:00:00 | DIA | ETF | 170.78 | 170.89 | 170.23 | 170.861 | 1006887.0 |
| 2015-10-09 11:00:00 | DIA | ETF | 170.87 | 170.95 | 170.43 | 170.56 | 451943.0 |
> showing 50 of 7,644 rows — these rows as CSV