PREVIEW / etf_1hour / 2015-10-19
file: by_date/etf_1hour/2015/2015-10-19.parquet size: 238 KB rows: 7,608
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-19 04:00:00 | SPY | ETF | 203.4 | 203.4 | 203.05 | 203.16 | 13838.0 |
| 2015-10-19 05:00:00 | SPY | ETF | 203.16 | 203.16 | 202.95 | 203.03 | 22268.0 |
| 2015-10-19 06:00:00 | SPY | ETF | 203.03 | 203.1 | 202.9 | 202.9 | 103666.0 |
| 2015-10-19 07:00:00 | SPY | ETF | 202.96 | 202.98 | 202.59 | 202.66 | 234161.0 |
| 2015-10-19 08:00:00 | SPY | ETF | 202.68 | 203.27 | 202.32 | 202.34 | 1115271.0 |
| 2015-10-19 09:00:00 | SPY | ETF | 202.34 | 202.9 | 202.13 | 202.87 | 9550342.0 |
| 2015-10-19 10:00:00 | SPY | ETF | 202.875 | 203.075 | 202.49 | 202.91 | 10693290.0 |
| 2015-10-19 11:00:00 | SPY | ETF | 202.91 | 203.37 | 202.67 | 203.21 | 7982623.0 |
| 2015-10-19 12:00:00 | SPY | ETF | 203.21 | 203.34 | 202.85 | 203.0134 | 5635377.0 |
| 2015-10-19 13:00:00 | SPY | ETF | 203.015 | 203.1 | 202.35 | 202.7 | 7560381.0 |
| 2015-10-19 14:00:00 | SPY | ETF | 202.705 | 202.9 | 202.51 | 202.86 | 7073079.0 |
| 2015-10-19 15:00:00 | SPY | ETF | 202.86 | 203.37 | 202.81 | 203.33 | 19025015.0 |
| 2015-10-19 16:00:00 | SPY | ETF | 203.32 | 203.44 | 202.9643 | 203.38 | 4759176.0 |
| 2015-10-19 17:00:00 | SPY | ETF | 203.35 | 203.39 | 203.3 | 203.31 | 1521884.0 |
| 2015-10-19 18:00:00 | SPY | ETF | 203.31 | 203.35 | 203.2 | 203.25 | 95517.0 |
| 2015-10-19 19:00:00 | SPY | ETF | 203.23 | 203.28 | 203.16 | 203.24 | 45864.0 |
| 2015-10-19 04:00:00 | QQQ | ETF | 108.3 | 108.39 | 108.28 | 108.39 | 21200.0 |
| 2015-10-19 05:00:00 | QQQ | ETF | 108.29 | 108.29 | 108.23 | 108.26 | 8200.0 |
| 2015-10-19 06:00:00 | QQQ | ETF | 108.24 | 108.28 | 108.23 | 108.23 | 7800.0 |
| 2015-10-19 07:00:00 | QQQ | ETF | 108.22 | 108.23 | 108.05 | 108.05 | 17932.0 |
| 2015-10-19 08:00:00 | QQQ | ETF | 108.07 | 108.07 | 107.77 | 107.79 | 104460.0 |
| 2015-10-19 09:00:00 | QQQ | ETF | 107.8 | 108.29 | 107.74 | 108.2799 | 2623478.0 |
| 2015-10-19 10:00:00 | QQQ | ETF | 108.28 | 108.47 | 108.06 | 108.46 | 4546683.0 |
| 2015-10-19 11:00:00 | QQQ | ETF | 108.46 | 108.81 | 108.33 | 108.76 | 2789199.0 |
| 2015-10-19 12:00:00 | QQQ | ETF | 108.75 | 108.81 | 108.45 | 108.5786 | 1824749.0 |
| 2015-10-19 13:00:00 | QQQ | ETF | 108.58 | 108.634 | 108.02 | 108.2801 | 2672580.0 |
| 2015-10-19 14:00:00 | QQQ | ETF | 108.29 | 108.55 | 108.2 | 108.54 | 1743243.0 |
| 2015-10-19 15:00:00 | QQQ | ETF | 108.54 | 108.79 | 108.48 | 108.75 | 4544917.0 |
| 2015-10-19 16:00:00 | QQQ | ETF | 108.74 | 108.85 | 108.69 | 108.78 | 576738.0 |
| 2015-10-19 17:00:00 | QQQ | ETF | 108.1769 | 108.81 | 108.1769 | 108.76 | 529935.0 |
| 2015-10-19 18:00:00 | QQQ | ETF | 108.74 | 108.74 | 108.67 | 108.67 | 53598.0 |
| 2015-10-19 19:00:00 | QQQ | ETF | 108.68 | 108.73 | 108.68 | 108.72 | 15432.0 |
| 2015-10-19 04:00:00 | IWM | ETF | 115.1 | 115.22 | 115.1 | 115.15 | 600.0 |
| 2015-10-19 05:00:00 | IWM | ETF | 115.12 | 115.12 | 115.12 | 115.12 | 100.0 |
| 2015-10-19 06:00:00 | IWM | ETF | 115.03 | 115.03 | 115.03 | 115.03 | 200.0 |
| 2015-10-19 07:00:00 | IWM | ETF | 115.01 | 115.03 | 114.88 | 114.88 | 4899.0 |
| 2015-10-19 08:00:00 | IWM | ETF | 114.88 | 114.88 | 114.67 | 114.67 | 170121.0 |
| 2015-10-19 09:00:00 | IWM | ETF | 114.68 | 115.58 | 114.63 | 115.57 | 2240097.0 |
| 2015-10-19 10:00:00 | IWM | ETF | 115.58 | 115.99 | 115.45 | 115.68 | 3869512.0 |
| 2015-10-19 11:00:00 | IWM | ETF | 115.67 | 116.21 | 115.43 | 116.05 | 3955750.0 |
| 2015-10-19 12:00:00 | IWM | ETF | 116.05 | 116.12 | 115.19 | 115.32 | 2973104.0 |
| 2015-10-19 13:00:00 | IWM | ETF | 115.32 | 115.4 | 114.65 | 115.12 | 3658552.0 |
| 2015-10-19 14:00:00 | IWM | ETF | 115.1265 | 115.435 | 115.01 | 115.36 | 1793193.0 |
| 2015-10-19 15:00:00 | IWM | ETF | 115.37 | 115.7 | 115.29 | 115.62 | 4123013.0 |
| 2015-10-19 16:00:00 | IWM | ETF | 115.62 | 116.1023 | 115.3677 | 115.63 | 743752.0 |
| 2015-10-19 18:00:00 | IWM | ETF | 115.5 | 115.51 | 115.5 | 115.51 | 2761.0 |
| 2015-10-19 19:00:00 | IWM | ETF | 115.57 | 115.6 | 115.56 | 115.6 | 300.0 |
| 2015-10-19 05:00:00 | DIA | ETF | 171.65 | 171.65 | 171.59 | 171.59 | 5100.0 |
| 2015-10-19 06:00:00 | DIA | ETF | 171.73 | 171.74 | 171.73 | 171.74 | 2000.0 |
| 2015-10-19 07:00:00 | DIA | ETF | 171.6 | 171.69 | 171.36 | 171.36 | 22300.0 |
> showing 50 of 7,608 rows — these rows as CSV