PREVIEW / etf_1hour / 2015-08-21
file: by_date/etf_1hour/2015/2015-08-21.parquet size: 268 KB rows: 8,500
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-08-21 04:00:00 | SPY | ETF | 203.15 | 203.32 | 202.94 | 203.19 | 101586.0 |
| 2015-08-21 05:00:00 | SPY | ETF | 203.31 | 203.56 | 202.94 | 203.08 | 81902.0 |
| 2015-08-21 06:00:00 | SPY | ETF | 203.08 | 203.14 | 202.6 | 202.82 | 183269.0 |
| 2015-08-21 07:00:00 | SPY | ETF | 202.82 | 203.1 | 202.46 | 202.7 | 578654.0 |
| 2015-08-21 08:00:00 | SPY | ETF | 202.73 | 203.05 | 202.25 | 202.65 | 1632782.0 |
| 2015-08-21 09:00:00 | SPY | ETF | 202.65 | 203.4 | 201.47 | 202.23 | 36318417.0 |
| 2015-08-21 10:00:00 | SPY | ETF | 202.2301 | 203.9404 | 200.95 | 201.15 | 50705580.0 |
| 2015-08-21 11:00:00 | SPY | ETF | 201.16 | 201.23 | 199.66 | 200.6501 | 46301862.0 |
| 2015-08-21 12:00:00 | SPY | ETF | 200.65 | 201.35 | 199.585 | 199.61 | 34723835.0 |
| 2015-08-21 13:00:00 | SPY | ETF | 199.605 | 200.71 | 199.34 | 200.68 | 31402646.0 |
| 2015-08-21 14:00:00 | SPY | ETF | 200.675 | 200.94 | 198.89 | 199.15 | 34759315.0 |
| 2015-08-21 15:00:00 | SPY | ETF | 199.16 | 199.4 | 197.53 | 197.54 | 75434160.0 |
| 2015-08-21 16:00:00 | SPY | ETF | 197.53 | 203.9404 | 197.47 | 197.7 | 25438382.0 |
| 2015-08-21 17:00:00 | SPY | ETF | 197.66 | 202.16 | 197.5 | 197.6 | 2111306.0 |
| 2015-08-21 18:00:00 | SPY | ETF | 197.6 | 197.96 | 197.48 | 197.91 | 2855415.0 |
| 2015-08-21 19:00:00 | SPY | ETF | 197.91 | 197.96 | 197.86 | 197.92 | 49220.0 |
| 2015-08-21 04:00:00 | QQQ | ETF | 106.56 | 106.56 | 106.29 | 106.4 | 57310.0 |
| 2015-08-21 05:00:00 | QQQ | ETF | 106.49 | 106.54 | 106.27 | 106.29 | 41550.0 |
| 2015-08-21 06:00:00 | QQQ | ETF | 106.35 | 106.35 | 106.04 | 106.22 | 52499.0 |
| 2015-08-21 07:00:00 | QQQ | ETF | 106.22 | 106.32 | 106.01 | 106.14 | 156193.0 |
| 2015-08-21 08:00:00 | QQQ | ETF | 106.18 | 106.23 | 105.85 | 105.99 | 229082.0 |
| 2015-08-21 09:00:00 | QQQ | ETF | 106.01 | 106.14 | 105.07 | 106.051 | 11937202.0 |
| 2015-08-21 10:00:00 | QQQ | ETF | 106.05 | 106.47 | 104.91 | 105.12 | 12482248.0 |
| 2015-08-21 11:00:00 | QQQ | ETF | 105.12 | 105.16 | 104.16 | 104.76 | 12014824.0 |
| 2015-08-21 12:00:00 | QQQ | ETF | 104.76 | 105.16 | 104.1 | 104.1036 | 8364225.0 |
| 2015-08-21 13:00:00 | QQQ | ETF | 104.11 | 104.69 | 103.98 | 104.68 | 7146383.0 |
| 2015-08-21 14:00:00 | QQQ | ETF | 104.68 | 104.86 | 103.469 | 103.71 | 7306477.0 |
| 2015-08-21 15:00:00 | QQQ | ETF | 103.71 | 103.82 | 102.53 | 102.53 | 19487885.0 |
| 2015-08-21 16:00:00 | QQQ | ETF | 102.54 | 102.88 | 102.4 | 102.5 | 3372901.0 |
| 2015-08-21 17:00:00 | QQQ | ETF | 102.49 | 102.52 | 102.35 | 102.4 | 207874.0 |
| 2015-08-21 18:00:00 | QQQ | ETF | 102.41 | 102.6 | 102.32 | 102.49 | 1308805.0 |
| 2015-08-21 19:00:00 | QQQ | ETF | 102.48 | 102.5 | 102.34 | 102.48 | 31329.0 |
| 2015-08-21 04:00:00 | IWM | ETF | 116.09 | 116.09 | 115.93 | 115.93 | 400.0 |
| 2015-08-21 05:00:00 | IWM | ETF | 116.27 | 116.27 | 116.09 | 116.09 | 3000.0 |
| 2015-08-21 06:00:00 | IWM | ETF | 116.04 | 116.04 | 115.51 | 115.51 | 6950.0 |
| 2015-08-21 07:00:00 | IWM | ETF | 115.73 | 116.0 | 115.73 | 115.86 | 30731.0 |
| 2015-08-21 08:00:00 | IWM | ETF | 115.87 | 115.9 | 115.49 | 115.73 | 213418.0 |
| 2015-08-21 09:00:00 | IWM | ETF | 115.73 | 116.0 | 114.74 | 115.96 | 9316855.0 |
| 2015-08-21 10:00:00 | IWM | ETF | 115.955 | 116.34 | 114.82 | 115.02 | 10552664.0 |
| 2015-08-21 11:00:00 | IWM | ETF | 115.015 | 115.755 | 114.37 | 115.6525 | 8972980.0 |
| 2015-08-21 12:00:00 | IWM | ETF | 115.64 | 116.17 | 114.92 | 115.01 | 7111410.0 |
| 2015-08-21 13:00:00 | IWM | ETF | 115.0 | 116.59 | 114.86 | 116.57 | 11390046.0 |
| 2015-08-21 14:00:00 | IWM | ETF | 116.57 | 116.66 | 115.09 | 115.32 | 8617593.0 |
| 2015-08-21 15:00:00 | IWM | ETF | 115.32 | 115.53 | 114.7 | 114.97 | 14452565.0 |
| 2015-08-21 16:00:00 | IWM | ETF | 114.97 | 115.31 | 114.84 | 114.95 | 4111574.0 |
| 2015-08-21 17:00:00 | IWM | ETF | 114.95 | 115.05 | 114.9 | 114.98 | 234272.0 |
| 2015-08-21 18:00:00 | IWM | ETF | 114.97 | 115.1 | 114.97 | 115.1 | 435980.0 |
| 2015-08-21 19:00:00 | IWM | ETF | 114.99 | 115.12 | 114.99 | 115.12 | 1190.0 |
| 2015-08-21 04:00:00 | DIA | ETF | 169.03 | 169.03 | 169.0 | 169.0 | 200.0 |
| 2015-08-21 05:00:00 | DIA | ETF | 169.07 | 169.1 | 168.8 | 168.8 | 3300.0 |
> showing 50 of 8,500 rows — these rows as CSV