PREVIEW / etf_1hour / 2015-05-06
file: by_date/etf_1hour/2015/2015-05-06.parquet size: 246 KB rows: 7,792
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-05-06 04:00:00 | SPY | ETF | 209.19 | 209.66 | 209.19 | 209.6 | 41995.0 |
| 2015-05-06 05:00:00 | SPY | ETF | 209.54 | 209.8 | 209.5 | 209.51 | 39889.0 |
| 2015-05-06 06:00:00 | SPY | ETF | 209.54 | 209.64 | 209.25 | 209.32 | 73426.0 |
| 2015-05-06 07:00:00 | SPY | ETF | 209.34 | 209.71 | 209.33 | 209.67 | 432678.0 |
| 2015-05-06 08:00:00 | SPY | ETF | 209.65 | 209.7 | 209.35 | 209.43 | 865498.0 |
| 2015-05-06 09:00:00 | SPY | ETF | 209.44 | 209.93 | 207.98 | 208.36 | 15852456.0 |
| 2015-05-06 10:00:00 | SPY | ETF | 208.36 | 208.98 | 207.65 | 208.8 | 23619806.0 |
| 2015-05-06 11:00:00 | SPY | ETF | 208.81 | 208.89 | 208.12 | 208.5501 | 11599228.0 |
| 2015-05-06 12:00:00 | SPY | ETF | 208.55 | 208.58 | 207.86 | 207.98 | 10154188.0 |
| 2015-05-06 13:00:00 | SPY | ETF | 207.99 | 208.17 | 207.28 | 207.511 | 13881490.0 |
| 2015-05-06 14:00:00 | SPY | ETF | 207.52 | 207.65 | 206.76 | 207.1742 | 19359610.0 |
| 2015-05-06 15:00:00 | SPY | ETF | 207.18 | 208.09 | 206.89 | 208.03 | 27273805.0 |
| 2015-05-06 16:00:00 | SPY | ETF | 208.03 | 209.63 | 207.5025 | 208.09 | 10060341.0 |
| 2015-05-06 17:00:00 | SPY | ETF | 208.09 | 208.13 | 208.03 | 208.08 | 106967.0 |
| 2015-05-06 18:00:00 | SPY | ETF | 208.08 | 208.17 | 208.05 | 208.05 | 23536.0 |
| 2015-05-06 19:00:00 | SPY | ETF | 208.05 | 208.07 | 207.78 | 207.92 | 61182.0 |
| 2015-05-06 06:00:00 | QQQ | ETF | 107.62 | 107.71 | 107.52 | 107.6 | 46794.0 |
| 2015-05-06 07:00:00 | QQQ | ETF | 107.62 | 107.76 | 107.59 | 107.76 | 222556.0 |
| 2015-05-06 08:00:00 | QQQ | ETF | 107.75 | 107.789 | 107.59 | 107.59 | 121369.0 |
| 2015-05-06 09:00:00 | QQQ | ETF | 107.65 | 107.95 | 106.71 | 106.9 | 6466761.0 |
| 2015-05-06 10:00:00 | QQQ | ETF | 106.895 | 107.22 | 106.46 | 107.14 | 6980028.0 |
| 2015-05-06 11:00:00 | QQQ | ETF | 107.15 | 107.31 | 106.85 | 107.07 | 2758578.0 |
| 2015-05-06 12:00:00 | QQQ | ETF | 107.08 | 107.08 | 106.64 | 106.72 | 2078461.0 |
| 2015-05-06 13:00:00 | QQQ | ETF | 106.73 | 106.82 | 106.245 | 106.42 | 4590832.0 |
| 2015-05-06 14:00:00 | QQQ | ETF | 106.411 | 106.47 | 105.995 | 106.235 | 3894741.0 |
| 2015-05-06 15:00:00 | QQQ | ETF | 106.24 | 106.77 | 106.07 | 106.73 | 5891580.0 |
| 2015-05-06 16:00:00 | QQQ | ETF | 106.74 | 106.79 | 106.3972 | 106.75 | 557289.0 |
| 2015-05-06 17:00:00 | QQQ | ETF | 106.73 | 106.76 | 106.7 | 106.73 | 33887.0 |
| 2015-05-06 18:00:00 | QQQ | ETF | 106.74 | 106.79 | 106.74 | 106.74 | 50438.0 |
| 2015-05-06 19:00:00 | QQQ | ETF | 106.75 | 106.75 | 106.64 | 106.64 | 25233.0 |
| 2015-05-06 07:00:00 | IWM | ETF | 121.2 | 121.41 | 121.17 | 121.32 | 81360.0 |
| 2015-05-06 08:00:00 | IWM | ETF | 121.32 | 121.34 | 121.21 | 121.23 | 124977.0 |
| 2015-05-06 09:00:00 | IWM | ETF | 121.23 | 121.49 | 120.49 | 120.76 | 4978965.0 |
| 2015-05-06 10:00:00 | IWM | ETF | 120.755 | 121.23 | 120.39 | 121.05 | 6873017.0 |
| 2015-05-06 11:00:00 | IWM | ETF | 121.07 | 121.14 | 120.58 | 120.99 | 2455137.0 |
| 2015-05-06 12:00:00 | IWM | ETF | 121.0 | 121.02 | 120.74 | 120.8 | 1860044.0 |
| 2015-05-06 13:00:00 | IWM | ETF | 120.81 | 120.93 | 120.5 | 120.68 | 2463090.0 |
| 2015-05-06 14:00:00 | IWM | ETF | 120.69 | 120.84 | 120.24 | 120.39 | 4204733.0 |
| 2015-05-06 15:00:00 | IWM | ETF | 120.39 | 121.26 | 120.355 | 121.26 | 5192643.0 |
| 2015-05-06 16:00:00 | IWM | ETF | 121.25 | 121.37 | 121.19 | 121.27 | 1758153.0 |
| 2015-05-06 17:00:00 | IWM | ETF | 121.27 | 121.3 | 121.24 | 121.26 | 40728.0 |
| 2015-05-06 18:00:00 | IWM | ETF | 121.26 | 121.26 | 121.11 | 121.26 | 8351.0 |
| 2015-05-06 19:00:00 | IWM | ETF | 121.24 | 121.24 | 121.24 | 121.24 | 100.0 |
| 2015-05-06 07:00:00 | DIA | ETF | 179.62 | 179.7 | 179.6 | 179.7 | 1200.0 |
| 2015-05-06 08:00:00 | DIA | ETF | 179.9 | 179.9 | 179.6 | 179.89 | 779.0 |
| 2015-05-06 09:00:00 | DIA | ETF | 179.85 | 180.25 | 178.19 | 178.51 | 1523119.0 |
| 2015-05-06 10:00:00 | DIA | ETF | 178.49 | 179.04 | 177.73 | 178.9 | 1470333.0 |
| 2015-05-06 11:00:00 | DIA | ETF | 178.94 | 179.05 | 178.37 | 178.74 | 778356.0 |
| 2015-05-06 12:00:00 | DIA | ETF | 178.75 | 178.758 | 178.08 | 178.18 | 342976.0 |
| 2015-05-06 13:00:00 | DIA | ETF | 178.19 | 178.35 | 177.68 | 177.89 | 511989.0 |
> showing 50 of 7,792 rows — these rows as CSV