PREVIEW / etf_1hour / 2015-09-16
file: by_date/etf_1hour/2015/2015-09-16.parquet size: 240 KB rows: 7,653
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-09-16 04:00:00 | SPY | ETF | 198.55 | 198.68 | 198.3 | 198.4 | 29507.0 |
| 2015-09-16 05:00:00 | SPY | ETF | 198.43 | 198.68 | 198.3 | 198.3 | 26535.0 |
| 2015-09-16 06:00:00 | SPY | ETF | 198.28 | 198.59 | 198.2 | 198.59 | 77109.0 |
| 2015-09-16 07:00:00 | SPY | ETF | 198.6 | 198.79 | 198.51 | 198.75 | 413246.0 |
| 2015-09-16 08:00:00 | SPY | ETF | 198.7 | 198.73 | 198.06 | 198.47 | 666887.0 |
| 2015-09-16 09:00:00 | SPY | ETF | 198.48 | 199.12 | 198.46 | 198.68 | 10583339.0 |
| 2015-09-16 10:00:00 | SPY | ETF | 198.69 | 199.06 | 198.41 | 198.81 | 9949003.0 |
| 2015-09-16 11:00:00 | SPY | ETF | 198.81 | 199.75 | 198.72 | 199.66 | 14499593.0 |
| 2015-09-16 12:00:00 | SPY | ETF | 199.67 | 200.09 | 199.51 | 200.0402 | 9582182.0 |
| 2015-09-16 13:00:00 | SPY | ETF | 200.03 | 200.035 | 199.55 | 199.84 | 7596241.0 |
| 2015-09-16 14:00:00 | SPY | ETF | 199.85 | 200.06 | 199.22 | 199.97 | 11074692.0 |
| 2015-09-16 15:00:00 | SPY | ETF | 199.97 | 200.41 | 199.84 | 200.19 | 25031050.0 |
| 2015-09-16 16:00:00 | SPY | ETF | 200.21 | 200.63 | 198.4773 | 200.45 | 8545150.0 |
| 2015-09-16 17:00:00 | SPY | ETF | 200.47 | 200.53 | 200.197 | 200.38 | 242358.0 |
| 2015-09-16 18:00:00 | SPY | ETF | 200.42 | 200.43 | 200.28 | 200.37 | 207507.0 |
| 2015-09-16 19:00:00 | SPY | ETF | 200.38 | 200.4 | 200.24 | 200.25 | 97625.0 |
| 2015-09-16 04:00:00 | QQQ | ETF | 106.51 | 106.51 | 106.39 | 106.42 | 14000.0 |
| 2015-09-16 05:00:00 | QQQ | ETF | 106.46 | 106.48 | 106.39 | 106.39 | 5500.0 |
| 2015-09-16 06:00:00 | QQQ | ETF | 106.39 | 106.54 | 106.36 | 106.54 | 9100.0 |
| 2015-09-16 07:00:00 | QQQ | ETF | 106.56 | 106.63 | 106.52 | 106.61 | 36931.0 |
| 2015-09-16 08:00:00 | QQQ | ETF | 106.64 | 106.64 | 106.4 | 106.44 | 148424.0 |
| 2015-09-16 09:00:00 | QQQ | ETF | 106.45 | 106.71 | 106.15 | 106.27 | 3442527.0 |
| 2015-09-16 10:00:00 | QQQ | ETF | 106.28 | 106.55 | 106.14 | 106.34 | 2943046.0 |
| 2015-09-16 11:00:00 | QQQ | ETF | 106.35 | 106.86 | 106.27 | 106.77 | 3336073.0 |
| 2015-09-16 12:00:00 | QQQ | ETF | 106.779 | 107.03 | 106.67 | 106.96 | 2605852.0 |
| 2015-09-16 13:00:00 | QQQ | ETF | 106.95 | 106.95 | 106.64 | 106.84 | 1741691.0 |
| 2015-09-16 14:00:00 | QQQ | ETF | 106.84 | 106.93 | 106.42 | 106.865 | 2868042.0 |
| 2015-09-16 15:00:00 | QQQ | ETF | 106.87 | 107.19 | 106.83 | 107.08 | 10771256.0 |
| 2015-09-16 16:00:00 | QQQ | ETF | 107.08 | 107.28 | 107.04 | 107.19 | 866728.0 |
| 2015-09-16 17:00:00 | QQQ | ETF | 107.18 | 107.19 | 107.14 | 107.15 | 6160.0 |
| 2015-09-16 18:00:00 | QQQ | ETF | 107.15 | 107.16 | 107.13 | 107.15 | 9190.0 |
| 2015-09-16 19:00:00 | QQQ | ETF | 107.16 | 107.17 | 107.12 | 107.12 | 4485.0 |
| 2015-09-16 04:00:00 | IWM | ETF | 116.05 | 116.05 | 116.05 | 116.05 | 302.0 |
| 2015-09-16 06:00:00 | IWM | ETF | 115.96 | 115.97 | 115.96 | 115.97 | 1600.0 |
| 2015-09-16 07:00:00 | IWM | ETF | 116.18 | 116.19 | 116.18 | 116.19 | 23000.0 |
| 2015-09-16 08:00:00 | IWM | ETF | 116.16 | 116.21 | 115.99 | 116.01 | 140649.0 |
| 2015-09-16 09:00:00 | IWM | ETF | 116.01 | 116.45 | 115.86 | 115.9 | 2828667.0 |
| 2015-09-16 10:00:00 | IWM | ETF | 115.9 | 116.32 | 115.79 | 116.19 | 2126757.0 |
| 2015-09-16 11:00:00 | IWM | ETF | 116.1828 | 116.84 | 116.16 | 116.59 | 3219653.0 |
| 2015-09-16 12:00:00 | IWM | ETF | 116.6 | 116.955 | 116.53 | 116.83 | 1683106.0 |
| 2015-09-16 13:00:00 | IWM | ETF | 116.82 | 116.82 | 116.5 | 116.75 | 1312563.0 |
| 2015-09-16 14:00:00 | IWM | ETF | 116.759 | 116.759 | 116.22 | 116.67 | 2651280.0 |
| 2015-09-16 15:00:00 | IWM | ETF | 116.68 | 117.02 | 116.63 | 116.93 | 8454478.0 |
| 2015-09-16 16:00:00 | IWM | ETF | 116.92 | 117.16 | 116.7485 | 117.0 | 923005.0 |
| 2015-09-16 17:00:00 | IWM | ETF | 116.98 | 117.05 | 116.98 | 117.05 | 7520.0 |
| 2015-09-16 18:00:00 | IWM | ETF | 117.08 | 117.08 | 117.05 | 117.05 | 6350.0 |
| 2015-09-16 19:00:00 | IWM | ETF | 117.0 | 117.0 | 116.99 | 116.99 | 310.0 |
| 2015-09-16 06:00:00 | DIA | ETF | 165.92 | 165.92 | 165.92 | 165.92 | 100.0 |
| 2015-09-16 07:00:00 | DIA | ETF | 166.3 | 166.35 | 166.3 | 166.35 | 2924.0 |
| 2015-09-16 08:00:00 | DIA | ETF | 166.2 | 166.2 | 166.2 | 166.2 | 900.0 |
> showing 50 of 7,653 rows — these rows as CSV