PREVIEW / etf_1hour / 2015-11-27
file: by_date/etf_1hour/2015/2015-11-27.parquet size: 146 KB rows: 4,495
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-11-27 04:00:00 | SPY | ETF | 209.29 | 209.39 | 209.09 | 209.39 | 4641.0 |
| 2015-11-27 05:00:00 | SPY | ETF | 209.26 | 209.74 | 209.23 | 209.74 | 8555.0 |
| 2015-11-27 06:00:00 | SPY | ETF | 209.79 | 209.82 | 209.5 | 209.61 | 17310.0 |
| 2015-11-27 07:00:00 | SPY | ETF | 209.74 | 209.78 | 209.5 | 209.75 | 114737.0 |
| 2015-11-27 08:00:00 | SPY | ETF | 210.31 | 210.31 | 209.43 | 209.49 | 419425.0 |
| 2015-11-27 09:00:00 | SPY | ETF | 209.5 | 209.57 | 209.06 | 209.21 | 7668847.0 |
| 2015-11-27 10:00:00 | SPY | ETF | 209.21 | 209.46 | 208.86 | 209.405 | 8287868.0 |
| 2015-11-27 11:00:00 | SPY | ETF | 209.41 | 209.8 | 209.4 | 209.54 | 6372240.0 |
| 2015-11-27 12:00:00 | SPY | ETF | 209.53 | 209.74 | 209.46 | 209.53 | 8390023.0 |
| 2015-11-27 13:00:00 | SPY | ETF | 209.54 | 209.71 | 209.4657 | 209.5999 | 2533574.0 |
| 2015-11-27 14:00:00 | SPY | ETF | 209.56 | 209.58 | 209.38 | 209.38 | 221658.0 |
| 2015-11-27 15:00:00 | SPY | ETF | 209.44 | 209.51 | 209.44 | 209.51 | 10702.0 |
| 2015-11-27 16:00:00 | SPY | ETF | 209.51 | 209.51 | 209.41 | 209.42 | 22681.0 |
| 2015-11-27 04:00:00 | QQQ | ETF | 114.19 | 114.28 | 114.19 | 114.28 | 200.0 |
| 2015-11-27 05:00:00 | QQQ | ETF | 114.29 | 114.29 | 114.29 | 114.29 | 1000.0 |
| 2015-11-27 06:00:00 | QQQ | ETF | 114.47 | 114.56 | 114.47 | 114.56 | 6960.0 |
| 2015-11-27 07:00:00 | QQQ | ETF | 114.58 | 114.62 | 114.54 | 114.62 | 9800.0 |
| 2015-11-27 08:00:00 | QQQ | ETF | 114.52 | 114.63 | 114.44 | 114.46 | 65972.0 |
| 2015-11-27 09:00:00 | QQQ | ETF | 114.47 | 114.48 | 114.105 | 114.18 | 2357138.0 |
| 2015-11-27 10:00:00 | QQQ | ETF | 114.17 | 114.2485 | 113.92 | 114.17 | 1963946.0 |
| 2015-11-27 11:00:00 | QQQ | ETF | 114.17 | 114.541 | 114.17 | 114.37 | 1910113.0 |
| 2015-11-27 12:00:00 | QQQ | ETF | 114.38 | 114.5 | 114.29 | 114.31 | 1574803.0 |
| 2015-11-27 13:00:00 | QQQ | ETF | 114.32 | 114.38 | 114.2 | 114.25 | 136709.0 |
| 2015-11-27 14:00:00 | QQQ | ETF | 114.22 | 114.28 | 114.09 | 114.09 | 414867.0 |
| 2015-11-27 15:00:00 | QQQ | ETF | 114.2 | 114.2 | 114.12 | 114.13 | 3100.0 |
| 2015-11-27 16:00:00 | QQQ | ETF | 114.21 | 114.31 | 114.2 | 114.31 | 3887.0 |
| 2015-11-27 04:00:00 | IWM | ETF | 119.15 | 119.15 | 119.15 | 119.15 | 100.0 |
| 2015-11-27 07:00:00 | IWM | ETF | 119.4 | 119.4 | 119.4 | 119.4 | 100.0 |
| 2015-11-27 08:00:00 | IWM | ETF | 119.3 | 119.56 | 119.23 | 119.26 | 44646.0 |
| 2015-11-27 09:00:00 | IWM | ETF | 119.3 | 119.6 | 118.88 | 119.37 | 2218134.0 |
| 2015-11-27 10:00:00 | IWM | ETF | 119.37 | 119.75 | 118.99 | 119.57 | 2463729.0 |
| 2015-11-27 11:00:00 | IWM | ETF | 119.57 | 119.9 | 119.38 | 119.4106 | 2635519.0 |
| 2015-11-27 12:00:00 | IWM | ETF | 119.415 | 119.69 | 119.36 | 119.6 | 2445156.0 |
| 2015-11-27 13:00:00 | IWM | ETF | 119.6 | 119.78 | 119.54 | 119.65 | 353307.0 |
| 2015-11-27 14:00:00 | IWM | ETF | 119.53 | 119.58 | 119.53 | 119.58 | 170200.0 |
| 2015-11-27 15:00:00 | IWM | ETF | 119.55 | 119.57 | 119.47 | 119.57 | 647.0 |
| 2015-11-27 16:00:00 | IWM | ETF | 119.4 | 119.6 | 119.4 | 119.6 | 1838.0 |
| 2015-11-27 08:00:00 | DIA | ETF | 177.91 | 177.91 | 177.91 | 177.91 | 100.0 |
| 2015-11-27 09:00:00 | DIA | ETF | 177.9 | 178.05 | 177.51 | 177.64 | 1344768.0 |
| 2015-11-27 10:00:00 | DIA | ETF | 177.63 | 177.83 | 177.36 | 177.77 | 498810.0 |
| 2015-11-27 11:00:00 | DIA | ETF | 177.79 | 178.18 | 177.79 | 177.93 | 704604.0 |
| 2015-11-27 12:00:00 | DIA | ETF | 177.98 | 178.09 | 177.85 | 177.88 | 266311.0 |
| 2015-11-27 13:00:00 | DIA | ETF | 177.9 | 178.15 | 177.78 | 178.12 | 11312.0 |
| 2015-11-27 14:00:00 | DIA | ETF | 177.8785 | 177.8785 | 177.8785 | 177.8785 | 2500.0 |
| 2015-11-27 15:00:00 | DIA | ETF | 177.88 | 177.88 | 177.85 | 177.85 | 5446.0 |
| 2015-11-27 04:00:00 | GLD | ETF | 102.19 | 102.26 | 102.15 | 102.18 | 2300.0 |
| 2015-11-27 05:00:00 | GLD | ETF | 102.0 | 102.02 | 101.87 | 101.97 | 2000.0 |
| 2015-11-27 06:00:00 | GLD | ETF | 101.99 | 101.99 | 101.99 | 101.99 | 100.0 |
| 2015-11-27 07:00:00 | GLD | ETF | 102.0 | 102.07 | 101.96 | 102.07 | 700.0 |
| 2015-11-27 08:00:00 | GLD | ETF | 102.08 | 102.46 | 101.0 | 101.2 | 56138.0 |
> showing 50 of 4,495 rows — these rows as CSV