PREVIEW / etf_1hour / 2015-01-21
file: by_date/etf_1hour/2015/2015-01-21.parquet size: 240 KB rows: 7,643
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-01-21 04:00:00 | SPY | ETF | 201.99 | 202.13 | 201.91 | 201.93 | 900.0 |
| 2015-01-21 05:00:00 | SPY | ETF | 202.12 | 202.22 | 202.09 | 202.12 | 10700.0 |
| 2015-01-21 06:00:00 | SPY | ETF | 202.01 | 202.02 | 201.57 | 201.64 | 55861.0 |
| 2015-01-21 07:00:00 | SPY | ETF | 201.69 | 201.7 | 201.21 | 201.34 | 464510.0 |
| 2015-01-21 08:00:00 | SPY | ETF | 201.35 | 201.78 | 201.27 | 201.47 | 701137.0 |
| 2015-01-21 09:00:00 | SPY | ETF | 201.48 | 202.81 | 200.94 | 202.17 | 28365815.0 |
| 2015-01-21 10:00:00 | SPY | ETF | 202.17 | 203.5 | 201.75 | 203.41 | 23344489.0 |
| 2015-01-21 11:00:00 | SPY | ETF | 203.4 | 203.66 | 202.91 | 203.2572 | 10649252.0 |
| 2015-01-21 12:00:00 | SPY | ETF | 203.2562 | 203.475 | 202.65 | 202.89 | 7202571.0 |
| 2015-01-21 13:00:00 | SPY | ETF | 202.88 | 203.1 | 202.185 | 202.21 | 9858639.0 |
| 2015-01-21 14:00:00 | SPY | ETF | 202.22 | 202.97 | 202.02 | 202.89 | 10726702.0 |
| 2015-01-21 15:00:00 | SPY | ETF | 202.88 | 203.19 | 202.45 | 203.09 | 19326857.0 |
| 2015-01-21 16:00:00 | SPY | ETF | 203.09 | 203.222 | 202.4 | 203.08 | 7591690.0 |
| 2015-01-21 17:00:00 | SPY | ETF | 203.07 | 203.17 | 203.04 | 203.11 | 341142.0 |
| 2015-01-21 18:00:00 | SPY | ETF | 203.12 | 203.19 | 202.97 | 203.08 | 129957.0 |
| 2015-01-21 19:00:00 | SPY | ETF | 203.03 | 203.09 | 203.0 | 203.07 | 29210.0 |
| 2015-01-21 06:00:00 | QQQ | ETF | 101.49 | 101.54 | 101.43 | 101.43 | 18400.0 |
| 2015-01-21 07:00:00 | QQQ | ETF | 101.39 | 101.42 | 101.29 | 101.34 | 27899.0 |
| 2015-01-21 08:00:00 | QQQ | ETF | 101.33 | 101.54 | 101.33 | 101.39 | 78279.0 |
| 2015-01-21 09:00:00 | QQQ | ETF | 101.44 | 102.03 | 100.9648 | 101.52 | 9220079.0 |
| 2015-01-21 10:00:00 | QQQ | ETF | 101.51 | 102.525 | 101.35 | 102.45 | 7136669.0 |
| 2015-01-21 11:00:00 | QQQ | ETF | 102.46 | 102.619 | 102.155 | 102.3501 | 3257077.0 |
| 2015-01-21 12:00:00 | QQQ | ETF | 102.35 | 102.45 | 101.95 | 102.14 | 3044504.0 |
| 2015-01-21 13:00:00 | QQQ | ETF | 102.13 | 102.285 | 101.69 | 101.7 | 3056567.0 |
| 2015-01-21 14:00:00 | QQQ | ETF | 101.7 | 102.18 | 101.58 | 102.14 | 2590820.0 |
| 2015-01-21 15:00:00 | QQQ | ETF | 102.15 | 102.23 | 101.875 | 102.14 | 4678744.0 |
| 2015-01-21 16:00:00 | QQQ | ETF | 102.14 | 102.2255 | 102.05 | 102.11 | 2519329.0 |
| 2015-01-21 17:00:00 | QQQ | ETF | 102.1 | 102.13 | 102.06 | 102.08 | 33004.0 |
| 2015-01-21 18:00:00 | QQQ | ETF | 102.07 | 102.1 | 102.02 | 102.05 | 66715.0 |
| 2015-01-21 19:00:00 | QQQ | ETF | 102.07 | 102.07 | 102.04 | 102.05 | 20490.0 |
| 2015-01-21 04:00:00 | IWM | ETF | 116.23 | 116.23 | 116.23 | 116.23 | 120.0 |
| 2015-01-21 07:00:00 | IWM | ETF | 115.75 | 115.9 | 115.72 | 115.77 | 36099.0 |
| 2015-01-21 08:00:00 | IWM | ETF | 115.8 | 115.93 | 115.66 | 115.72 | 139700.0 |
| 2015-01-21 09:00:00 | IWM | ETF | 115.75 | 116.69 | 115.39 | 116.45 | 3758324.0 |
| 2015-01-21 10:00:00 | IWM | ETF | 116.44 | 116.76 | 116.17 | 116.63 | 3737569.0 |
| 2015-01-21 11:00:00 | IWM | ETF | 116.64 | 116.82 | 116.19 | 116.42 | 2604285.0 |
| 2015-01-21 12:00:00 | IWM | ETF | 116.41 | 116.59 | 116.14 | 116.28 | 1747107.0 |
| 2015-01-21 13:00:00 | IWM | ETF | 116.29 | 116.34 | 115.41 | 115.44 | 4036838.0 |
| 2015-01-21 14:00:00 | IWM | ETF | 115.43 | 115.88 | 115.29 | 115.83 | 2796122.0 |
| 2015-01-21 15:00:00 | IWM | ETF | 115.85 | 115.87 | 115.39 | 115.84 | 4118701.0 |
| 2015-01-21 16:00:00 | IWM | ETF | 115.85 | 116.316 | 115.73 | 115.84 | 585663.0 |
| 2015-01-21 17:00:00 | IWM | ETF | 115.79 | 115.79 | 115.76 | 115.77 | 5764.0 |
| 2015-01-21 18:00:00 | IWM | ETF | 115.8 | 115.8 | 115.8 | 115.8 | 600.0 |
| 2015-01-21 19:00:00 | IWM | ETF | 115.8 | 115.84 | 115.8 | 115.84 | 2100.0 |
| 2015-01-21 04:00:00 | DIA | ETF | 174.54 | 174.54 | 174.54 | 174.54 | 1000.0 |
| 2015-01-21 07:00:00 | DIA | ETF | 174.4 | 174.4 | 174.2 | 174.2 | 4068.0 |
| 2015-01-21 08:00:00 | DIA | ETF | 174.24 | 174.49 | 174.2 | 174.2 | 5620.0 |
| 2015-01-21 09:00:00 | DIA | ETF | 174.32 | 175.1 | 173.66 | 174.52 | 1570809.0 |
| 2015-01-21 10:00:00 | DIA | ETF | 174.52 | 175.58 | 174.08 | 175.55 | 1440716.0 |
| 2015-01-21 11:00:00 | DIA | ETF | 175.56 | 175.75 | 175.05 | 175.33 | 853459.0 |
> showing 50 of 7,643 rows — these rows as CSV