PREVIEW / etf_1hour / 2015-07-09
file: by_date/etf_1hour/2015/2015-07-09.parquet size: 252 KB rows: 8,087
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-09 04:00:00 | SPY | ETF | 205.04 | 206.12 | 205.04 | 206.09 | 33305.0 |
| 2015-07-09 05:00:00 | SPY | ETF | 206.02 | 206.51 | 205.97 | 206.4 | 77815.0 |
| 2015-07-09 06:00:00 | SPY | ETF | 206.4 | 206.69 | 206.35 | 206.54 | 184675.0 |
| 2015-07-09 07:00:00 | SPY | ETF | 206.5 | 206.74 | 206.46 | 206.6 | 562809.0 |
| 2015-07-09 08:00:00 | SPY | ETF | 206.6 | 206.86 | 205.41 | 206.82 | 1287196.0 |
| 2015-07-09 09:00:00 | SPY | ETF | 206.82 | 207.35 | 206.57 | 206.81 | 22397889.0 |
| 2015-07-09 10:00:00 | SPY | ETF | 206.81 | 206.94 | 205.9301 | 206.55 | 21177486.0 |
| 2015-07-09 11:00:00 | SPY | ETF | 206.55 | 206.79 | 205.98 | 206.01 | 12741670.0 |
| 2015-07-09 12:00:00 | SPY | ETF | 205.99 | 206.18 | 205.68 | 205.909 | 11919608.0 |
| 2015-07-09 13:00:00 | SPY | ETF | 205.9 | 205.97 | 205.34 | 205.66 | 11943753.0 |
| 2015-07-09 14:00:00 | SPY | ETF | 205.66 | 205.69 | 204.89 | 205.535 | 22346366.0 |
| 2015-07-09 15:00:00 | SPY | ETF | 205.54 | 206.529 | 204.88 | 204.89 | 27624357.0 |
| 2015-07-09 16:00:00 | SPY | ETF | 204.85 | 205.4071 | 204.38 | 204.71 | 6562958.0 |
| 2015-07-09 17:00:00 | SPY | ETF | 204.71 | 205.0 | 204.63 | 205.0 | 305771.0 |
| 2015-07-09 18:00:00 | SPY | ETF | 205.01 | 206.7 | 205.01 | 206.67 | 2271537.0 |
| 2015-07-09 19:00:00 | SPY | ETF | 206.62 | 206.69 | 206.17 | 206.25 | 362334.0 |
| 2015-07-09 04:00:00 | QQQ | ETF | 106.76 | 107.08 | 106.76 | 106.88 | 1791.0 |
| 2015-07-09 05:00:00 | QQQ | ETF | 107.03 | 107.03 | 107.03 | 107.03 | 500.0 |
| 2015-07-09 06:00:00 | QQQ | ETF | 107.05 | 107.37 | 107.05 | 107.37 | 18250.0 |
| 2015-07-09 07:00:00 | QQQ | ETF | 107.26 | 107.34 | 107.25 | 107.32 | 83128.0 |
| 2015-07-09 08:00:00 | QQQ | ETF | 107.3 | 107.39 | 107.28 | 107.35 | 184544.0 |
| 2015-07-09 09:00:00 | QQQ | ETF | 107.02 | 107.62 | 107.02 | 107.33 | 4969061.0 |
| 2015-07-09 10:00:00 | QQQ | ETF | 107.33 | 107.42 | 106.89 | 107.2 | 3892088.0 |
| 2015-07-09 11:00:00 | QQQ | ETF | 107.2 | 107.35 | 106.85 | 106.87 | 2486417.0 |
| 2015-07-09 12:00:00 | QQQ | ETF | 106.86 | 106.99 | 106.771 | 106.89 | 2259229.0 |
| 2015-07-09 13:00:00 | QQQ | ETF | 106.88 | 106.9166 | 106.49 | 106.61 | 2173280.0 |
| 2015-07-09 14:00:00 | QQQ | ETF | 106.61 | 106.66 | 106.02 | 106.4 | 3762226.0 |
| 2015-07-09 15:00:00 | QQQ | ETF | 106.4 | 106.56 | 106.03 | 106.03 | 4069609.0 |
| 2015-07-09 16:00:00 | QQQ | ETF | 106.03 | 106.1 | 105.78 | 105.98 | 745676.0 |
| 2015-07-09 17:00:00 | QQQ | ETF | 105.98 | 106.03 | 105.87 | 106.03 | 979830.0 |
| 2015-07-09 18:00:00 | QQQ | ETF | 106.03 | 106.95 | 106.03 | 106.92 | 119217.0 |
| 2015-07-09 19:00:00 | QQQ | ETF | 106.91 | 106.95 | 106.67 | 106.75 | 28805.0 |
| 2015-07-09 06:00:00 | IWM | ETF | 123.0 | 123.27 | 123.0 | 123.27 | 5500.0 |
| 2015-07-09 07:00:00 | IWM | ETF | 123.17 | 123.27 | 123.15 | 123.21 | 39569.0 |
| 2015-07-09 08:00:00 | IWM | ETF | 123.23 | 123.43 | 123.15 | 123.43 | 222651.0 |
| 2015-07-09 09:00:00 | IWM | ETF | 123.44 | 123.59 | 122.95 | 123.19 | 6245125.0 |
| 2015-07-09 10:00:00 | IWM | ETF | 123.19 | 123.39 | 122.63 | 123.1 | 4680714.0 |
| 2015-07-09 11:00:00 | IWM | ETF | 123.1 | 123.36 | 122.89 | 122.89 | 2222329.0 |
| 2015-07-09 12:00:00 | IWM | ETF | 122.89 | 122.98 | 122.75 | 122.93 | 1576789.0 |
| 2015-07-09 13:00:00 | IWM | ETF | 122.916 | 122.95 | 122.5 | 122.75 | 1755030.0 |
| 2015-07-09 14:00:00 | IWM | ETF | 122.74 | 122.77 | 122.2701 | 122.67 | 2742371.0 |
| 2015-07-09 15:00:00 | IWM | ETF | 122.67 | 122.86 | 122.44 | 122.45 | 4252722.0 |
| 2015-07-09 16:00:00 | IWM | ETF | 122.44 | 122.5 | 121.98 | 122.15 | 2557578.0 |
| 2015-07-09 17:00:00 | IWM | ETF | 122.19 | 122.4153 | 122.16 | 122.37 | 174019.0 |
| 2015-07-09 18:00:00 | IWM | ETF | 122.4 | 123.24 | 122.4 | 123.24 | 52116.0 |
| 2015-07-09 19:00:00 | IWM | ETF | 123.37 | 123.37 | 123.0 | 123.0 | 900.0 |
| 2015-07-09 04:00:00 | DIA | ETF | 176.06 | 176.06 | 176.06 | 176.06 | 200.0 |
| 2015-07-09 06:00:00 | DIA | ETF | 176.45 | 176.7 | 176.45 | 176.65 | 1445.0 |
| 2015-07-09 07:00:00 | DIA | ETF | 176.7 | 176.7 | 176.68 | 176.68 | 3000.0 |
| 2015-07-09 08:00:00 | DIA | ETF | 176.65 | 176.95 | 176.52 | 176.94 | 28287.0 |
> showing 50 of 8,087 rows — these rows as CSV