PREVIEW / etf_1hour / 2015-12-30
file: by_date/etf_1hour/2015/2015-12-30.parquet size: 250 KB rows: 8,007
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-12-30 04:00:00 | SPY | ETF | 207.28 | 207.38 | 207.15 | 207.28 | 12399.0 |
| 2015-12-30 05:00:00 | SPY | ETF | 207.38 | 207.39 | 207.33 | 207.33 | 602.0 |
| 2015-12-30 06:00:00 | SPY | ETF | 207.3 | 207.39 | 207.28 | 207.39 | 9215.0 |
| 2015-12-30 07:00:00 | SPY | ETF | 207.4 | 207.44 | 207.14 | 207.17 | 179949.0 |
| 2015-12-30 08:00:00 | SPY | ETF | 207.19 | 207.32 | 207.04 | 207.09 | 241525.0 |
| 2015-12-30 09:00:00 | SPY | ETF | 207.09 | 207.22 | 206.72 | 206.895 | 5689985.0 |
| 2015-12-30 10:00:00 | SPY | ETF | 206.89 | 207.1 | 206.51 | 206.79 | 8830595.0 |
| 2015-12-30 11:00:00 | SPY | ETF | 206.8 | 207.02 | 206.68 | 206.76 | 7017624.0 |
| 2015-12-30 12:00:00 | SPY | ETF | 206.76 | 206.89 | 206.59 | 206.675 | 4484573.0 |
| 2015-12-30 13:00:00 | SPY | ETF | 206.675 | 206.91 | 206.52 | 206.8069 | 5346764.0 |
| 2015-12-30 14:00:00 | SPY | ETF | 206.8001 | 206.92 | 206.59 | 206.6439 | 6093958.0 |
| 2015-12-30 15:00:00 | SPY | ETF | 206.64 | 206.75 | 205.76 | 205.94 | 19395271.0 |
| 2015-12-30 16:00:00 | SPY | ETF | 205.94 | 207.4498 | 205.78 | 205.97 | 5127199.0 |
| 2015-12-30 17:00:00 | SPY | ETF | 205.92 | 206.05 | 205.92 | 205.93 | 19857.0 |
| 2015-12-30 18:00:00 | SPY | ETF | 205.97 | 206.1 | 205.9 | 206.05 | 41101.0 |
| 2015-12-30 19:00:00 | SPY | ETF | 206.09 | 206.14 | 206.04 | 206.06 | 31042.0 |
| 2015-12-30 04:00:00 | QQQ | ETF | 114.1 | 114.22 | 114.1 | 114.15 | 2800.0 |
| 2015-12-30 05:00:00 | QQQ | ETF | 114.24 | 114.24 | 114.22 | 114.22 | 300.0 |
| 2015-12-30 06:00:00 | QQQ | ETF | 114.28 | 114.3 | 114.26 | 114.26 | 900.0 |
| 2015-12-30 07:00:00 | QQQ | ETF | 114.29 | 114.29 | 114.15 | 114.19 | 12167.0 |
| 2015-12-30 08:00:00 | QQQ | ETF | 114.2001 | 114.2001 | 114.12 | 114.14 | 46852.0 |
| 2015-12-30 09:00:00 | QQQ | ETF | 114.18 | 114.24 | 113.67 | 113.72 | 2336320.0 |
| 2015-12-30 10:00:00 | QQQ | ETF | 113.71 | 113.91 | 113.57 | 113.77 | 2744001.0 |
| 2015-12-30 11:00:00 | QQQ | ETF | 113.7722 | 113.905 | 113.64 | 113.76 | 1385401.0 |
| 2015-12-30 12:00:00 | QQQ | ETF | 113.76 | 113.86 | 113.71 | 113.76 | 790833.0 |
| 2015-12-30 13:00:00 | QQQ | ETF | 113.76 | 113.96 | 113.68 | 113.85 | 1139400.0 |
| 2015-12-30 14:00:00 | QQQ | ETF | 113.855 | 113.91 | 113.7 | 113.7461 | 1161358.0 |
| 2015-12-30 15:00:00 | QQQ | ETF | 113.74 | 113.89 | 113.25 | 113.28 | 5151553.0 |
| 2015-12-30 16:00:00 | QQQ | ETF | 113.28 | 113.42 | 113.24 | 113.33 | 549736.0 |
| 2015-12-30 17:00:00 | QQQ | ETF | 113.37 | 113.37 | 113.27 | 113.37 | 225024.0 |
| 2015-12-30 18:00:00 | QQQ | ETF | 113.34 | 113.48 | 113.31 | 113.48 | 14368.0 |
| 2015-12-30 19:00:00 | QQQ | ETF | 113.46 | 113.49 | 113.46 | 113.48 | 8247.0 |
| 2015-12-30 06:00:00 | IWM | ETF | 115.2 | 115.3 | 115.2 | 115.29 | 1200.0 |
| 2015-12-30 07:00:00 | IWM | ETF | 115.2 | 115.22 | 115.18 | 115.18 | 700.0 |
| 2015-12-30 08:00:00 | IWM | ETF | 115.19 | 115.2 | 115.17 | 115.2 | 7301.0 |
| 2015-12-30 09:00:00 | IWM | ETF | 115.2 | 115.35 | 114.82 | 114.985 | 1722510.0 |
| 2015-12-30 10:00:00 | IWM | ETF | 114.975 | 115.13 | 114.46 | 114.86 | 3254617.0 |
| 2015-12-30 11:00:00 | IWM | ETF | 114.86 | 114.985 | 114.72 | 114.82 | 1602077.0 |
| 2015-12-30 12:00:00 | IWM | ETF | 114.82 | 114.96 | 114.485 | 114.6 | 1719287.0 |
| 2015-12-30 13:00:00 | IWM | ETF | 114.595 | 114.675 | 114.26 | 114.44 | 2337208.0 |
| 2015-12-30 14:00:00 | IWM | ETF | 114.44 | 114.62 | 114.34 | 114.45 | 1922258.0 |
| 2015-12-30 15:00:00 | IWM | ETF | 114.4536 | 114.67 | 114.03 | 114.05 | 4523997.0 |
| 2015-12-30 16:00:00 | IWM | ETF | 114.05 | 114.07 | 113.83 | 113.87 | 1295683.0 |
| 2015-12-30 17:00:00 | IWM | ETF | 113.93 | 114.04 | 113.93 | 113.97 | 561106.0 |
| 2015-12-30 18:00:00 | IWM | ETF | 113.95 | 113.95 | 113.9 | 113.9 | 1300.0 |
| 2015-12-30 19:00:00 | IWM | ETF | 113.98 | 114.01 | 113.98 | 114.01 | 300.0 |
| 2015-12-30 07:00:00 | DIA | ETF | 176.66 | 176.66 | 176.54 | 176.54 | 1400.0 |
| 2015-12-30 08:00:00 | DIA | ETF | 176.46 | 176.68 | 176.46 | 176.52 | 11493.0 |
| 2015-12-30 09:00:00 | DIA | ETF | 176.57 | 176.72 | 176.32 | 176.54 | 244808.0 |
| 2015-12-30 10:00:00 | DIA | ETF | 176.54 | 176.72 | 176.3 | 176.54 | 443544.0 |
> showing 50 of 8,007 rows — these rows as CSV