PREVIEW / etf_1hour / 2017-01-17
file: by_date/etf_1hour/2017/2017-01-17.parquet size: 281 KB rows: 9,126
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-01-17 04:00:00 | SPY | ETF | 226.64 | 226.64 | 226.3 | 226.4 | 6978.0 |
| 2017-01-17 05:00:00 | SPY | ETF | 226.35 | 226.37 | 226.0 | 226.01 | 18116.0 |
| 2017-01-17 06:00:00 | SPY | ETF | 226.08 | 226.25 | 225.82 | 226.16 | 52830.0 |
| 2017-01-17 07:00:00 | SPY | ETF | 226.18 | 226.69 | 226.17 | 226.65 | 146443.0 |
| 2017-01-17 08:00:00 | SPY | ETF | 226.66 | 226.68 | 226.19 | 226.52 | 440692.0 |
| 2017-01-17 09:00:00 | SPY | ETF | 226.51 | 226.52 | 226.07 | 226.17 | 7603586.0 |
| 2017-01-17 10:00:00 | SPY | ETF | 226.17 | 226.78 | 226.07 | 226.715 | 6855292.0 |
| 2017-01-17 11:00:00 | SPY | ETF | 226.72 | 226.73 | 226.29 | 226.61 | 4776266.0 |
| 2017-01-17 12:00:00 | SPY | ETF | 226.6 | 226.7 | 226.39 | 226.505 | 4458897.0 |
| 2017-01-17 13:00:00 | SPY | ETF | 226.51 | 226.72 | 226.48 | 226.61 | 3908984.0 |
| 2017-01-17 14:00:00 | SPY | ETF | 226.6 | 226.66 | 225.85 | 226.0173 | 9088893.0 |
| 2017-01-17 15:00:00 | SPY | ETF | 226.02 | 226.34 | 225.8 | 226.29 | 14654420.0 |
| 2017-01-17 16:00:00 | SPY | ETF | 226.29 | 226.35 | 226.2 | 226.27 | 6494378.0 |
| 2017-01-17 17:00:00 | SPY | ETF | 226.28 | 226.28 | 226.21 | 226.27 | 563611.0 |
| 2017-01-17 18:00:00 | SPY | ETF | 226.27 | 226.33 | 226.18 | 226.33 | 83138.0 |
| 2017-01-17 19:00:00 | SPY | ETF | 226.32 | 226.35 | 226.24 | 226.26 | 43330.0 |
| 2017-01-17 04:00:00 | QQQ | ETF | 123.0 | 123.0 | 122.87 | 122.93 | 1162.0 |
| 2017-01-17 05:00:00 | QQQ | ETF | 122.85 | 122.85 | 122.69 | 122.69 | 3747.0 |
| 2017-01-17 06:00:00 | QQQ | ETF | 122.67 | 122.78 | 122.56 | 122.71 | 8492.0 |
| 2017-01-17 07:00:00 | QQQ | ETF | 122.82 | 122.99 | 122.81 | 122.94 | 17080.0 |
| 2017-01-17 08:00:00 | QQQ | ETF | 122.95 | 123.0 | 122.8 | 122.96 | 126289.0 |
| 2017-01-17 09:00:00 | QQQ | ETF | 122.93 | 122.93 | 122.4342 | 122.5843 | 3308987.0 |
| 2017-01-17 10:00:00 | QQQ | ETF | 122.59 | 123.015 | 122.54 | 123.01 | 2004236.0 |
| 2017-01-17 11:00:00 | QQQ | ETF | 123.01 | 123.03 | 122.7427 | 122.95 | 1412991.0 |
| 2017-01-17 12:00:00 | QQQ | ETF | 122.94 | 122.95 | 122.745 | 122.788 | 866164.0 |
| 2017-01-17 13:00:00 | QQQ | ETF | 122.79 | 122.93 | 122.7401 | 122.855 | 788468.0 |
| 2017-01-17 14:00:00 | QQQ | ETF | 122.8508 | 122.955 | 122.53 | 122.65 | 1445657.0 |
| 2017-01-17 15:00:00 | QQQ | ETF | 122.6461 | 122.8 | 122.5 | 122.8 | 2784439.0 |
| 2017-01-17 16:00:00 | QQQ | ETF | 122.82 | 122.94 | 122.75 | 122.8 | 580785.0 |
| 2017-01-17 17:00:00 | QQQ | ETF | 122.76 | 122.76 | 122.76 | 122.76 | 600.0 |
| 2017-01-17 18:00:00 | QQQ | ETF | 122.78 | 122.82 | 122.75 | 122.82 | 2385.0 |
| 2017-01-17 19:00:00 | QQQ | ETF | 122.85 | 122.86 | 122.72 | 122.75 | 21549.0 |
| 2017-01-17 04:00:00 | IWM | ETF | 135.95 | 135.95 | 135.84 | 135.84 | 2000.0 |
| 2017-01-17 05:00:00 | IWM | ETF | 135.78 | 135.78 | 135.67 | 135.68 | 1582.0 |
| 2017-01-17 06:00:00 | IWM | ETF | 135.54 | 135.54 | 135.35 | 135.35 | 3300.0 |
| 2017-01-17 07:00:00 | IWM | ETF | 135.54 | 135.84 | 135.54 | 135.81 | 62280.0 |
| 2017-01-17 08:00:00 | IWM | ETF | 135.81 | 135.81 | 135.57 | 135.76 | 101148.0 |
| 2017-01-17 09:00:00 | IWM | ETF | 135.77 | 135.78 | 134.68 | 134.89 | 4506472.0 |
| 2017-01-17 10:00:00 | IWM | ETF | 134.89 | 135.51 | 134.73 | 135.122 | 3246552.0 |
| 2017-01-17 11:00:00 | IWM | ETF | 135.13 | 135.17 | 134.74 | 135.11 | 2401520.0 |
| 2017-01-17 12:00:00 | IWM | ETF | 135.1 | 135.14 | 134.83 | 134.99 | 1783982.0 |
| 2017-01-17 13:00:00 | IWM | ETF | 134.99 | 135.07 | 134.68 | 134.83 | 1763595.0 |
| 2017-01-17 14:00:00 | IWM | ETF | 134.83 | 134.8775 | 134.235 | 134.38 | 2961652.0 |
| 2017-01-17 15:00:00 | IWM | ETF | 134.37 | 134.45 | 134.13 | 134.37 | 5762897.0 |
| 2017-01-17 16:00:00 | IWM | ETF | 134.41 | 134.47 | 134.2751 | 134.45 | 3932297.0 |
| 2017-01-17 17:00:00 | IWM | ETF | 134.43 | 134.43 | 134.43 | 134.43 | 7163.0 |
| 2017-01-17 18:00:00 | IWM | ETF | 134.47 | 134.47 | 134.47 | 134.47 | 200.0 |
| 2017-01-17 19:00:00 | IWM | ETF | 134.47 | 134.47 | 134.47 | 134.47 | 700.0 |
| 2017-01-17 04:00:00 | DIA | ETF | 198.21 | 198.21 | 198.21 | 198.21 | 122.0 |
| 2017-01-17 05:00:00 | DIA | ETF | 198.28 | 198.28 | 198.0 | 198.0 | 894.0 |
> showing 50 of 9,126 rows — these rows as CSV