PREVIEW / etf_1hour / 2015-02-18
file: by_date/etf_1hour/2015/2015-02-18.parquet size: 237 KB rows: 7,511
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-02-18 04:00:00 | SPY | ETF | 210.19 | 210.19 | 210.1 | 210.1 | 500.0 |
| 2015-02-18 05:00:00 | SPY | ETF | 210.09 | 210.09 | 209.84 | 209.88 | 4600.0 |
| 2015-02-18 06:00:00 | SPY | ETF | 210.02 | 210.1 | 209.92 | 210.01 | 65202.0 |
| 2015-02-18 07:00:00 | SPY | ETF | 210.01 | 210.06 | 209.85 | 209.92 | 101714.0 |
| 2015-02-18 08:00:00 | SPY | ETF | 209.95 | 209.99 | 209.73 | 209.75 | 321012.0 |
| 2015-02-18 09:00:00 | SPY | ETF | 209.74 | 209.92 | 209.48 | 209.76 | 8301107.0 |
| 2015-02-18 10:00:00 | SPY | ETF | 209.75 | 209.8649 | 209.3401 | 209.73 | 10417883.0 |
| 2015-02-18 11:00:00 | SPY | ETF | 209.72 | 209.905 | 209.61 | 209.73 | 5792339.0 |
| 2015-02-18 12:00:00 | SPY | ETF | 209.725 | 209.86 | 209.465 | 209.51 | 5348013.0 |
| 2015-02-18 13:00:00 | SPY | ETF | 209.51 | 209.74 | 209.43 | 209.59 | 7136049.0 |
| 2015-02-18 14:00:00 | SPY | ETF | 209.59 | 210.18 | 209.57 | 209.86 | 15544138.0 |
| 2015-02-18 15:00:00 | SPY | ETF | 209.86 | 210.22 | 209.85 | 210.15 | 15593295.0 |
| 2015-02-18 16:00:00 | SPY | ETF | 210.15 | 210.15 | 209.69 | 210.01 | 7512293.0 |
| 2015-02-18 17:00:00 | SPY | ETF | 210.01 | 210.03 | 209.99 | 210.03 | 1034772.0 |
| 2015-02-18 18:00:00 | SPY | ETF | 210.03 | 210.04 | 209.97 | 209.98 | 22902.0 |
| 2015-02-18 19:00:00 | SPY | ETF | 209.97 | 209.97 | 209.91 | 209.94 | 567450.0 |
| 2015-02-18 04:00:00 | QQQ | ETF | 107.08 | 107.09 | 107.08 | 107.09 | 425.0 |
| 2015-02-18 05:00:00 | QQQ | ETF | 107.08 | 107.09 | 107.05 | 107.05 | 5000.0 |
| 2015-02-18 07:00:00 | QQQ | ETF | 106.99 | 106.99 | 106.91 | 106.95 | 9100.0 |
| 2015-02-18 08:00:00 | QQQ | ETF | 106.95 | 107.01 | 106.86 | 106.86 | 58556.0 |
| 2015-02-18 09:00:00 | QQQ | ETF | 106.85 | 107.03 | 106.8 | 106.98 | 2172373.0 |
| 2015-02-18 10:00:00 | QQQ | ETF | 106.98 | 107.04 | 106.74 | 106.979 | 2298628.0 |
| 2015-02-18 11:00:00 | QQQ | ETF | 106.97 | 107.01 | 106.89 | 106.935 | 1010222.0 |
| 2015-02-18 12:00:00 | QQQ | ETF | 106.93 | 107.0 | 106.8 | 106.83 | 1154500.0 |
| 2015-02-18 13:00:00 | QQQ | ETF | 106.83 | 106.95 | 106.82 | 106.84 | 973409.0 |
| 2015-02-18 14:00:00 | QQQ | ETF | 106.84 | 107.11 | 106.78 | 106.99 | 2419810.0 |
| 2015-02-18 15:00:00 | QQQ | ETF | 106.985 | 107.2199 | 106.985 | 107.16 | 2878576.0 |
| 2015-02-18 16:00:00 | QQQ | ETF | 107.16 | 107.1703 | 106.9683 | 107.12 | 457513.0 |
| 2015-02-18 17:00:00 | QQQ | ETF | 107.1 | 107.16 | 107.09 | 107.1 | 18290.0 |
| 2015-02-18 18:00:00 | QQQ | ETF | 107.11 | 107.13 | 107.11 | 107.11 | 1475.0 |
| 2015-02-18 19:00:00 | QQQ | ETF | 107.07 | 107.07 | 107.04 | 107.05 | 37006.0 |
| 2015-02-18 07:00:00 | IWM | ETF | 121.7 | 121.7 | 121.64 | 121.64 | 27500.0 |
| 2015-02-18 08:00:00 | IWM | ETF | 121.73 | 121.91 | 121.47 | 121.52 | 53567.0 |
| 2015-02-18 09:00:00 | IWM | ETF | 121.49 | 121.76 | 121.41 | 121.55 | 2007970.0 |
| 2015-02-18 10:00:00 | IWM | ETF | 121.54 | 121.74 | 121.13 | 121.68 | 3258742.0 |
| 2015-02-18 11:00:00 | IWM | ETF | 121.68 | 121.8 | 121.6 | 121.61 | 1423746.0 |
| 2015-02-18 12:00:00 | IWM | ETF | 121.62 | 121.67 | 121.305 | 121.43 | 1161293.0 |
| 2015-02-18 13:00:00 | IWM | ETF | 121.44 | 121.68 | 121.38 | 121.58 | 1767907.0 |
| 2015-02-18 14:00:00 | IWM | ETF | 121.61 | 121.91 | 121.59 | 121.85 | 1877677.0 |
| 2015-02-18 15:00:00 | IWM | ETF | 121.85 | 122.05 | 121.75 | 121.98 | 3485258.0 |
| 2015-02-18 16:00:00 | IWM | ETF | 121.98 | 122.05 | 121.92 | 122.01 | 596867.0 |
| 2015-02-18 17:00:00 | IWM | ETF | 122.01 | 122.03 | 121.85 | 122.03 | 5168.0 |
| 2015-02-18 19:00:00 | IWM | ETF | 121.95 | 121.96 | 121.95 | 121.96 | 800.0 |
| 2015-02-18 08:00:00 | DIA | ETF | 180.32 | 180.57 | 180.24 | 180.24 | 6100.0 |
| 2015-02-18 09:00:00 | DIA | ETF | 180.22 | 180.41 | 180.06 | 180.34 | 356449.0 |
| 2015-02-18 10:00:00 | DIA | ETF | 180.34 | 180.38 | 179.97 | 180.25 | 381867.0 |
| 2015-02-18 11:00:00 | DIA | ETF | 180.24 | 180.42 | 180.16 | 180.28 | 183409.0 |
| 2015-02-18 12:00:00 | DIA | ETF | 180.29 | 180.37 | 180.08 | 180.11 | 292900.0 |
| 2015-02-18 13:00:00 | DIA | ETF | 180.1 | 180.28 | 180.07 | 180.148 | 221140.0 |
| 2015-02-18 14:00:00 | DIA | ETF | 180.17 | 180.6 | 180.135 | 180.29 | 482331.0 |
> showing 50 of 7,511 rows — these rows as CSV