PREVIEW / etf_1hour / 2015-08-24
file: by_date/etf_1hour/2015/2015-08-24.parquet size: 281 KB rows: 9,185
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-08-24 04:00:00 | SPY | ETF | 194.32 | 194.56 | 193.7 | 194.53 | 228295.0 |
| 2015-08-24 05:00:00 | SPY | ETF | 194.52 | 194.97 | 194.15 | 194.15 | 507575.0 |
| 2015-08-24 06:00:00 | SPY | ETF | 194.18 | 194.39 | 193.01 | 194.13 | 952983.0 |
| 2015-08-24 07:00:00 | SPY | ETF | 194.13 | 194.13 | 190.55 | 190.81 | 4683246.0 |
| 2015-08-24 08:00:00 | SPY | ETF | 190.82 | 194.04 | 189.95 | 190.33 | 9584299.0 |
| 2015-08-24 09:00:00 | SPY | ETF | 190.32 | 191.14 | 182.4 | 189.81 | 54816939.0 |
| 2015-08-24 10:00:00 | SPY | ETF | 189.79 | 193.63 | 189.09 | 192.81 | 86159021.0 |
| 2015-08-24 11:00:00 | SPY | ETF | 192.81 | 194.9 | 191.18 | 194.6 | 57433036.0 |
| 2015-08-24 12:00:00 | SPY | ETF | 194.6 | 195.75 | 193.65 | 195.07 | 49927853.0 |
| 2015-08-24 13:00:00 | SPY | ETF | 195.07 | 195.84 | 192.52 | 192.57 | 35379397.0 |
| 2015-08-24 14:00:00 | SPY | ETF | 192.57 | 192.74 | 189.18 | 189.415 | 53697207.0 |
| 2015-08-24 15:00:00 | SPY | ETF | 189.41 | 197.4772 | 188.21 | 189.48 | 113776578.0 |
| 2015-08-24 16:00:00 | SPY | ETF | 189.42 | 196.53 | 187.23 | 188.25 | 28805447.0 |
| 2015-08-24 17:00:00 | SPY | ETF | 188.27 | 189.55 | 187.65 | 188.1 | 7473505.0 |
| 2015-08-24 18:00:00 | SPY | ETF | 188.06 | 189.55 | 188.06 | 189.25 | 996843.0 |
| 2015-08-24 19:00:00 | SPY | ETF | 189.24 | 190.17 | 188.93 | 189.84 | 293948.0 |
| 2015-08-24 04:00:00 | QQQ | ETF | 99.19 | 101.25 | 98.74 | 99.01 | 52742.0 |
| 2015-08-24 05:00:00 | QQQ | ETF | 99.01 | 99.74 | 99.01 | 99.39 | 53472.0 |
| 2015-08-24 06:00:00 | QQQ | ETF | 99.46 | 99.5 | 98.61 | 99.11 | 98664.0 |
| 2015-08-24 07:00:00 | QQQ | ETF | 99.02 | 99.02 | 97.44 | 97.6 | 545004.0 |
| 2015-08-24 08:00:00 | QQQ | ETF | 97.52 | 98.53 | 97.16 | 97.47 | 806524.0 |
| 2015-08-24 09:00:00 | QQQ | ETF | 97.43 | 98.81 | 84.74 | 98.02 | 19501264.0 |
| 2015-08-24 10:00:00 | QQQ | ETF | 98.0 | 100.64 | 97.6751 | 100.29 | 19334633.0 |
| 2015-08-24 11:00:00 | QQQ | ETF | 100.3 | 101.94 | 99.4 | 101.7705 | 14247149.0 |
| 2015-08-24 12:00:00 | QQQ | ETF | 101.76 | 102.53 | 101.25 | 101.91 | 11550211.0 |
| 2015-08-24 13:00:00 | QQQ | ETF | 101.91 | 102.48 | 100.41 | 100.43 | 7515715.0 |
| 2015-08-24 14:00:00 | QQQ | ETF | 100.44 | 100.63 | 98.49 | 98.585 | 10717371.0 |
| 2015-08-24 15:00:00 | QQQ | ETF | 98.57 | 100.87 | 97.675 | 98.54 | 27190683.0 |
| 2015-08-24 16:00:00 | QQQ | ETF | 98.55 | 99.55 | 97.68 | 98.15 | 2831971.0 |
| 2015-08-24 17:00:00 | QQQ | ETF | 97.91 | 98.0 | 97.75 | 97.977 | 60215.0 |
| 2015-08-24 18:00:00 | QQQ | ETF | 97.98 | 98.63 | 97.91 | 98.59 | 47324.0 |
| 2015-08-24 19:00:00 | QQQ | ETF | 98.49 | 98.77 | 98.3 | 98.69 | 123708.0 |
| 2015-08-24 04:00:00 | IWM | ETF | 113.16 | 113.16 | 112.78 | 113.0 | 1709.0 |
| 2015-08-24 05:00:00 | IWM | ETF | 113.0 | 113.13 | 112.94 | 113.09 | 2300.0 |
| 2015-08-24 06:00:00 | IWM | ETF | 112.79 | 112.79 | 112.3 | 112.44 | 9195.0 |
| 2015-08-24 07:00:00 | IWM | ETF | 112.52 | 112.52 | 111.02 | 111.09 | 286479.0 |
| 2015-08-24 08:00:00 | IWM | ETF | 111.08 | 111.57 | 110.45 | 110.64 | 1244528.0 |
| 2015-08-24 09:00:00 | IWM | ETF | 110.54 | 111.4 | 108.26 | 110.58 | 8084353.0 |
| 2015-08-24 10:00:00 | IWM | ETF | 110.57 | 112.65 | 110.01 | 112.41 | 12587682.0 |
| 2015-08-24 11:00:00 | IWM | ETF | 112.415 | 113.64 | 111.34 | 113.43 | 10223817.0 |
| 2015-08-24 12:00:00 | IWM | ETF | 113.42 | 114.27 | 112.69 | 113.63 | 7256271.0 |
| 2015-08-24 13:00:00 | IWM | ETF | 113.635 | 114.0499 | 112.3 | 112.35 | 5439025.0 |
| 2015-08-24 14:00:00 | IWM | ETF | 112.36 | 112.44 | 110.65 | 110.8 | 7372836.0 |
| 2015-08-24 15:00:00 | IWM | ETF | 110.8 | 111.94 | 110.08 | 110.59 | 16460460.0 |
| 2015-08-24 16:00:00 | IWM | ETF | 110.57 | 112.75 | 109.08 | 109.83 | 4750122.0 |
| 2015-08-24 17:00:00 | IWM | ETF | 111.09 | 111.09 | 109.35 | 109.7 | 17439.0 |
| 2015-08-24 18:00:00 | IWM | ETF | 110.54 | 110.54 | 110.0 | 110.5 | 93046.0 |
| 2015-08-24 19:00:00 | IWM | ETF | 110.64 | 110.97 | 110.44 | 110.97 | 3143.0 |
| 2015-08-24 04:00:00 | DIA | ETF | 161.39 | 161.48 | 161.0 | 161.0 | 40780.0 |
| 2015-08-24 06:00:00 | DIA | ETF | 160.81 | 160.88 | 160.5 | 160.8 | 23325.0 |
> showing 50 of 9,185 rows — these rows as CSV