PREVIEW / etf_1hour / 2015-12-29
file: by_date/etf_1hour/2015/2015-12-29.parquet size: 251 KB rows: 8,003
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-12-29 04:00:00 | SPY | ETF | 206.02 | 206.31 | 206.02 | 206.3 | 21343.0 |
| 2015-12-29 05:00:00 | SPY | ETF | 206.21 | 206.24 | 206.09 | 206.16 | 2900.0 |
| 2015-12-29 06:00:00 | SPY | ETF | 206.19 | 206.19 | 205.94 | 205.94 | 12210.0 |
| 2015-12-29 07:00:00 | SPY | ETF | 206.08 | 206.33 | 206.05 | 206.22 | 164493.0 |
| 2015-12-29 08:00:00 | SPY | ETF | 206.24 | 206.75 | 205.235 | 206.69 | 847588.0 |
| 2015-12-29 09:00:00 | SPY | ETF | 206.69 | 207.09 | 206.47 | 207.0289 | 10389414.0 |
| 2015-12-29 10:00:00 | SPY | ETF | 207.02 | 207.25 | 206.91 | 206.96 | 11153214.0 |
| 2015-12-29 11:00:00 | SPY | ETF | 206.9599 | 207.28 | 206.77 | 206.92 | 10412780.0 |
| 2015-12-29 12:00:00 | SPY | ETF | 206.925 | 207.19 | 206.88 | 207.1 | 6415312.0 |
| 2015-12-29 13:00:00 | SPY | ETF | 207.11 | 207.55 | 207.08 | 207.513 | 9879243.0 |
| 2015-12-29 14:00:00 | SPY | ETF | 207.52 | 207.64 | 207.34 | 207.605 | 12281711.0 |
| 2015-12-29 15:00:00 | SPY | ETF | 207.6 | 207.79 | 207.25 | 207.43 | 22065561.0 |
| 2015-12-29 16:00:00 | SPY | ETF | 207.43 | 207.73 | 207.2547 | 207.7 | 8033585.0 |
| 2015-12-29 17:00:00 | SPY | ETF | 207.7 | 207.75 | 207.63 | 207.63 | 105695.0 |
| 2015-12-29 18:00:00 | SPY | ETF | 207.63 | 207.65 | 207.51 | 207.51 | 104988.0 |
| 2015-12-29 19:00:00 | SPY | ETF | 207.55 | 207.69 | 207.55 | 207.69 | 66589.0 |
| 2015-12-29 04:00:00 | QQQ | ETF | 112.84 | 113.2 | 112.84 | 113.19 | 21436.0 |
| 2015-12-29 05:00:00 | QQQ | ETF | 113.11 | 113.13 | 113.05 | 113.05 | 10850.0 |
| 2015-12-29 06:00:00 | QQQ | ETF | 113.13 | 113.13 | 113.06 | 113.09 | 3520.0 |
| 2015-12-29 07:00:00 | QQQ | ETF | 113.0 | 113.17 | 113.0 | 113.1 | 4321.0 |
| 2015-12-29 08:00:00 | QQQ | ETF | 113.1 | 113.37 | 113.06 | 113.3 | 158777.0 |
| 2015-12-29 09:00:00 | QQQ | ETF | 113.31 | 113.61 | 113.13 | 113.605 | 3205717.0 |
| 2015-12-29 10:00:00 | QQQ | ETF | 113.61 | 113.93 | 113.6 | 113.86 | 3661548.0 |
| 2015-12-29 11:00:00 | QQQ | ETF | 113.86 | 114.12 | 113.85 | 113.98 | 2285949.0 |
| 2015-12-29 12:00:00 | QQQ | ETF | 113.97 | 114.15 | 113.95 | 114.14 | 1748636.0 |
| 2015-12-29 13:00:00 | QQQ | ETF | 114.1349 | 114.41 | 114.08 | 114.3925 | 2419922.0 |
| 2015-12-29 14:00:00 | QQQ | ETF | 114.4 | 114.51 | 114.34 | 114.48 | 2468983.0 |
| 2015-12-29 15:00:00 | QQQ | ETF | 114.48 | 114.545 | 114.21 | 114.27 | 4338417.0 |
| 2015-12-29 16:00:00 | QQQ | ETF | 114.27 | 114.42 | 114.0343 | 114.39 | 452618.0 |
| 2015-12-29 17:00:00 | QQQ | ETF | 114.37 | 114.4 | 114.33 | 114.33 | 6487.0 |
| 2015-12-29 18:00:00 | QQQ | ETF | 114.35 | 114.35 | 114.28 | 114.28 | 20243.0 |
| 2015-12-29 19:00:00 | QQQ | ETF | 114.29 | 114.34 | 114.29 | 114.29 | 22600.0 |
| 2015-12-29 04:00:00 | IWM | ETF | 114.18 | 114.4 | 114.12 | 114.32 | 11202.0 |
| 2015-12-29 06:00:00 | IWM | ETF | 114.3 | 114.3 | 114.2 | 114.2 | 10258.0 |
| 2015-12-29 07:00:00 | IWM | ETF | 114.27 | 114.45 | 114.27 | 114.34 | 33698.0 |
| 2015-12-29 08:00:00 | IWM | ETF | 114.35 | 114.59 | 114.35 | 114.54 | 32635.0 |
| 2015-12-29 09:00:00 | IWM | ETF | 114.54 | 115.13 | 114.44 | 115.02 | 2658174.0 |
| 2015-12-29 10:00:00 | IWM | ETF | 115.02 | 115.14 | 114.695 | 114.7169 | 2174513.0 |
| 2015-12-29 11:00:00 | IWM | ETF | 114.7175 | 114.91 | 114.065 | 114.255 | 2088563.0 |
| 2015-12-29 12:00:00 | IWM | ETF | 114.255 | 114.52 | 114.25 | 114.43 | 1346159.0 |
| 2015-12-29 13:00:00 | IWM | ETF | 114.43 | 114.99 | 114.3701 | 114.94 | 1835492.0 |
| 2015-12-29 14:00:00 | IWM | ETF | 114.94 | 115.07 | 114.82 | 115.06 | 2676862.0 |
| 2015-12-29 15:00:00 | IWM | ETF | 115.06 | 115.29 | 114.92 | 115.2 | 4864598.0 |
| 2015-12-29 16:00:00 | IWM | ETF | 115.2 | 115.49 | 115.14 | 115.44 | 2480238.0 |
| 2015-12-29 17:00:00 | IWM | ETF | 115.43 | 115.45 | 115.34 | 115.34 | 9319.0 |
| 2015-12-29 18:00:00 | IWM | ETF | 115.33 | 115.33 | 115.25 | 115.25 | 500.0 |
| 2015-12-29 19:00:00 | IWM | ETF | 115.27 | 115.29 | 115.23 | 115.29 | 5500.0 |
| 2015-12-29 07:00:00 | DIA | ETF | 175.86 | 175.86 | 175.86 | 175.86 | 100.0 |
| 2015-12-29 08:00:00 | DIA | ETF | 175.8 | 176.41 | 175.8 | 176.35 | 12380.0 |
| 2015-12-29 09:00:00 | DIA | ETF | 176.19 | 176.8 | 176.0 | 176.73 | 690330.0 |
> showing 50 of 8,003 rows — these rows as CSV