PREVIEW / etf_1hour / 2015-08-25
file: by_date/etf_1hour/2015/2015-08-25.parquet size: 274 KB rows: 8,804
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-25 04:00:00 | SPY | ETF | 193.34 | 194.45 | 193.15 | 193.59 | 208200.0 |
| 2015-08-25 05:00:00 | SPY | ETF | 193.45 | 194.4 | 193.1 | 193.93 | 233404.0 |
| 2015-08-25 06:00:00 | SPY | ETF | 194.07 | 195.62 | 192.94 | 194.13 | 1881641.0 |
| 2015-08-25 07:00:00 | SPY | ETF | 194.06 | 195.5 | 193.74 | 195.11 | 2538001.0 |
| 2015-08-25 08:00:00 | SPY | ETF | 195.11 | 195.48 | 193.86 | 193.95 | 5623395.0 |
| 2015-08-25 09:00:00 | SPY | ETF | 193.9 | 195.5 | 193.41 | 193.85 | 46429481.0 |
| 2015-08-25 10:00:00 | SPY | ETF | 193.85 | 194.559 | 192.97 | 193.58 | 53480166.0 |
| 2015-08-25 11:00:00 | SPY | ETF | 193.57 | 195.24 | 193.56 | 193.96 | 40151422.0 |
| 2015-08-25 12:00:00 | SPY | ETF | 193.96 | 194.4 | 193.53 | 193.62 | 24361621.0 |
| 2015-08-25 13:00:00 | SPY | ETF | 193.62 | 193.96 | 191.78 | 192.545 | 42064992.0 |
| 2015-08-25 14:00:00 | SPY | ETF | 192.5499 | 195.45 | 191.9 | 193.01 | 29184483.0 |
| 2015-08-25 15:00:00 | SPY | ETF | 193.01 | 193.23 | 187.06 | 187.24 | 97371418.0 |
| 2015-08-25 16:00:00 | SPY | ETF | 187.23 | 194.48 | 186.82 | 187.72 | 22795621.0 |
| 2015-08-25 17:00:00 | SPY | ETF | 187.72 | 192.2936 | 187.27 | 188.46 | 769023.0 |
| 2015-08-25 18:00:00 | SPY | ETF | 188.45 | 188.64 | 186.44 | 187.4 | 1054197.0 |
| 2015-08-25 19:00:00 | SPY | ETF | 187.4 | 187.63 | 185.79 | 185.81 | 851858.0 |
| 2015-08-25 04:00:00 | QQQ | ETF | 100.39 | 101.49 | 100.39 | 100.92 | 6112.0 |
| 2015-08-25 05:00:00 | QQQ | ETF | 100.88 | 101.39 | 100.88 | 101.35 | 11201.0 |
| 2015-08-25 06:00:00 | QQQ | ETF | 101.37 | 102.49 | 101.36 | 101.77 | 78255.0 |
| 2015-08-25 07:00:00 | QQQ | ETF | 101.76 | 102.4 | 101.61 | 102.17 | 186649.0 |
| 2015-08-25 08:00:00 | QQQ | ETF | 102.16 | 102.29 | 101.33 | 101.35 | 822323.0 |
| 2015-08-25 09:00:00 | QQQ | ETF | 101.32 | 104.97 | 101.0605 | 101.57 | 10728293.0 |
| 2015-08-25 10:00:00 | QQQ | ETF | 101.57 | 102.2 | 101.29 | 101.79 | 8969802.0 |
| 2015-08-25 11:00:00 | QQQ | ETF | 101.81 | 102.74 | 101.8 | 102.1999 | 4903481.0 |
| 2015-08-25 12:00:00 | QQQ | ETF | 102.19 | 102.39 | 101.94 | 101.97 | 3361497.0 |
| 2015-08-25 13:00:00 | QQQ | ETF | 101.96 | 102.09 | 100.62 | 101.21 | 7371824.0 |
| 2015-08-25 14:00:00 | QQQ | ETF | 101.2 | 101.67 | 100.68 | 101.45 | 4903740.0 |
| 2015-08-25 15:00:00 | QQQ | ETF | 101.442 | 101.6 | 98.04 | 98.08 | 15131717.0 |
| 2015-08-25 16:00:00 | QQQ | ETF | 98.1 | 98.52 | 97.94 | 98.15 | 2026190.0 |
| 2015-08-25 17:00:00 | QQQ | ETF | 98.19 | 98.42 | 97.99 | 98.38 | 361285.0 |
| 2015-08-25 18:00:00 | QQQ | ETF | 98.4 | 98.62 | 97.36 | 97.78 | 394111.0 |
| 2015-08-25 19:00:00 | QQQ | ETF | 97.81 | 97.96 | 96.68 | 96.7 | 347600.0 |
| 2015-08-25 04:00:00 | IWM | ETF | 113.1 | 113.75 | 113.1 | 113.75 | 51175.0 |
| 2015-08-25 06:00:00 | IWM | ETF | 113.3 | 114.3 | 113.3 | 113.5 | 38700.0 |
| 2015-08-25 07:00:00 | IWM | ETF | 113.5 | 114.91 | 113.5 | 114.72 | 172339.0 |
| 2015-08-25 08:00:00 | IWM | ETF | 114.3591 | 114.72 | 113.66 | 113.79 | 723873.0 |
| 2015-08-25 09:00:00 | IWM | ETF | 113.76 | 114.38 | 111.62 | 111.87 | 8367977.0 |
| 2015-08-25 10:00:00 | IWM | ETF | 111.85 | 112.235 | 111.085 | 111.33 | 9226475.0 |
| 2015-08-25 11:00:00 | IWM | ETF | 111.33 | 112.43 | 111.33 | 111.99 | 6460609.0 |
| 2015-08-25 12:00:00 | IWM | ETF | 112.0 | 112.53 | 111.87 | 112.29 | 3100905.0 |
| 2015-08-25 13:00:00 | IWM | ETF | 112.3 | 112.42 | 111.2 | 111.73 | 4298526.0 |
| 2015-08-25 14:00:00 | IWM | ETF | 111.71 | 111.81 | 111.05 | 111.46 | 4133859.0 |
| 2015-08-25 15:00:00 | IWM | ETF | 111.47 | 111.59 | 109.56 | 109.69 | 13448929.0 |
| 2015-08-25 16:00:00 | IWM | ETF | 109.68 | 110.66 | 109.39 | 110.0 | 3822938.0 |
| 2015-08-25 17:00:00 | IWM | ETF | 109.99 | 110.62 | 109.99 | 110.48 | 53530.0 |
| 2015-08-25 18:00:00 | IWM | ETF | 110.477 | 110.477 | 109.51 | 109.603 | 11315.0 |
| 2015-08-25 19:00:00 | IWM | ETF | 109.69 | 109.69 | 109.45 | 109.68 | 427856.0 |
| 2015-08-25 04:00:00 | DIA | ETF | 161.48 | 162.26 | 161.48 | 161.8 | 1500.0 |
| 2015-08-25 05:00:00 | DIA | ETF | 161.75 | 161.75 | 161.75 | 161.75 | 500.0 |
| 2015-08-25 06:00:00 | DIA | ETF | 161.78 | 163.4 | 161.78 | 163.0 | 25468.0 |
> showing 50 of 8,804 rows — these rows as CSV