PREVIEW / etf_1hour / 2015-05-12
file: by_date/etf_1hour/2015/2015-05-12.parquet size: 240 KB rows: 7,648
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-12 04:00:00 | SPY | ETF | 209.83 | 209.83 | 208.87 | 208.9 | 43933.0 |
| 2015-05-12 05:00:00 | SPY | ETF | 208.87 | 209.04 | 208.52 | 208.9 | 194122.0 |
| 2015-05-12 06:00:00 | SPY | ETF | 209.01 | 209.14 | 208.74 | 208.78 | 270323.0 |
| 2015-05-12 07:00:00 | SPY | ETF | 208.8 | 209.24 | 208.59 | 209.03 | 1254047.0 |
| 2015-05-12 08:00:00 | SPY | ETF | 208.71 | 210.0 | 208.61 | 209.375 | 2249344.0 |
| 2015-05-12 09:00:00 | SPY | ETF | 209.36 | 209.68 | 208.62 | 209.05 | 22448752.0 |
| 2015-05-12 10:00:00 | SPY | ETF | 209.04 | 210.19 | 208.74 | 209.7799 | 24302953.0 |
| 2015-05-12 11:00:00 | SPY | ETF | 209.775 | 210.28 | 209.75 | 210.02 | 12389378.0 |
| 2015-05-12 12:00:00 | SPY | ETF | 210.015 | 210.28 | 209.58 | 210.12 | 8195461.0 |
| 2015-05-12 13:00:00 | SPY | ETF | 210.12 | 210.49 | 209.925 | 210.1 | 9564996.0 |
| 2015-05-12 14:00:00 | SPY | ETF | 210.09 | 210.63 | 209.93 | 210.19 | 10360395.0 |
| 2015-05-12 15:00:00 | SPY | ETF | 210.19 | 210.3999 | 209.96 | 209.96 | 14815485.0 |
| 2015-05-12 16:00:00 | SPY | ETF | 209.97 | 210.24 | 209.1806 | 210.15 | 11948045.0 |
| 2015-05-12 17:00:00 | SPY | ETF | 210.12 | 210.24 | 209.98 | 210.19 | 53978.0 |
| 2015-05-12 18:00:00 | SPY | ETF | 210.23 | 210.36 | 209.98 | 210.36 | 51515.0 |
| 2015-05-12 19:00:00 | SPY | ETF | 210.34 | 210.4 | 210.27 | 210.38 | 15832.0 |
| 2015-05-12 04:00:00 | QQQ | ETF | 107.86 | 107.86 | 107.31 | 107.34 | 4485.0 |
| 2015-05-12 05:00:00 | QQQ | ETF | 107.21 | 107.35 | 107.11 | 107.3 | 46596.0 |
| 2015-05-12 06:00:00 | QQQ | ETF | 107.33 | 107.37 | 107.2 | 107.31 | 33380.0 |
| 2015-05-12 07:00:00 | QQQ | ETF | 107.27 | 107.48 | 107.13 | 107.32 | 173943.0 |
| 2015-05-12 08:00:00 | QQQ | ETF | 107.35 | 107.48 | 107.27 | 107.43 | 150414.0 |
| 2015-05-12 09:00:00 | QQQ | ETF | 107.43 | 107.65 | 106.8 | 107.11 | 5530585.0 |
| 2015-05-12 10:00:00 | QQQ | ETF | 107.11 | 107.85 | 106.97 | 107.655 | 5849932.0 |
| 2015-05-12 11:00:00 | QQQ | ETF | 107.66 | 108.02 | 107.66 | 107.84 | 2161765.0 |
| 2015-05-12 12:00:00 | QQQ | ETF | 107.84 | 108.1 | 107.6 | 108.0 | 1894331.0 |
| 2015-05-12 13:00:00 | QQQ | ETF | 108.01 | 108.29 | 107.9 | 108.03 | 2077678.0 |
| 2015-05-12 14:00:00 | QQQ | ETF | 108.029 | 108.33 | 107.93 | 108.0 | 2322477.0 |
| 2015-05-12 15:00:00 | QQQ | ETF | 108.01 | 108.07 | 107.78 | 107.8 | 6729914.0 |
| 2015-05-12 16:00:00 | QQQ | ETF | 107.8 | 107.97 | 107.75 | 107.93 | 1825843.0 |
| 2015-05-12 17:00:00 | QQQ | ETF | 107.93 | 107.97 | 107.93 | 107.95 | 9750.0 |
| 2015-05-12 18:00:00 | QQQ | ETF | 107.95 | 108.03 | 107.93 | 108.02 | 10250.0 |
| 2015-05-12 19:00:00 | QQQ | ETF | 108.031 | 108.05 | 108.0 | 108.05 | 15600.0 |
| 2015-05-12 04:00:00 | IWM | ETF | 122.3 | 122.3 | 121.8 | 121.8 | 2200.0 |
| 2015-05-12 05:00:00 | IWM | ETF | 121.71 | 121.74 | 121.7 | 121.74 | 300.0 |
| 2015-05-12 06:00:00 | IWM | ETF | 121.75 | 121.75 | 121.71 | 121.71 | 6600.0 |
| 2015-05-12 07:00:00 | IWM | ETF | 121.91 | 121.92 | 121.6 | 121.82 | 122574.0 |
| 2015-05-12 08:00:00 | IWM | ETF | 121.85 | 122.08 | 121.64 | 122.05 | 195688.0 |
| 2015-05-12 09:00:00 | IWM | ETF | 122.05 | 122.46 | 120.98 | 121.055 | 5569071.0 |
| 2015-05-12 10:00:00 | IWM | ETF | 121.05 | 122.3 | 120.87 | 122.15 | 5472583.0 |
| 2015-05-12 11:00:00 | IWM | ETF | 122.16 | 122.6 | 121.99 | 122.13 | 3167426.0 |
| 2015-05-12 12:00:00 | IWM | ETF | 122.13 | 122.46 | 121.8575 | 122.32 | 1717735.0 |
| 2015-05-12 13:00:00 | IWM | ETF | 122.33 | 122.79 | 122.26 | 122.41 | 2048263.0 |
| 2015-05-12 14:00:00 | IWM | ETF | 122.41 | 122.92 | 122.4 | 122.555 | 1812209.0 |
| 2015-05-12 15:00:00 | IWM | ETF | 122.57 | 122.69 | 122.41 | 122.53 | 3591593.0 |
| 2015-05-12 16:00:00 | IWM | ETF | 122.54 | 122.71 | 122.48 | 122.66 | 3135984.0 |
| 2015-05-12 17:00:00 | IWM | ETF | 122.711 | 122.77 | 122.711 | 122.72 | 1335.0 |
| 2015-05-12 18:00:00 | IWM | ETF | 122.95 | 122.95 | 122.75 | 122.75 | 250.0 |
| 2015-05-12 07:00:00 | DIA | ETF | 179.77 | 179.77 | 179.53 | 179.54 | 7201.0 |
| 2015-05-12 08:00:00 | DIA | ETF | 179.65 | 180.0 | 179.59 | 179.97 | 22662.0 |
| 2015-05-12 09:00:00 | DIA | ETF | 179.85 | 180.22 | 179.2698 | 179.69 | 914211.0 |
> showing 50 of 7,648 rows — these rows as CSV