PREVIEW / etf_1hour / 2015-07-27
file: by_date/etf_1hour/2015/2015-07-27.parquet size: 250 KB rows: 8,063
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-07-27 04:00:00 | SPY | ETF | 207.86 | 208.27 | 207.55 | 208.25 | 20897.0 |
| 2015-07-27 05:00:00 | SPY | ETF | 208.11 | 208.18 | 207.7 | 207.7 | 25444.0 |
| 2015-07-27 06:00:00 | SPY | ETF | 207.77 | 207.8 | 207.5 | 207.5 | 245287.0 |
| 2015-07-27 07:00:00 | SPY | ETF | 207.5 | 207.5 | 207.04 | 207.27 | 475124.0 |
| 2015-07-27 08:00:00 | SPY | ETF | 207.3 | 208.61 | 207.05 | 207.22 | 1562317.0 |
| 2015-07-27 09:00:00 | SPY | ETF | 207.21 | 207.32 | 206.26 | 206.9 | 20031940.0 |
| 2015-07-27 10:00:00 | SPY | ETF | 206.9 | 207.55 | 206.4 | 207.16 | 20150386.0 |
| 2015-07-27 11:00:00 | SPY | ETF | 207.16 | 207.47 | 206.75 | 207.08 | 11236748.0 |
| 2015-07-27 12:00:00 | SPY | ETF | 207.09 | 207.135 | 206.64 | 206.74 | 6328353.0 |
| 2015-07-27 13:00:00 | SPY | ETF | 206.73 | 206.955 | 206.5 | 206.85 | 9238998.0 |
| 2015-07-27 14:00:00 | SPY | ETF | 206.84 | 207.13 | 206.68 | 206.83 | 12710355.0 |
| 2015-07-27 15:00:00 | SPY | ETF | 206.82 | 206.825 | 206.31 | 206.76 | 31887617.0 |
| 2015-07-27 16:00:00 | SPY | ETF | 206.76 | 207.14 | 206.7035 | 207.09 | 7439119.0 |
| 2015-07-27 17:00:00 | SPY | ETF | 207.08 | 207.16 | 207.05 | 207.16 | 134970.0 |
| 2015-07-27 18:00:00 | SPY | ETF | 207.17 | 207.25 | 206.79 | 207.19 | 4911118.0 |
| 2015-07-27 19:00:00 | SPY | ETF | 207.19 | 207.27 | 207.175 | 207.2 | 252389.0 |
| 2015-07-27 04:00:00 | QQQ | ETF | 111.0 | 111.15 | 111.0 | 111.15 | 300.0 |
| 2015-07-27 05:00:00 | QQQ | ETF | 111.1 | 111.1 | 110.88 | 110.88 | 12600.0 |
| 2015-07-27 06:00:00 | QQQ | ETF | 110.9 | 110.9 | 110.77 | 110.77 | 19650.0 |
| 2015-07-27 07:00:00 | QQQ | ETF | 110.71 | 110.71 | 110.44 | 110.58 | 129558.0 |
| 2015-07-27 08:00:00 | QQQ | ETF | 110.6 | 110.65 | 110.47 | 110.62 | 190922.0 |
| 2015-07-27 09:00:00 | QQQ | ETF | 110.65 | 110.67 | 110.02 | 110.615 | 6678173.0 |
| 2015-07-27 10:00:00 | QQQ | ETF | 110.61 | 110.946 | 110.23 | 110.68 | 6025510.0 |
| 2015-07-27 11:00:00 | QQQ | ETF | 110.68 | 110.87 | 110.26 | 110.43 | 3247292.0 |
| 2015-07-27 12:00:00 | QQQ | ETF | 110.44 | 110.48 | 110.15 | 110.21 | 1260639.0 |
| 2015-07-27 13:00:00 | QQQ | ETF | 110.21 | 110.329 | 110.02 | 110.25 | 2000390.0 |
| 2015-07-27 14:00:00 | QQQ | ETF | 110.26 | 110.4 | 110.12 | 110.191 | 2497914.0 |
| 2015-07-27 15:00:00 | QQQ | ETF | 110.19 | 110.25 | 109.94 | 110.19 | 6630600.0 |
| 2015-07-27 16:00:00 | QQQ | ETF | 110.18 | 110.4 | 110.17 | 110.32 | 704661.0 |
| 2015-07-27 17:00:00 | QQQ | ETF | 110.33 | 110.39 | 110.31 | 110.33 | 15617.0 |
| 2015-07-27 18:00:00 | QQQ | ETF | 110.36 | 110.41 | 110.34 | 110.38 | 21270.0 |
| 2015-07-27 19:00:00 | QQQ | ETF | 110.37 | 110.4 | 110.36 | 110.37 | 16937.0 |
| 2015-07-27 04:00:00 | IWM | ETF | 121.76 | 121.76 | 121.76 | 121.76 | 300.0 |
| 2015-07-27 06:00:00 | IWM | ETF | 121.49 | 121.49 | 121.49 | 121.49 | 200.0 |
| 2015-07-27 07:00:00 | IWM | ETF | 121.33 | 121.33 | 120.99 | 121.01 | 54441.0 |
| 2015-07-27 08:00:00 | IWM | ETF | 121.04 | 121.18 | 120.86 | 121.18 | 206497.0 |
| 2015-07-27 09:00:00 | IWM | ETF | 121.19 | 121.26 | 120.27 | 120.9 | 6435368.0 |
| 2015-07-27 10:00:00 | IWM | ETF | 120.89 | 121.32 | 120.53 | 120.9 | 5088805.0 |
| 2015-07-27 11:00:00 | IWM | ETF | 120.89 | 121.21 | 120.5 | 120.85 | 3419138.0 |
| 2015-07-27 12:00:00 | IWM | ETF | 120.86 | 120.93 | 120.48 | 120.52 | 1591693.0 |
| 2015-07-27 13:00:00 | IWM | ETF | 120.52 | 120.72 | 120.37 | 120.5213 | 2973523.0 |
| 2015-07-27 14:00:00 | IWM | ETF | 120.53 | 120.76 | 120.41 | 120.6599 | 3396752.0 |
| 2015-07-27 15:00:00 | IWM | ETF | 120.65 | 120.67 | 120.29 | 120.59 | 6479416.0 |
| 2015-07-27 16:00:00 | IWM | ETF | 120.59 | 120.71 | 120.47 | 120.65 | 1895550.0 |
| 2015-07-27 17:00:00 | IWM | ETF | 120.67 | 120.67 | 120.57 | 120.57 | 403825.0 |
| 2015-07-27 18:00:00 | IWM | ETF | 120.7 | 120.7 | 120.7 | 120.7 | 100.0 |
| 2015-07-27 19:00:00 | IWM | ETF | 120.7 | 120.7 | 120.7 | 120.7 | 100.0 |
| 2015-07-27 06:00:00 | DIA | ETF | 175.19 | 175.19 | 175.09 | 175.09 | 10601.0 |
| 2015-07-27 07:00:00 | DIA | ETF | 175.07 | 175.07 | 174.7 | 174.9 | 16400.0 |
| 2015-07-27 08:00:00 | DIA | ETF | 174.79 | 174.8 | 174.553 | 174.58 | 8800.0 |
> showing 50 of 8,063 rows — these rows as CSV