PREVIEW / etf_1hour / 2017-04-26
file: by_date/etf_1hour/2017/2017-04-26.parquet size: 276 KB rows: 8,988
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 |
|---|---|---|---|---|---|---|---|
| 2017-04-26 04:00:00 | SPY | ETF | 238.47 | 238.49 | 238.38 | 238.49 | 7650.0 |
| 2017-04-26 05:00:00 | SPY | ETF | 238.46 | 238.65 | 238.43 | 238.65 | 13265.0 |
| 2017-04-26 06:00:00 | SPY | ETF | 238.67 | 238.72 | 238.53 | 238.53 | 7147.0 |
| 2017-04-26 07:00:00 | SPY | ETF | 238.41 | 238.48 | 238.3 | 238.35 | 145394.0 |
| 2017-04-26 08:00:00 | SPY | ETF | 238.43 | 238.71 | 238.29 | 238.63 | 311555.0 |
| 2017-04-26 09:00:00 | SPY | ETF | 238.63 | 238.84 | 238.5 | 238.7808 | 7239509.0 |
| 2017-04-26 10:00:00 | SPY | ETF | 238.78 | 239.1 | 238.68 | 239.05 | 8087289.0 |
| 2017-04-26 11:00:00 | SPY | ETF | 239.05 | 239.53 | 238.7 | 238.91 | 11279208.0 |
| 2017-04-26 12:00:00 | SPY | ETF | 238.91 | 239.36 | 238.8 | 239.33 | 5919278.0 |
| 2017-04-26 13:00:00 | SPY | ETF | 239.33 | 239.5 | 238.83 | 238.99 | 8672647.0 |
| 2017-04-26 14:00:00 | SPY | ETF | 239.0 | 239.23 | 238.79 | 239.06 | 9309650.0 |
| 2017-04-26 15:00:00 | SPY | ETF | 239.065 | 239.28 | 238.35 | 238.44 | 18540646.0 |
| 2017-04-26 16:00:00 | SPY | ETF | 238.45 | 238.5 | 238.25 | 238.25 | 12466902.0 |
| 2017-04-26 17:00:00 | SPY | ETF | 238.25 | 238.4 | 238.18 | 238.26 | 275481.0 |
| 2017-04-26 18:00:00 | SPY | ETF | 238.26 | 239.3701 | 238.24 | 238.37 | 216713.0 |
| 2017-04-26 19:00:00 | SPY | ETF | 238.37 | 238.54 | 238.37 | 238.44 | 115804.0 |
| 2017-04-26 04:00:00 | QQQ | ETF | 135.18 | 135.23 | 135.16 | 135.23 | 1340.0 |
| 2017-04-26 05:00:00 | QQQ | ETF | 135.21 | 135.21 | 135.21 | 135.21 | 1430.0 |
| 2017-04-26 06:00:00 | QQQ | ETF | 135.28 | 135.28 | 135.28 | 135.28 | 200.0 |
| 2017-04-26 07:00:00 | QQQ | ETF | 135.2 | 135.2 | 135.11 | 135.15 | 11395.0 |
| 2017-04-26 08:00:00 | QQQ | ETF | 135.19 | 135.25 | 135.15 | 135.25 | 66453.0 |
| 2017-04-26 09:00:00 | QQQ | ETF | 135.25 | 135.51 | 135.07 | 135.17 | 4132088.0 |
| 2017-04-26 10:00:00 | QQQ | ETF | 135.16 | 135.23 | 135.02 | 135.17 | 2196679.0 |
| 2017-04-26 11:00:00 | QQQ | ETF | 135.165 | 135.35 | 134.92 | 135.01 | 4942787.0 |
| 2017-04-26 12:00:00 | QQQ | ETF | 135.01 | 135.24 | 134.96 | 135.2 | 1480220.0 |
| 2017-04-26 13:00:00 | QQQ | ETF | 135.2 | 135.34 | 134.99 | 135.06 | 1696989.0 |
| 2017-04-26 14:00:00 | QQQ | ETF | 135.06 | 135.24 | 134.98 | 135.11 | 2156020.0 |
| 2017-04-26 15:00:00 | QQQ | ETF | 135.11 | 135.28 | 134.86 | 134.94 | 4294570.0 |
| 2017-04-26 16:00:00 | QQQ | ETF | 134.94 | 134.97 | 134.82 | 134.84 | 2689313.0 |
| 2017-04-26 17:00:00 | QQQ | ETF | 134.9 | 134.9 | 134.82 | 134.83 | 32420.0 |
| 2017-04-26 18:00:00 | QQQ | ETF | 134.85 | 134.93 | 134.83 | 134.92 | 11836.0 |
| 2017-04-26 19:00:00 | QQQ | ETF | 134.93 | 135.01 | 134.93 | 134.95 | 3835.0 |
| 2017-04-26 04:00:00 | IWM | ETF | 140.21 | 140.21 | 140.11 | 140.15 | 2000.0 |
| 2017-04-26 05:00:00 | IWM | ETF | 140.25 | 140.35 | 140.25 | 140.35 | 2200.0 |
| 2017-04-26 06:00:00 | IWM | ETF | 140.36 | 140.37 | 140.17 | 140.17 | 7669.0 |
| 2017-04-26 07:00:00 | IWM | ETF | 140.17 | 140.19 | 139.98 | 139.98 | 19176.0 |
| 2017-04-26 08:00:00 | IWM | ETF | 140.19 | 140.46 | 140.02 | 140.21 | 97717.0 |
| 2017-04-26 09:00:00 | IWM | ETF | 140.25 | 140.65 | 140.1 | 140.45 | 3082140.0 |
| 2017-04-26 10:00:00 | IWM | ETF | 140.45 | 141.15 | 140.31 | 141.075 | 4042988.0 |
| 2017-04-26 11:00:00 | IWM | ETF | 141.06 | 141.74 | 140.88 | 141.35 | 5877956.0 |
| 2017-04-26 12:00:00 | IWM | ETF | 141.34 | 141.67 | 141.19 | 141.64 | 2541835.0 |
| 2017-04-26 13:00:00 | IWM | ETF | 141.64 | 141.805 | 141.24 | 141.31 | 3246182.0 |
| 2017-04-26 14:00:00 | IWM | ETF | 141.32 | 141.76 | 141.1 | 141.59 | 3669612.0 |
| 2017-04-26 15:00:00 | IWM | ETF | 141.59 | 141.8166 | 140.98 | 141.0 | 6062980.0 |
| 2017-04-26 16:00:00 | IWM | ETF | 140.99 | 141.0836 | 140.256 | 140.85 | 4532955.0 |
| 2017-04-26 17:00:00 | IWM | ETF | 140.86 | 141.09 | 140.84 | 140.9 | 32758.0 |
| 2017-04-26 18:00:00 | IWM | ETF | 140.9 | 141.03 | 140.9 | 141.03 | 7988.0 |
| 2017-04-26 19:00:00 | IWM | ETF | 141.07 | 141.13 | 141.07 | 141.13 | 3175.0 |
| 2017-04-26 05:00:00 | DIA | ETF | 209.97 | 210.01 | 209.97 | 210.01 | 1000.0 |
| 2017-04-26 06:00:00 | DIA | ETF | 210.13 | 210.13 | 210.1 | 210.1 | 700.0 |
> showing 50 of 8,988 rows — these rows as CSV