PREVIEW / etf_1hour / 2015-08-11
file: by_date/etf_1hour/2015/2015-08-11.parquet size: 245 KB rows: 7,786
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-11 04:00:00 | SPY | ETF | 209.85 | 210.1 | 209.6 | 209.73 | 55178.0 |
| 2015-08-11 05:00:00 | SPY | ETF | 209.68 | 209.73 | 209.22 | 209.31 | 217959.0 |
| 2015-08-11 06:00:00 | SPY | ETF | 209.28 | 209.86 | 209.21 | 209.84 | 269240.0 |
| 2015-08-11 07:00:00 | SPY | ETF | 209.81 | 209.84 | 209.35 | 209.51 | 471935.0 |
| 2015-08-11 08:00:00 | SPY | ETF | 209.51 | 210.6 | 208.75 | 208.78 | 1632291.0 |
| 2015-08-11 09:00:00 | SPY | ETF | 208.77 | 209.3 | 208.7 | 208.99 | 17459728.0 |
| 2015-08-11 10:00:00 | SPY | ETF | 208.995 | 209.47 | 208.8199 | 208.91 | 15356548.0 |
| 2015-08-11 11:00:00 | SPY | ETF | 208.9 | 209.0 | 208.06 | 208.2 | 12813435.0 |
| 2015-08-11 12:00:00 | SPY | ETF | 208.2 | 208.56 | 208.064 | 208.11 | 10314085.0 |
| 2015-08-11 13:00:00 | SPY | ETF | 208.11 | 208.29 | 207.76 | 207.9 | 13255446.0 |
| 2015-08-11 14:00:00 | SPY | ETF | 207.9 | 208.39 | 207.82 | 208.305 | 12668205.0 |
| 2015-08-11 15:00:00 | SPY | ETF | 208.31 | 208.79 | 208.17 | 208.63 | 24029079.0 |
| 2015-08-11 16:00:00 | SPY | ETF | 208.65 | 208.84 | 208.5617 | 208.72 | 15167404.0 |
| 2015-08-11 17:00:00 | SPY | ETF | 208.71 | 208.8 | 208.71 | 208.73 | 169857.0 |
| 2015-08-11 18:00:00 | SPY | ETF | 208.75 | 208.82 | 208.69 | 208.82 | 53970.0 |
| 2015-08-11 19:00:00 | SPY | ETF | 208.77 | 209.02 | 208.76 | 208.99 | 85002.0 |
| 2015-08-11 04:00:00 | QQQ | ETF | 111.48 | 111.57 | 111.29 | 111.29 | 8100.0 |
| 2015-08-11 05:00:00 | QQQ | ETF | 111.24 | 111.24 | 111.09 | 111.09 | 12600.0 |
| 2015-08-11 06:00:00 | QQQ | ETF | 111.11 | 111.42 | 111.09 | 111.42 | 3950.0 |
| 2015-08-11 07:00:00 | QQQ | ETF | 111.44 | 111.44 | 111.17 | 111.23 | 61700.0 |
| 2015-08-11 08:00:00 | QQQ | ETF | 111.23 | 111.34 | 110.72 | 110.72 | 351806.0 |
| 2015-08-11 09:00:00 | QQQ | ETF | 110.73 | 111.4101 | 110.71 | 111.16 | 5154853.0 |
| 2015-08-11 10:00:00 | QQQ | ETF | 111.16 | 111.25 | 110.75 | 110.7572 | 4245984.0 |
| 2015-08-11 11:00:00 | QQQ | ETF | 110.75 | 110.8268 | 110.02 | 110.13 | 4162871.0 |
| 2015-08-11 12:00:00 | QQQ | ETF | 110.12 | 110.344 | 109.95 | 109.9701 | 2698475.0 |
| 2015-08-11 13:00:00 | QQQ | ETF | 109.97 | 109.99 | 109.61 | 109.64 | 3877819.0 |
| 2015-08-11 14:00:00 | QQQ | ETF | 109.64 | 109.97 | 109.53 | 109.92 | 3465472.0 |
| 2015-08-11 15:00:00 | QQQ | ETF | 109.925 | 110.25 | 109.85 | 110.15 | 5749088.0 |
| 2015-08-11 16:00:00 | QQQ | ETF | 110.14 | 110.28 | 110.1 | 110.2 | 494159.0 |
| 2015-08-11 17:00:00 | QQQ | ETF | 110.22 | 110.22 | 110.16 | 110.16 | 5300.0 |
| 2015-08-11 18:00:00 | QQQ | ETF | 110.24 | 110.28 | 110.22 | 110.26 | 15807.0 |
| 2015-08-11 19:00:00 | QQQ | ETF | 110.28 | 110.4 | 110.24 | 110.39 | 23590.0 |
| 2015-08-11 04:00:00 | IWM | ETF | 121.06 | 121.06 | 120.82 | 120.82 | 540.0 |
| 2015-08-11 05:00:00 | IWM | ETF | 120.8 | 120.82 | 120.5 | 120.5 | 4300.0 |
| 2015-08-11 06:00:00 | IWM | ETF | 120.96 | 120.96 | 120.96 | 120.96 | 100.0 |
| 2015-08-11 07:00:00 | IWM | ETF | 120.55 | 120.69 | 120.54 | 120.69 | 35699.0 |
| 2015-08-11 08:00:00 | IWM | ETF | 120.64 | 120.64 | 120.18 | 120.18 | 203054.0 |
| 2015-08-11 09:00:00 | IWM | ETF | 120.16 | 120.9 | 120.12 | 120.4747 | 4560660.0 |
| 2015-08-11 10:00:00 | IWM | ETF | 120.43 | 121.09 | 120.21 | 120.78 | 3583782.0 |
| 2015-08-11 11:00:00 | IWM | ETF | 120.78 | 120.87 | 119.9 | 120.055 | 3837677.0 |
| 2015-08-11 12:00:00 | IWM | ETF | 120.065 | 120.54 | 119.98 | 120.05 | 2118327.0 |
| 2015-08-11 13:00:00 | IWM | ETF | 120.04 | 120.12 | 119.74 | 119.76 | 2331043.0 |
| 2015-08-11 14:00:00 | IWM | ETF | 119.75 | 120.0 | 119.65 | 119.975 | 2355900.0 |
| 2015-08-11 15:00:00 | IWM | ETF | 119.97 | 120.38 | 119.9 | 120.24 | 4825035.0 |
| 2015-08-11 16:00:00 | IWM | ETF | 120.24 | 120.4212 | 120.12 | 120.34 | 1768526.0 |
| 2015-08-11 17:00:00 | IWM | ETF | 120.31 | 120.31 | 120.28 | 120.28 | 2000.0 |
| 2015-08-11 18:00:00 | IWM | ETF | 120.28 | 120.28 | 120.28 | 120.28 | 300.0 |
| 2015-08-11 19:00:00 | IWM | ETF | 120.35 | 120.35 | 120.28 | 120.35 | 1050.0 |
| 2015-08-11 04:00:00 | DIA | ETF | 175.56 | 175.56 | 175.41 | 175.41 | 1500.0 |
| 2015-08-11 06:00:00 | DIA | ETF | 175.02 | 175.37 | 175.02 | 175.37 | 256.0 |
> showing 50 of 7,786 rows — these rows as CSV