PREVIEW / etf_1hour / 2015-07-01
file: by_date/etf_1hour/2015/2015-07-01.parquet size: 251 KB rows: 8,076
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-07-01 04:00:00 | SPY | ETF | 206.78 | 207.72 | 206.78 | 207.62 | 68195.0 |
| 2015-07-01 05:00:00 | SPY | ETF | 207.7 | 208.35 | 207.49 | 207.7 | 521850.0 |
| 2015-07-01 06:00:00 | SPY | ETF | 207.72 | 207.91 | 207.51 | 207.72 | 249784.0 |
| 2015-07-01 07:00:00 | SPY | ETF | 207.74 | 207.8 | 207.4 | 207.48 | 682039.0 |
| 2015-07-01 08:00:00 | SPY | ETF | 207.49 | 208.16 | 205.85 | 207.6 | 1735340.0 |
| 2015-07-01 09:00:00 | SPY | ETF | 207.6 | 207.91 | 205.85 | 207.83 | 17505367.0 |
| 2015-07-01 10:00:00 | SPY | ETF | 207.84 | 208.03 | 206.95 | 207.33 | 27172264.0 |
| 2015-07-01 11:00:00 | SPY | ETF | 207.331 | 207.56 | 207.14 | 207.18 | 9319789.0 |
| 2015-07-01 12:00:00 | SPY | ETF | 207.17 | 207.37 | 206.78 | 206.85 | 12741247.0 |
| 2015-07-01 13:00:00 | SPY | ETF | 206.84 | 207.28 | 206.67 | 206.85 | 10594038.0 |
| 2015-07-01 14:00:00 | SPY | ETF | 206.85 | 207.04 | 206.56 | 206.945 | 14963706.0 |
| 2015-07-01 15:00:00 | SPY | ETF | 206.95 | 207.57 | 206.94 | 207.52 | 28298871.0 |
| 2015-07-01 16:00:00 | SPY | ETF | 207.52 | 207.8 | 206.0613 | 207.77 | 9362878.0 |
| 2015-07-01 17:00:00 | SPY | ETF | 207.76 | 207.8 | 207.73 | 207.76 | 93992.0 |
| 2015-07-01 18:00:00 | SPY | ETF | 207.76 | 207.77 | 207.64 | 207.65 | 172731.0 |
| 2015-07-01 19:00:00 | SPY | ETF | 207.65 | 207.66 | 207.55 | 207.57 | 42308.0 |
| 2015-07-01 04:00:00 | QQQ | ETF | 107.63 | 108.0 | 107.63 | 108.0 | 600.0 |
| 2015-07-01 05:00:00 | QQQ | ETF | 108.0 | 108.47 | 108.0 | 108.47 | 15000.0 |
| 2015-07-01 06:00:00 | QQQ | ETF | 108.15 | 108.16 | 108.04 | 108.16 | 9200.0 |
| 2015-07-01 07:00:00 | QQQ | ETF | 108.14 | 108.17 | 108.0 | 108.03 | 35012.0 |
| 2015-07-01 08:00:00 | QQQ | ETF | 108.03 | 108.15 | 107.07 | 108.09 | 139182.0 |
| 2015-07-01 09:00:00 | QQQ | ETF | 108.1 | 108.3 | 107.07 | 108.27 | 3498056.0 |
| 2015-07-01 10:00:00 | QQQ | ETF | 108.28 | 108.3464 | 107.72 | 107.94 | 4432251.0 |
| 2015-07-01 11:00:00 | QQQ | ETF | 107.94 | 108.03 | 107.755 | 107.795 | 1788925.0 |
| 2015-07-01 12:00:00 | QQQ | ETF | 107.8 | 107.88 | 107.53 | 107.55 | 2214954.0 |
| 2015-07-01 13:00:00 | QQQ | ETF | 107.55 | 107.83 | 107.46 | 107.56 | 1791664.0 |
| 2015-07-01 14:00:00 | QQQ | ETF | 107.56 | 107.7 | 107.42 | 107.645 | 2057350.0 |
| 2015-07-01 15:00:00 | QQQ | ETF | 107.65 | 107.94 | 107.64 | 107.91 | 3298123.0 |
| 2015-07-01 16:00:00 | QQQ | ETF | 107.91 | 108.01 | 107.8194 | 108.01 | 697865.0 |
| 2015-07-01 17:00:00 | QQQ | ETF | 107.99 | 108.01 | 107.94 | 107.97 | 9954.0 |
| 2015-07-01 18:00:00 | QQQ | ETF | 107.98 | 108.01 | 107.92 | 107.97 | 8764.0 |
| 2015-07-01 19:00:00 | QQQ | ETF | 107.93 | 107.95 | 107.87 | 107.91 | 9260.0 |
| 2015-07-01 05:00:00 | IWM | ETF | 125.8 | 126.26 | 125.8 | 126.09 | 4600.0 |
| 2015-07-01 06:00:00 | IWM | ETF | 126.07 | 126.07 | 125.84 | 126.0 | 13100.0 |
| 2015-07-01 07:00:00 | IWM | ETF | 125.99 | 125.99 | 125.76 | 125.8 | 19100.0 |
| 2015-07-01 08:00:00 | IWM | ETF | 124.86 | 125.95 | 124.86 | 125.86 | 385857.0 |
| 2015-07-01 09:00:00 | IWM | ETF | 125.89 | 126.13 | 124.86 | 125.81 | 3937634.0 |
| 2015-07-01 10:00:00 | IWM | ETF | 125.84 | 126.16 | 125.22 | 125.53 | 4898755.0 |
| 2015-07-01 11:00:00 | IWM | ETF | 125.53 | 125.6564 | 125.28 | 125.31 | 1777776.0 |
| 2015-07-01 12:00:00 | IWM | ETF | 125.3 | 125.4 | 124.61 | 124.649 | 2630288.0 |
| 2015-07-01 13:00:00 | IWM | ETF | 124.65 | 125.19 | 124.55 | 124.87 | 2404079.0 |
| 2015-07-01 14:00:00 | IWM | ETF | 124.87 | 124.95 | 124.06 | 124.875 | 2607666.0 |
| 2015-07-01 15:00:00 | IWM | ETF | 124.88 | 125.28 | 124.87 | 125.26 | 4044466.0 |
| 2015-07-01 16:00:00 | IWM | ETF | 125.24 | 125.3 | 125.08 | 125.23 | 928497.0 |
| 2015-07-01 17:00:00 | IWM | ETF | 125.22 | 125.22 | 125.17 | 125.18 | 745.0 |
| 2015-07-01 18:00:00 | IWM | ETF | 125.18 | 125.18 | 125.1 | 125.1 | 400.0 |
| 2015-07-01 19:00:00 | IWM | ETF | 125.09 | 125.09 | 125.08 | 125.08 | 300.0 |
| 2015-07-01 05:00:00 | DIA | ETF | 177.53 | 177.74 | 177.53 | 177.74 | 3900.0 |
| 2015-07-01 06:00:00 | DIA | ETF | 177.37 | 177.37 | 177.24 | 177.36 | 1000.0 |
| 2015-07-01 07:00:00 | DIA | ETF | 177.48 | 177.48 | 177.37 | 177.4 | 6175.0 |
> showing 50 of 8,076 rows — these rows as CSV