PREVIEW / etf_1hour / 2015-05-01
file: by_date/etf_1hour/2015/2015-05-01.parquet size: 239 KB rows: 7,540
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-05-01 04:00:00 | SPY | ETF | 209.0 | 209.01 | 208.89 | 209.01 | 25900.0 |
| 2015-05-01 05:00:00 | SPY | ETF | 209.01 | 209.09 | 209.01 | 209.07 | 7200.0 |
| 2015-05-01 06:00:00 | SPY | ETF | 209.05 | 209.15 | 209.02 | 209.02 | 116301.0 |
| 2015-05-01 07:00:00 | SPY | ETF | 209.05 | 209.37 | 208.99 | 209.2 | 441664.0 |
| 2015-05-01 08:00:00 | SPY | ETF | 209.16 | 209.33 | 209.05 | 209.18 | 862586.0 |
| 2015-05-01 09:00:00 | SPY | ETF | 209.18 | 209.88 | 208.52 | 209.5399 | 14220204.0 |
| 2015-05-01 10:00:00 | SPY | ETF | 209.52 | 210.1 | 209.35 | 209.6 | 14611934.0 |
| 2015-05-01 11:00:00 | SPY | ETF | 209.61 | 210.1 | 209.28 | 209.6 | 9394446.0 |
| 2015-05-01 12:00:00 | SPY | ETF | 209.6 | 209.945 | 209.34 | 209.94 | 6738014.0 |
| 2015-05-01 13:00:00 | SPY | ETF | 209.94 | 210.49 | 209.785 | 210.38 | 10900989.0 |
| 2015-05-01 14:00:00 | SPY | ETF | 210.37 | 210.72 | 210.34 | 210.44 | 11163084.0 |
| 2015-05-01 15:00:00 | SPY | ETF | 210.45 | 210.77 | 210.21 | 210.69 | 20466097.0 |
| 2015-05-01 16:00:00 | SPY | ETF | 210.69 | 210.74 | 209.99 | 210.71 | 12598520.0 |
| 2015-05-01 17:00:00 | SPY | ETF | 210.7199 | 210.77 | 210.61 | 210.65 | 449980.0 |
| 2015-05-01 18:00:00 | SPY | ETF | 210.67 | 210.75 | 210.66 | 210.72 | 93889.0 |
| 2015-05-01 19:00:00 | SPY | ETF | 210.68 | 210.7 | 210.68 | 210.7 | 18655.0 |
| 2015-05-01 04:00:00 | QQQ | ETF | 107.71 | 107.71 | 107.71 | 107.71 | 400.0 |
| 2015-05-01 06:00:00 | QQQ | ETF | 107.75 | 107.86 | 107.75 | 107.79 | 8600.0 |
| 2015-05-01 07:00:00 | QQQ | ETF | 107.78 | 107.96 | 107.78 | 107.88 | 129610.0 |
| 2015-05-01 08:00:00 | QQQ | ETF | 107.88 | 107.9 | 107.75 | 107.84 | 79459.0 |
| 2015-05-01 09:00:00 | QQQ | ETF | 107.84 | 108.51 | 107.63 | 108.24 | 5577292.0 |
| 2015-05-01 10:00:00 | QQQ | ETF | 108.22 | 108.68 | 108.2 | 108.37 | 4573826.0 |
| 2015-05-01 11:00:00 | QQQ | ETF | 108.37 | 108.62 | 108.14 | 108.29 | 2712202.0 |
| 2015-05-01 12:00:00 | QQQ | ETF | 108.3 | 108.555 | 108.17 | 108.55 | 2320564.0 |
| 2015-05-01 13:00:00 | QQQ | ETF | 108.54 | 108.86 | 108.42 | 108.79 | 2549634.0 |
| 2015-05-01 14:00:00 | QQQ | ETF | 108.78 | 109.05 | 108.7757 | 108.89 | 3943279.0 |
| 2015-05-01 15:00:00 | QQQ | ETF | 108.89 | 109.12 | 108.77 | 109.08 | 6378384.0 |
| 2015-05-01 16:00:00 | QQQ | ETF | 109.08 | 109.08 | 109.0 | 109.07 | 1574182.0 |
| 2015-05-01 17:00:00 | QQQ | ETF | 109.07 | 109.1 | 109.05 | 109.05 | 62737.0 |
| 2015-05-01 18:00:00 | QQQ | ETF | 109.09 | 109.09 | 108.97 | 109.03 | 4541.0 |
| 2015-05-01 19:00:00 | QQQ | ETF | 109.03 | 109.03 | 108.96 | 108.99 | 11302.0 |
| 2015-05-01 06:00:00 | IWM | ETF | 121.9 | 121.9 | 121.9 | 121.9 | 5000.0 |
| 2015-05-01 07:00:00 | IWM | ETF | 121.84 | 121.94 | 121.68 | 121.68 | 47214.0 |
| 2015-05-01 08:00:00 | IWM | ETF | 121.67 | 121.79 | 121.6 | 121.67 | 421242.0 |
| 2015-05-01 09:00:00 | IWM | ETF | 121.69 | 122.115 | 121.16 | 121.49 | 4938713.0 |
| 2015-05-01 10:00:00 | IWM | ETF | 121.47 | 122.16 | 121.27 | 121.64 | 5431109.0 |
| 2015-05-01 11:00:00 | IWM | ETF | 121.63 | 121.76 | 120.95 | 121.23 | 5228080.0 |
| 2015-05-01 12:00:00 | IWM | ETF | 121.23 | 121.62 | 120.905 | 121.61 | 3009459.0 |
| 2015-05-01 13:00:00 | IWM | ETF | 121.61 | 121.95 | 121.44 | 121.87 | 2594493.0 |
| 2015-05-01 14:00:00 | IWM | ETF | 121.86 | 122.055 | 121.72 | 121.823 | 2873359.0 |
| 2015-05-01 15:00:00 | IWM | ETF | 121.827 | 122.085 | 121.66 | 121.95 | 6836356.0 |
| 2015-05-01 16:00:00 | IWM | ETF | 121.96 | 122.05 | 121.88 | 121.99 | 1824903.0 |
| 2015-05-01 17:00:00 | IWM | ETF | 122.03 | 122.07 | 121.95 | 121.95 | 133618.0 |
| 2015-05-01 19:00:00 | IWM | ETF | 121.95 | 121.97 | 121.95 | 121.95 | 1224.0 |
| 2015-05-01 07:00:00 | DIA | ETF | 178.95 | 179.0 | 178.95 | 179.0 | 300.0 |
| 2015-05-01 08:00:00 | DIA | ETF | 178.91 | 179.0 | 178.91 | 178.99 | 5110.0 |
| 2015-05-01 09:00:00 | DIA | ETF | 179.1 | 179.6 | 179.08 | 179.08 | 716880.0 |
| 2015-05-01 10:00:00 | DIA | ETF | 179.03 | 179.72 | 179.01 | 179.25 | 616594.0 |
| 2015-05-01 11:00:00 | DIA | ETF | 179.28 | 179.6801 | 178.98 | 179.25 | 469961.0 |
| 2015-05-01 12:00:00 | DIA | ETF | 179.25 | 179.43 | 178.99 | 179.43 | 243162.0 |
> showing 50 of 7,540 rows — these rows as CSV