PREVIEW / etf_1hour / 2017-04-24
file: by_date/etf_1hour/2017/2017-04-24.parquet size: 281 KB rows: 9,225
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-24 04:00:00 | SPY | ETF | 237.06 | 237.36 | 237.06 | 237.36 | 35465.0 |
| 2017-04-24 05:00:00 | SPY | ETF | 237.36 | 237.47 | 237.25 | 237.41 | 27505.0 |
| 2017-04-24 06:00:00 | SPY | ETF | 237.39 | 237.71 | 237.39 | 237.54 | 101963.0 |
| 2017-04-24 07:00:00 | SPY | ETF | 237.47 | 237.5 | 237.26 | 237.42 | 552859.0 |
| 2017-04-24 08:00:00 | SPY | ETF | 237.42 | 237.52 | 234.59 | 237.3 | 1244380.0 |
| 2017-04-24 09:00:00 | SPY | ETF | 237.31 | 237.31 | 236.74 | 236.995 | 12100021.0 |
| 2017-04-24 10:00:00 | SPY | ETF | 237.0 | 237.22 | 236.81 | 236.97 | 18095972.0 |
| 2017-04-24 11:00:00 | SPY | ETF | 236.97 | 237.05 | 236.61 | 236.65 | 11750675.0 |
| 2017-04-24 12:00:00 | SPY | ETF | 236.655 | 236.96 | 236.655 | 236.87 | 9432025.0 |
| 2017-04-24 13:00:00 | SPY | ETF | 236.86 | 237.12 | 236.85 | 237.08 | 14139128.0 |
| 2017-04-24 14:00:00 | SPY | ETF | 237.08 | 237.32 | 236.97 | 237.15 | 8971963.0 |
| 2017-04-24 15:00:00 | SPY | ETF | 237.15 | 237.41 | 237.05 | 237.12 | 24601445.0 |
| 2017-04-24 16:00:00 | SPY | ETF | 237.12 | 237.17 | 236.88 | 237.07 | 12599820.0 |
| 2017-04-24 17:00:00 | SPY | ETF | 237.06 | 237.3206 | 237.06 | 237.08 | 341606.0 |
| 2017-04-24 18:00:00 | SPY | ETF | 237.08 | 237.08 | 236.9 | 237.0 | 136879.0 |
| 2017-04-24 19:00:00 | SPY | ETF | 237.0 | 237.0 | 236.88 | 236.94 | 51159.0 |
| 2017-04-24 04:00:00 | QQQ | ETF | 133.79 | 134.0 | 133.1 | 134.0 | 7119.0 |
| 2017-04-24 05:00:00 | QQQ | ETF | 134.01 | 134.01 | 134.01 | 134.01 | 700.0 |
| 2017-04-24 06:00:00 | QQQ | ETF | 133.95 | 134.06 | 133.94 | 134.01 | 3333.0 |
| 2017-04-24 07:00:00 | QQQ | ETF | 133.96 | 134.02 | 133.91 | 133.98 | 61327.0 |
| 2017-04-24 08:00:00 | QQQ | ETF | 133.97 | 134.14 | 133.75 | 134.02 | 237821.0 |
| 2017-04-24 09:00:00 | QQQ | ETF | 134.06 | 134.12 | 133.8042 | 134.08 | 4241820.0 |
| 2017-04-24 10:00:00 | QQQ | ETF | 134.08 | 134.21 | 133.9531 | 134.06 | 2787683.0 |
| 2017-04-24 11:00:00 | QQQ | ETF | 134.06 | 134.085 | 133.84 | 133.87 | 1912007.0 |
| 2017-04-24 12:00:00 | QQQ | ETF | 133.88 | 134.04 | 133.88 | 133.97 | 1459560.0 |
| 2017-04-24 13:00:00 | QQQ | ETF | 133.97 | 134.08 | 133.96 | 134.08 | 1509576.0 |
| 2017-04-24 14:00:00 | QQQ | ETF | 134.075 | 134.17 | 133.995 | 134.14 | 2096775.0 |
| 2017-04-24 15:00:00 | QQQ | ETF | 134.1401 | 134.285 | 134.1 | 134.145 | 5045402.0 |
| 2017-04-24 16:00:00 | QQQ | ETF | 134.13 | 134.16 | 49.8906 | 134.06 | 2021627.0 |
| 2017-04-24 17:00:00 | QQQ | ETF | 134.07 | 134.1 | 134.05 | 134.08 | 6195.0 |
| 2017-04-24 18:00:00 | QQQ | ETF | 134.06 | 134.06 | 133.95 | 134.05 | 14314.0 |
| 2017-04-24 19:00:00 | QQQ | ETF | 134.03 | 134.03 | 133.97 | 133.97 | 8272.0 |
| 2017-04-24 04:00:00 | IWM | ETF | 138.8 | 139.31 | 138.8 | 139.31 | 35688.0 |
| 2017-04-24 05:00:00 | IWM | ETF | 139.37 | 139.37 | 139.25 | 139.27 | 5400.0 |
| 2017-04-24 06:00:00 | IWM | ETF | 139.35 | 139.49 | 139.3 | 139.35 | 42355.0 |
| 2017-04-24 07:00:00 | IWM | ETF | 139.34 | 139.44 | 139.16 | 139.42 | 155311.0 |
| 2017-04-24 08:00:00 | IWM | ETF | 139.42 | 139.57 | 139.16 | 139.2 | 276279.0 |
| 2017-04-24 09:00:00 | IWM | ETF | 139.2 | 139.34 | 138.75 | 139.01 | 5717289.0 |
| 2017-04-24 10:00:00 | IWM | ETF | 139.02 | 139.27 | 138.49 | 138.74 | 4544552.0 |
| 2017-04-24 11:00:00 | IWM | ETF | 138.74 | 138.97 | 138.5647 | 138.81 | 2461898.0 |
| 2017-04-24 12:00:00 | IWM | ETF | 138.82 | 139.13 | 138.8 | 139.06 | 1551898.0 |
| 2017-04-24 13:00:00 | IWM | ETF | 139.07 | 139.2 | 138.91 | 139.0 | 1868519.0 |
| 2017-04-24 14:00:00 | IWM | ETF | 139.01 | 139.11 | 138.87 | 139.02 | 1964961.0 |
| 2017-04-24 15:00:00 | IWM | ETF | 139.01 | 139.24 | 138.88 | 138.93 | 5149536.0 |
| 2017-04-24 16:00:00 | IWM | ETF | 138.92 | 139.04 | 138.77 | 138.92 | 3764037.0 |
| 2017-04-24 17:00:00 | IWM | ETF | 138.92 | 139.04 | 138.92 | 139.03 | 19149.0 |
| 2017-04-24 18:00:00 | IWM | ETF | 138.94 | 138.97 | 138.88 | 138.95 | 5446.0 |
| 2017-04-24 19:00:00 | IWM | ETF | 138.9412 | 138.95 | 138.9 | 138.9 | 42341.0 |
| 2017-04-24 04:00:00 | DIA | ETF | 206.35 | 207.13 | 206.07 | 207.13 | 2600.0 |
| 2017-04-24 05:00:00 | DIA | ETF | 207.3 | 207.3 | 207.3 | 207.3 | 300.0 |
> showing 50 of 9,225 rows — these rows as CSV