PREVIEW / etf_1hour / 2015-02-24
file: by_date/etf_1hour/2015/2015-02-24.parquet size: 240 KB rows: 7,616
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-24 04:00:00 | SPY | ETF | 211.08 | 211.18 | 211.03 | 211.1 | 4100.0 |
| 2015-02-24 05:00:00 | SPY | ETF | 211.1 | 211.15 | 211.1 | 211.14 | 6646.0 |
| 2015-02-24 06:00:00 | SPY | ETF | 211.17 | 211.28 | 211.17 | 211.2 | 20950.0 |
| 2015-02-24 07:00:00 | SPY | ETF | 211.25 | 211.25 | 211.04 | 211.15 | 213679.0 |
| 2015-02-24 08:00:00 | SPY | ETF | 211.141 | 211.23 | 211.08 | 211.21 | 519398.0 |
| 2015-02-24 09:00:00 | SPY | ETF | 211.22 | 211.36 | 211.03 | 211.14 | 8801334.0 |
| 2015-02-24 10:00:00 | SPY | ETF | 211.15 | 211.66 | 210.76 | 211.56 | 14622374.0 |
| 2015-02-24 11:00:00 | SPY | ETF | 211.55 | 211.91 | 211.52 | 211.59 | 7688036.0 |
| 2015-02-24 12:00:00 | SPY | ETF | 211.59 | 211.7 | 211.11 | 211.52 | 6228932.0 |
| 2015-02-24 13:00:00 | SPY | ETF | 211.52 | 211.73 | 211.375 | 211.675 | 4106188.0 |
| 2015-02-24 14:00:00 | SPY | ETF | 211.68 | 211.78 | 211.49 | 211.7555 | 5538079.0 |
| 2015-02-24 15:00:00 | SPY | ETF | 211.74 | 212.05 | 211.72 | 211.84 | 17254104.0 |
| 2015-02-24 16:00:00 | SPY | ETF | 211.83 | 211.93 | 211.1974 | 211.9 | 5527394.0 |
| 2015-02-24 17:00:00 | SPY | ETF | 211.89 | 211.89 | 211.82 | 211.85 | 60728.0 |
| 2015-02-24 18:00:00 | SPY | ETF | 211.84 | 211.88 | 211.81 | 211.82 | 70575.0 |
| 2015-02-24 19:00:00 | SPY | ETF | 211.82 | 211.84 | 211.69 | 211.815 | 177723.0 |
| 2015-02-24 04:00:00 | QQQ | ETF | 108.4 | 108.4 | 108.4 | 108.4 | 200.0 |
| 2015-02-24 06:00:00 | QQQ | ETF | 108.45 | 108.45 | 108.45 | 108.45 | 1500.0 |
| 2015-02-24 07:00:00 | QQQ | ETF | 108.46 | 108.46 | 108.35 | 108.4 | 41375.0 |
| 2015-02-24 08:00:00 | QQQ | ETF | 108.41 | 108.45 | 108.37 | 108.43 | 63943.0 |
| 2015-02-24 09:00:00 | QQQ | ETF | 108.43 | 108.43 | 108.15 | 108.22 | 2434699.0 |
| 2015-02-24 10:00:00 | QQQ | ETF | 108.23 | 108.5 | 108.05 | 108.48 | 3914257.0 |
| 2015-02-24 11:00:00 | QQQ | ETF | 108.47 | 108.71 | 108.4428 | 108.52 | 2846342.0 |
| 2015-02-24 12:00:00 | QQQ | ETF | 108.51 | 108.595 | 108.24 | 108.42 | 1431842.0 |
| 2015-02-24 13:00:00 | QQQ | ETF | 108.42 | 108.61 | 108.36 | 108.58 | 774733.0 |
| 2015-02-24 14:00:00 | QQQ | ETF | 108.58 | 108.65 | 108.49 | 108.62 | 939077.0 |
| 2015-02-24 15:00:00 | QQQ | ETF | 108.61 | 108.73 | 108.54 | 108.62 | 3469120.0 |
| 2015-02-24 16:00:00 | QQQ | ETF | 108.61 | 108.6588 | 108.445 | 108.62 | 2239333.0 |
| 2015-02-24 17:00:00 | QQQ | ETF | 108.59 | 108.59 | 108.53 | 108.53 | 4420.0 |
| 2015-02-24 18:00:00 | QQQ | ETF | 108.55 | 108.57 | 108.53 | 108.57 | 5999.0 |
| 2015-02-24 19:00:00 | QQQ | ETF | 108.53 | 108.54 | 108.48 | 108.5 | 21144.0 |
| 2015-02-24 06:00:00 | IWM | ETF | 122.5 | 122.5 | 122.5 | 122.5 | 14991.0 |
| 2015-02-24 07:00:00 | IWM | ETF | 122.48 | 122.49 | 122.48 | 122.48 | 3000.0 |
| 2015-02-24 08:00:00 | IWM | ETF | 122.46 | 122.53 | 122.43 | 122.45 | 47620.0 |
| 2015-02-24 09:00:00 | IWM | ETF | 122.46 | 122.74 | 122.35 | 122.51 | 2235340.0 |
| 2015-02-24 10:00:00 | IWM | ETF | 122.5 | 123.05 | 122.21 | 122.68 | 3168638.0 |
| 2015-02-24 11:00:00 | IWM | ETF | 122.68 | 122.84 | 122.3743 | 122.4 | 2949290.0 |
| 2015-02-24 12:00:00 | IWM | ETF | 122.39 | 122.5601 | 122.22 | 122.41 | 1312287.0 |
| 2015-02-24 13:00:00 | IWM | ETF | 122.41 | 122.545 | 122.24 | 122.42 | 1492553.0 |
| 2015-02-24 14:00:00 | IWM | ETF | 122.415 | 122.45 | 122.1866 | 122.42 | 1988116.0 |
| 2015-02-24 15:00:00 | IWM | ETF | 122.425 | 122.65 | 122.414 | 122.63 | 4171747.0 |
| 2015-02-24 16:00:00 | IWM | ETF | 122.63 | 122.76 | 122.4214 | 122.66 | 621138.0 |
| 2015-02-24 17:00:00 | IWM | ETF | 122.66 | 122.69 | 122.64 | 122.66 | 9704.0 |
| 2015-02-24 18:00:00 | IWM | ETF | 122.66 | 122.66 | 122.66 | 122.66 | 19450.0 |
| 2015-02-24 19:00:00 | IWM | ETF | 122.66 | 122.66 | 122.5 | 122.5 | 950.0 |
| 2015-02-24 08:00:00 | DIA | ETF | 181.17 | 181.17 | 180.9 | 180.94 | 10450.0 |
| 2015-02-24 09:00:00 | DIA | ETF | 181.04 | 181.27 | 180.96 | 181.16 | 591037.0 |
| 2015-02-24 10:00:00 | DIA | ETF | 181.175 | 181.628 | 180.89 | 181.59 | 924932.0 |
| 2015-02-24 11:00:00 | DIA | ETF | 181.59 | 181.86 | 181.58 | 181.66 | 474571.0 |
| 2015-02-24 12:00:00 | DIA | ETF | 181.65 | 181.6742 | 181.28 | 181.65 | 451217.0 |
> showing 50 of 7,616 rows — these rows as CSV