PREVIEW / etf_1hour / 2017-01-12
file: by_date/etf_1hour/2017/2017-01-12.parquet size: 274 KB rows: 8,820
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-12 04:00:00 | SPY | ETF | 226.3 | 226.47 | 226.12 | 226.45 | 11985.0 |
| 2017-01-12 05:00:00 | SPY | ETF | 226.43 | 226.54 | 226.39 | 226.41 | 6409.0 |
| 2017-01-12 06:00:00 | SPY | ETF | 226.44 | 226.58 | 226.41 | 226.51 | 96787.0 |
| 2017-01-12 07:00:00 | SPY | ETF | 226.48 | 226.63 | 226.41 | 226.61 | 118963.0 |
| 2017-01-12 08:00:00 | SPY | ETF | 226.58 | 226.66 | 226.45 | 226.56 | 322045.0 |
| 2017-01-12 09:00:00 | SPY | ETF | 226.6 | 226.65 | 225.87 | 226.02 | 9265725.0 |
| 2017-01-12 10:00:00 | SPY | ETF | 226.01 | 226.5 | 225.17 | 225.25 | 13993088.0 |
| 2017-01-12 11:00:00 | SPY | ETF | 225.24 | 225.51 | 224.955 | 225.33 | 9668213.0 |
| 2017-01-12 12:00:00 | SPY | ETF | 225.31 | 226.08 | 225.305 | 225.965 | 7860672.0 |
| 2017-01-12 13:00:00 | SPY | ETF | 225.96 | 226.39 | 225.88 | 226.26 | 6954102.0 |
| 2017-01-12 14:00:00 | SPY | ETF | 226.26 | 226.64 | 226.17 | 226.5879 | 6376975.0 |
| 2017-01-12 15:00:00 | SPY | ETF | 226.58 | 226.75 | 226.29 | 226.57 | 12402376.0 |
| 2017-01-12 16:00:00 | SPY | ETF | 226.56 | 226.5956 | 226.39 | 226.52 | 3412599.0 |
| 2017-01-12 17:00:00 | SPY | ETF | 226.49 | 226.54 | 226.48 | 226.51 | 134319.0 |
| 2017-01-12 18:00:00 | SPY | ETF | 226.5 | 226.63 | 226.5 | 226.6 | 39920.0 |
| 2017-01-12 19:00:00 | SPY | ETF | 226.57 | 226.58 | 226.49 | 226.56 | 33732.0 |
| 2017-01-12 04:00:00 | QQQ | ETF | 122.63 | 122.64 | 122.59 | 122.63 | 4500.0 |
| 2017-01-12 05:00:00 | QQQ | ETF | 122.63 | 122.63 | 122.63 | 122.63 | 368.0 |
| 2017-01-12 06:00:00 | QQQ | ETF | 122.6 | 122.69 | 122.59 | 122.64 | 10000.0 |
| 2017-01-12 07:00:00 | QQQ | ETF | 122.63 | 122.64 | 122.55 | 122.64 | 19599.0 |
| 2017-01-12 08:00:00 | QQQ | ETF | 122.62 | 122.65 | 122.57 | 122.59 | 26779.0 |
| 2017-01-12 09:00:00 | QQQ | ETF | 122.58 | 122.59 | 122.1 | 122.25 | 2362891.0 |
| 2017-01-12 10:00:00 | QQQ | ETF | 122.25 | 122.31 | 121.7 | 121.76 | 4768674.0 |
| 2017-01-12 11:00:00 | QQQ | ETF | 121.76 | 122.08 | 121.6 | 122.02 | 2348217.0 |
| 2017-01-12 12:00:00 | QQQ | ETF | 122.02 | 122.385 | 122.0 | 122.32 | 1668592.0 |
| 2017-01-12 13:00:00 | QQQ | ETF | 122.31 | 122.575 | 122.27 | 122.5 | 1768073.0 |
| 2017-01-12 14:00:00 | QQQ | ETF | 122.5 | 122.66 | 122.41 | 122.62 | 1807616.0 |
| 2017-01-12 15:00:00 | QQQ | ETF | 122.629 | 122.819 | 122.5 | 122.73 | 2060514.0 |
| 2017-01-12 16:00:00 | QQQ | ETF | 122.73 | 122.76 | 122.65 | 122.74 | 529715.0 |
| 2017-01-12 17:00:00 | QQQ | ETF | 122.84 | 122.84 | 122.72 | 122.74 | 4480.0 |
| 2017-01-12 18:00:00 | QQQ | ETF | 122.72 | 122.81 | 122.72 | 122.76 | 24535.0 |
| 2017-01-12 19:00:00 | QQQ | ETF | 122.74 | 122.76 | 122.72 | 122.76 | 2340.0 |
| 2017-01-12 04:00:00 | IWM | ETF | 136.1 | 136.1 | 136.01 | 136.05 | 7200.0 |
| 2017-01-12 05:00:00 | IWM | ETF | 136.03 | 136.15 | 136.02 | 136.15 | 300.0 |
| 2017-01-12 06:00:00 | IWM | ETF | 136.1 | 136.1 | 136.1 | 136.1 | 2000.0 |
| 2017-01-12 07:00:00 | IWM | ETF | 136.1 | 136.25 | 136.02 | 136.23 | 30915.0 |
| 2017-01-12 08:00:00 | IWM | ETF | 136.24 | 136.33 | 136.18 | 136.19 | 159875.0 |
| 2017-01-12 09:00:00 | IWM | ETF | 136.2 | 136.27 | 135.07 | 135.23 | 3583895.0 |
| 2017-01-12 10:00:00 | IWM | ETF | 135.22 | 135.23 | 133.79 | 133.98 | 10506831.0 |
| 2017-01-12 11:00:00 | IWM | ETF | 133.97 | 134.1 | 133.59 | 133.795 | 4336105.0 |
| 2017-01-12 12:00:00 | IWM | ETF | 133.79 | 134.56 | 133.79 | 134.56 | 2984102.0 |
| 2017-01-12 13:00:00 | IWM | ETF | 134.56 | 135.07 | 134.54 | 134.93 | 3011381.0 |
| 2017-01-12 14:00:00 | IWM | ETF | 134.939 | 135.29 | 134.73 | 135.05 | 2729171.0 |
| 2017-01-12 15:00:00 | IWM | ETF | 135.05 | 135.31 | 134.76 | 135.27 | 5192543.0 |
| 2017-01-12 16:00:00 | IWM | ETF | 135.27 | 135.28 | 133.7376 | 135.0 | 2780434.0 |
| 2017-01-12 17:00:00 | IWM | ETF | 135.38 | 135.38 | 135.07 | 135.13 | 13963.0 |
| 2017-01-12 18:00:00 | IWM | ETF | 135.12 | 135.25 | 135.12 | 135.2 | 4611.0 |
| 2017-01-12 19:00:00 | IWM | ETF | 135.15 | 135.2 | 135.12 | 135.2 | 1850.0 |
| 2017-01-12 05:00:00 | DIA | ETF | 198.8 | 198.8 | 198.8 | 198.8 | 1000.0 |
| 2017-01-12 07:00:00 | DIA | ETF | 199.0 | 199.0 | 199.0 | 199.0 | 950.0 |
> showing 50 of 8,820 rows — these rows as CSV