PREVIEW / etf_1hour / 2015-10-22
file: by_date/etf_1hour/2015/2015-10-22.parquet size: 245 KB rows: 7,704
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-10-22 04:00:00 | SPY | ETF | 202.07 | 202.21 | 201.94 | 202.07 | 5191.0 |
| 2015-10-22 05:00:00 | SPY | ETF | 202.12 | 202.27 | 202.1 | 202.19 | 7228.0 |
| 2015-10-22 06:00:00 | SPY | ETF | 202.21 | 202.37 | 202.21 | 202.24 | 78682.0 |
| 2015-10-22 07:00:00 | SPY | ETF | 202.24 | 202.32 | 202.15 | 202.22 | 194752.0 |
| 2015-10-22 08:00:00 | SPY | ETF | 202.2 | 202.99 | 202.06 | 202.73 | 2003445.0 |
| 2015-10-22 09:00:00 | SPY | ETF | 202.73 | 203.93 | 202.45 | 203.91 | 19283637.0 |
| 2015-10-22 10:00:00 | SPY | ETF | 203.9 | 204.52 | 203.8 | 204.511 | 22784675.0 |
| 2015-10-22 11:00:00 | SPY | ETF | 204.51 | 204.86 | 204.28 | 204.67 | 20477141.0 |
| 2015-10-22 12:00:00 | SPY | ETF | 204.67 | 205.51 | 204.5601 | 205.3 | 22685774.0 |
| 2015-10-22 13:00:00 | SPY | ETF | 205.31 | 205.44 | 204.73 | 204.73 | 17505888.0 |
| 2015-10-22 14:00:00 | SPY | ETF | 204.74 | 205.19 | 204.1 | 205.17 | 22929364.0 |
| 2015-10-22 15:00:00 | SPY | ETF | 205.16 | 205.425 | 204.75 | 205.22 | 31208828.0 |
| 2015-10-22 16:00:00 | SPY | ETF | 205.21 | 206.21 | 205.1 | 206.21 | 13246067.0 |
| 2015-10-22 17:00:00 | SPY | ETF | 206.17 | 206.3 | 204.6191 | 206.07 | 639949.0 |
| 2015-10-22 18:00:00 | SPY | ETF | 206.09 | 206.82 | 205.99 | 206.55 | 433726.0 |
| 2015-10-22 19:00:00 | SPY | ETF | 206.55 | 206.58 | 206.44 | 206.56 | 270351.0 |
| 2015-10-22 04:00:00 | QQQ | ETF | 107.84 | 107.84 | 107.75 | 107.75 | 700.0 |
| 2015-10-22 05:00:00 | QQQ | ETF | 107.84 | 107.85 | 107.84 | 107.85 | 400.0 |
| 2015-10-22 06:00:00 | QQQ | ETF | 107.88 | 107.93 | 107.88 | 107.91 | 6750.0 |
| 2015-10-22 07:00:00 | QQQ | ETF | 107.92 | 107.99 | 107.9 | 107.94 | 157705.0 |
| 2015-10-22 08:00:00 | QQQ | ETF | 107.9 | 108.37 | 107.9 | 108.27 | 228286.0 |
| 2015-10-22 09:00:00 | QQQ | ETF | 108.25 | 109.05 | 108.13 | 108.96 | 6878866.0 |
| 2015-10-22 10:00:00 | QQQ | ETF | 108.97 | 109.38 | 108.83 | 109.37 | 6424958.0 |
| 2015-10-22 11:00:00 | QQQ | ETF | 109.369 | 109.51 | 109.09 | 109.3219 | 3913254.0 |
| 2015-10-22 12:00:00 | QQQ | ETF | 109.32 | 109.8 | 109.25 | 109.69 | 3878424.0 |
| 2015-10-22 13:00:00 | QQQ | ETF | 109.69 | 109.77 | 109.38 | 109.3812 | 2655936.0 |
| 2015-10-22 14:00:00 | QQQ | ETF | 109.38 | 109.66 | 109.0864 | 109.6199 | 4460755.0 |
| 2015-10-22 15:00:00 | QQQ | ETF | 109.61 | 109.79 | 109.43 | 109.72 | 5092461.0 |
| 2015-10-22 16:00:00 | QQQ | ETF | 109.71 | 111.49 | 109.62 | 111.49 | 3439653.0 |
| 2015-10-22 17:00:00 | QQQ | ETF | 111.49 | 111.59 | 111.44 | 111.45 | 120075.0 |
| 2015-10-22 18:00:00 | QQQ | ETF | 111.45 | 111.94 | 111.38 | 111.81 | 380487.0 |
| 2015-10-22 19:00:00 | QQQ | ETF | 111.8 | 111.81 | 111.71 | 111.76 | 63342.0 |
| 2015-10-22 07:00:00 | IWM | ETF | 114.15 | 114.2 | 114.08 | 114.1 | 202398.0 |
| 2015-10-22 08:00:00 | IWM | ETF | 114.11 | 114.46 | 114.11 | 114.4 | 251223.0 |
| 2015-10-22 09:00:00 | IWM | ETF | 114.33 | 114.88 | 114.105 | 114.65 | 5797618.0 |
| 2015-10-22 10:00:00 | IWM | ETF | 114.65 | 115.41 | 114.48 | 115.3999 | 5715562.0 |
| 2015-10-22 11:00:00 | IWM | ETF | 115.4 | 115.42 | 114.73 | 114.8592 | 3606919.0 |
| 2015-10-22 12:00:00 | IWM | ETF | 114.87 | 115.25 | 114.74 | 114.9689 | 2602670.0 |
| 2015-10-22 13:00:00 | IWM | ETF | 114.97 | 115.12 | 114.1 | 114.1 | 3078146.0 |
| 2015-10-22 14:00:00 | IWM | ETF | 114.105 | 114.621 | 113.73 | 114.481 | 4627230.0 |
| 2015-10-22 15:00:00 | IWM | ETF | 114.49 | 114.74 | 114.24 | 114.71 | 4841692.0 |
| 2015-10-22 16:00:00 | IWM | ETF | 114.71 | 115.38 | 114.5975 | 115.36 | 1000492.0 |
| 2015-10-22 17:00:00 | IWM | ETF | 115.38 | 115.5 | 114.72 | 115.29 | 2047015.0 |
| 2015-10-22 18:00:00 | IWM | ETF | 115.48 | 115.51 | 115.45 | 115.45 | 7391.0 |
| 2015-10-22 19:00:00 | IWM | ETF | 115.4 | 115.45 | 115.26 | 115.45 | 969.0 |
| 2015-10-22 07:00:00 | DIA | ETF | 171.8 | 171.8 | 171.61 | 171.62 | 9400.0 |
| 2015-10-22 08:00:00 | DIA | ETF | 171.98 | 172.69 | 171.98 | 172.67 | 13300.0 |
| 2015-10-22 09:00:00 | DIA | ETF | 172.6 | 173.2 | 172.37 | 173.148 | 1403664.0 |
| 2015-10-22 10:00:00 | DIA | ETF | 173.17 | 173.77 | 173.08 | 173.74 | 1575651.0 |
| 2015-10-22 11:00:00 | DIA | ETF | 173.74 | 174.18 | 173.65 | 174.019 | 816901.0 |
> showing 50 of 7,704 rows — these rows as CSV