PREVIEW / etf_1hour / 2015-11-24
file: by_date/etf_1hour/2015/2015-11-24.parquet size: 244 KB rows: 7,753
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-11-24 04:00:00 | SPY | ETF | 208.03 | 208.49 | 207.31 | 208.34 | 50354.0 |
| 2015-11-24 05:00:00 | SPY | ETF | 208.39 | 208.62 | 208.05 | 208.16 | 35337.0 |
| 2015-11-24 06:00:00 | SPY | ETF | 208.08 | 208.44 | 207.95 | 208.21 | 112894.0 |
| 2015-11-24 07:00:00 | SPY | ETF | 208.16 | 208.32 | 207.55 | 207.72 | 1088799.0 |
| 2015-11-24 08:00:00 | SPY | ETF | 209.48 | 209.48 | 207.42 | 207.78 | 1538073.0 |
| 2015-11-24 09:00:00 | SPY | ETF | 207.77 | 208.55 | 207.76 | 208.37 | 11558058.0 |
| 2015-11-24 10:00:00 | SPY | ETF | 208.3701 | 208.51 | 207.41 | 207.65 | 14553109.0 |
| 2015-11-24 11:00:00 | SPY | ETF | 207.65 | 208.95 | 207.52 | 208.829 | 13097703.0 |
| 2015-11-24 12:00:00 | SPY | ETF | 208.83 | 209.13 | 208.72 | 208.89 | 7451530.0 |
| 2015-11-24 13:00:00 | SPY | ETF | 208.89 | 209.59 | 208.89 | 209.43 | 11489905.0 |
| 2015-11-24 14:00:00 | SPY | ETF | 209.42 | 209.76 | 209.085 | 209.545 | 13490667.0 |
| 2015-11-24 15:00:00 | SPY | ETF | 209.55 | 209.83 | 209.2 | 209.38 | 17562874.0 |
| 2015-11-24 16:00:00 | SPY | ETF | 209.38 | 209.4881 | 209.08 | 209.08 | 3178001.0 |
| 2015-11-24 17:00:00 | SPY | ETF | 209.11 | 209.18 | 209.07 | 209.11 | 255607.0 |
| 2015-11-24 18:00:00 | SPY | ETF | 209.1 | 209.32 | 209.1 | 209.31 | 78578.0 |
| 2015-11-24 19:00:00 | SPY | ETF | 209.3 | 209.31 | 209.11 | 209.11 | 66009.0 |
| 2015-11-24 04:00:00 | QQQ | ETF | 113.42 | 113.7 | 113.22 | 113.62 | 5373.0 |
| 2015-11-24 05:00:00 | QQQ | ETF | 113.8 | 113.8 | 113.57 | 113.57 | 600.0 |
| 2015-11-24 06:00:00 | QQQ | ETF | 113.54 | 113.7 | 113.5 | 113.6 | 5435.0 |
| 2015-11-24 07:00:00 | QQQ | ETF | 113.72 | 113.74 | 113.28 | 113.36 | 30340.0 |
| 2015-11-24 08:00:00 | QQQ | ETF | 113.37 | 113.65 | 113.24 | 113.37 | 133508.0 |
| 2015-11-24 09:00:00 | QQQ | ETF | 113.39 | 113.78 | 113.32 | 113.74 | 4194267.0 |
| 2015-11-24 10:00:00 | QQQ | ETF | 113.74 | 113.82 | 112.8377 | 113.0675 | 5340549.0 |
| 2015-11-24 11:00:00 | QQQ | ETF | 113.07 | 113.87 | 112.9 | 113.8 | 4611081.0 |
| 2015-11-24 12:00:00 | QQQ | ETF | 113.81 | 114.02 | 113.58 | 113.73 | 2592890.0 |
| 2015-11-24 13:00:00 | QQQ | ETF | 113.73 | 114.17 | 113.73 | 114.09 | 2199328.0 |
| 2015-11-24 14:00:00 | QQQ | ETF | 114.09 | 114.32 | 113.81 | 114.1078 | 1870776.0 |
| 2015-11-24 15:00:00 | QQQ | ETF | 114.105 | 114.23 | 113.86 | 114.06 | 3382731.0 |
| 2015-11-24 16:00:00 | QQQ | ETF | 114.07 | 114.07 | 113.6732 | 113.94 | 429811.0 |
| 2015-11-24 17:00:00 | QQQ | ETF | 113.94 | 114.0 | 113.9 | 113.9 | 5408.0 |
| 2015-11-24 18:00:00 | QQQ | ETF | 113.93 | 114.05 | 113.93 | 114.05 | 11443.0 |
| 2015-11-24 19:00:00 | QQQ | ETF | 113.98 | 113.98 | 113.92 | 113.92 | 4372.0 |
| 2015-11-24 04:00:00 | IWM | ETF | 116.86 | 116.86 | 116.34 | 116.34 | 230.0 |
| 2015-11-24 07:00:00 | IWM | ETF | 116.53 | 116.83 | 116.52 | 116.7 | 6800.0 |
| 2015-11-24 08:00:00 | IWM | ETF | 116.72 | 116.84 | 116.56 | 116.77 | 110615.0 |
| 2015-11-24 09:00:00 | IWM | ETF | 116.77 | 117.3 | 116.76 | 117.14 | 2183113.0 |
| 2015-11-24 10:00:00 | IWM | ETF | 117.12 | 117.3026 | 116.56 | 116.825 | 4409348.0 |
| 2015-11-24 11:00:00 | IWM | ETF | 116.83 | 117.62 | 116.6428 | 117.48 | 3666113.0 |
| 2015-11-24 12:00:00 | IWM | ETF | 117.48 | 117.7 | 117.26 | 117.4575 | 1503526.0 |
| 2015-11-24 13:00:00 | IWM | ETF | 117.46 | 118.16 | 117.455 | 117.985 | 3599792.0 |
| 2015-11-24 14:00:00 | IWM | ETF | 117.985 | 118.2 | 117.78 | 118.16 | 2095397.0 |
| 2015-11-24 15:00:00 | IWM | ETF | 118.16 | 118.42 | 118.08 | 118.23 | 4365089.0 |
| 2015-11-24 16:00:00 | IWM | ETF | 118.24 | 118.26 | 118.1 | 118.17 | 1302438.0 |
| 2015-11-24 17:00:00 | IWM | ETF | 118.16 | 118.25 | 118.16 | 118.17 | 32514.0 |
| 2015-11-24 18:00:00 | IWM | ETF | 118.17 | 118.17 | 118.17 | 118.17 | 100.0 |
| 2015-11-24 19:00:00 | IWM | ETF | 118.3 | 118.3 | 118.3 | 118.3 | 100.0 |
| 2015-11-24 07:00:00 | DIA | ETF | 177.03 | 177.03 | 176.58 | 176.65 | 2600.0 |
| 2015-11-24 08:00:00 | DIA | ETF | 176.68 | 176.73 | 176.42 | 176.58 | 2890.0 |
| 2015-11-24 09:00:00 | DIA | ETF | 176.71 | 177.42 | 176.65 | 177.31 | 649384.0 |
| 2015-11-24 10:00:00 | DIA | ETF | 177.26 | 177.37 | 176.61 | 176.77 | 612742.0 |
> showing 50 of 7,753 rows — these rows as CSV