PREVIEW / etf_1hour / 2015-11-11
file: by_date/etf_1hour/2015/2015-11-11.parquet size: 235 KB rows: 7,413
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-11 04:00:00 | SPY | ETF | 208.93 | 209.11 | 208.93 | 209.06 | 3045.0 |
| 2015-11-11 05:00:00 | SPY | ETF | 208.99 | 209.04 | 208.84 | 208.86 | 4200.0 |
| 2015-11-11 06:00:00 | SPY | ETF | 208.84 | 209.24 | 208.78 | 209.22 | 86729.0 |
| 2015-11-11 07:00:00 | SPY | ETF | 209.22 | 209.41 | 209.13 | 209.38 | 245396.0 |
| 2015-11-11 08:00:00 | SPY | ETF | 208.9 | 209.42 | 208.9 | 209.16 | 874266.0 |
| 2015-11-11 09:00:00 | SPY | ETF | 209.16 | 209.17 | 208.35 | 208.4 | 10266111.0 |
| 2015-11-11 10:00:00 | SPY | ETF | 208.41 | 208.5 | 207.68 | 207.9801 | 11303050.0 |
| 2015-11-11 11:00:00 | SPY | ETF | 207.99 | 208.46 | 207.79 | 208.38 | 7959968.0 |
| 2015-11-11 12:00:00 | SPY | ETF | 208.38 | 208.94 | 208.29 | 208.71 | 6146792.0 |
| 2015-11-11 13:00:00 | SPY | ETF | 208.71 | 208.72 | 208.01 | 208.13 | 6985040.0 |
| 2015-11-11 14:00:00 | SPY | ETF | 208.13 | 208.47 | 207.84 | 207.84 | 7484140.0 |
| 2015-11-11 15:00:00 | SPY | ETF | 207.84 | 208.07 | 207.66 | 207.71 | 13026535.0 |
| 2015-11-11 16:00:00 | SPY | ETF | 207.71 | 207.818 | 207.51 | 207.6 | 2962508.0 |
| 2015-11-11 17:00:00 | SPY | ETF | 207.53 | 207.61 | 207.52 | 207.54 | 103378.0 |
| 2015-11-11 18:00:00 | SPY | ETF | 207.55 | 207.64 | 207.53 | 207.61 | 64208.0 |
| 2015-11-11 19:00:00 | SPY | ETF | 207.61 | 207.71 | 207.55 | 207.71 | 44820.0 |
| 2015-11-11 04:00:00 | QQQ | ETF | 113.58 | 113.7 | 113.58 | 113.67 | 3199.0 |
| 2015-11-11 05:00:00 | QQQ | ETF | 113.6 | 113.62 | 113.6 | 113.62 | 11000.0 |
| 2015-11-11 06:00:00 | QQQ | ETF | 113.61 | 113.69 | 113.58 | 113.69 | 1400.0 |
| 2015-11-11 07:00:00 | QQQ | ETF | 113.73 | 113.81 | 113.65 | 113.81 | 16870.0 |
| 2015-11-11 08:00:00 | QQQ | ETF | 113.81 | 114.4 | 113.65 | 113.71 | 372603.0 |
| 2015-11-11 09:00:00 | QQQ | ETF | 113.7 | 113.7 | 113.17 | 113.21 | 3427372.0 |
| 2015-11-11 10:00:00 | QQQ | ETF | 113.21 | 113.3654 | 112.95 | 113.15 | 2673236.0 |
| 2015-11-11 11:00:00 | QQQ | ETF | 113.16 | 113.6 | 113.0275 | 113.57 | 2089027.0 |
| 2015-11-11 12:00:00 | QQQ | ETF | 113.57 | 114.14 | 113.52 | 113.97 | 4058675.0 |
| 2015-11-11 13:00:00 | QQQ | ETF | 113.97 | 113.98 | 113.46 | 113.51 | 1806214.0 |
| 2015-11-11 14:00:00 | QQQ | ETF | 113.5099 | 113.75 | 113.29 | 113.29 | 2211566.0 |
| 2015-11-11 15:00:00 | QQQ | ETF | 113.285 | 113.365 | 113.08 | 113.11 | 4190099.0 |
| 2015-11-11 16:00:00 | QQQ | ETF | 113.12 | 113.15 | 113.03 | 113.05 | 190374.0 |
| 2015-11-11 17:00:00 | QQQ | ETF | 113.14 | 113.14 | 113.08 | 113.08 | 1537.0 |
| 2015-11-11 18:00:00 | QQQ | ETF | 113.11 | 113.11 | 113.05 | 113.08 | 9347.0 |
| 2015-11-11 19:00:00 | QQQ | ETF | 113.1 | 113.14 | 113.04 | 113.14 | 50856.0 |
| 2015-11-11 04:00:00 | IWM | ETF | 118.47 | 118.59 | 118.47 | 118.59 | 200.0 |
| 2015-11-11 07:00:00 | IWM | ETF | 118.7 | 119.03 | 118.64 | 118.64 | 2600.0 |
| 2015-11-11 08:00:00 | IWM | ETF | 118.7 | 118.75 | 118.5 | 118.57 | 211316.0 |
| 2015-11-11 09:00:00 | IWM | ETF | 118.49 | 118.49 | 117.9263 | 117.99 | 1868970.0 |
| 2015-11-11 10:00:00 | IWM | ETF | 117.99 | 118.03 | 117.34 | 117.46 | 3283607.0 |
| 2015-11-11 11:00:00 | IWM | ETF | 117.47 | 118.0532 | 117.325 | 118.04 | 2312354.0 |
| 2015-11-11 12:00:00 | IWM | ETF | 118.05 | 118.25 | 117.8 | 117.86 | 2271204.0 |
| 2015-11-11 13:00:00 | IWM | ETF | 117.86 | 117.86 | 117.17 | 117.32 | 2932478.0 |
| 2015-11-11 14:00:00 | IWM | ETF | 117.32 | 117.68 | 117.25 | 117.2601 | 2253373.0 |
| 2015-11-11 15:00:00 | IWM | ETF | 117.26 | 117.39 | 117.08 | 117.12 | 3994436.0 |
| 2015-11-11 16:00:00 | IWM | ETF | 117.14 | 117.2391 | 117.0 | 117.02 | 625878.0 |
| 2015-11-11 17:00:00 | IWM | ETF | 117.01 | 117.04 | 116.99 | 116.99 | 1309.0 |
| 2015-11-11 18:00:00 | IWM | ETF | 117.1 | 117.1 | 117.1 | 117.1 | 200.0 |
| 2015-11-11 19:00:00 | IWM | ETF | 117.04 | 117.1 | 117.04 | 117.1 | 700.0 |
| 2015-11-11 06:00:00 | DIA | ETF | 178.1 | 178.2 | 178.1 | 178.2 | 1500.0 |
| 2015-11-11 07:00:00 | DIA | ETF | 178.37 | 178.52 | 178.37 | 178.52 | 200.0 |
| 2015-11-11 08:00:00 | DIA | ETF | 178.46 | 178.48 | 178.39 | 178.4 | 600.0 |
| 2015-11-11 09:00:00 | DIA | ETF | 178.33 | 178.3465 | 177.7 | 177.75 | 467351.0 |
> showing 50 of 7,413 rows — these rows as CSV