PREVIEW / etf_1hour / 2015-03-19
file: by_date/etf_1hour/2015/2015-03-19.parquet size: 237 KB rows: 7,510
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-03-19 04:00:00 | SPY | ETF | 210.71 | 210.92 | 210.05 | 210.05 | 137986.0 |
| 2015-03-19 05:00:00 | SPY | ETF | 210.01 | 210.24 | 209.85 | 210.2 | 8851.0 |
| 2015-03-19 06:00:00 | SPY | ETF | 210.16 | 210.49 | 210.16 | 210.45 | 106173.0 |
| 2015-03-19 07:00:00 | SPY | ETF | 210.46 | 210.46 | 210.2 | 210.28 | 268487.0 |
| 2015-03-19 08:00:00 | SPY | ETF | 210.28 | 210.41 | 209.74 | 209.93 | 1364525.0 |
| 2015-03-19 09:00:00 | SPY | ETF | 209.92 | 210.1 | 209.49 | 210.02 | 12241230.0 |
| 2015-03-19 10:00:00 | SPY | ETF | 209.99 | 210.4697 | 209.475 | 209.711 | 15895117.0 |
| 2015-03-19 11:00:00 | SPY | ETF | 209.71 | 209.87 | 209.03 | 209.32 | 13343192.0 |
| 2015-03-19 12:00:00 | SPY | ETF | 209.345 | 209.46 | 209.07 | 209.1728 | 14527704.0 |
| 2015-03-19 13:00:00 | SPY | ETF | 209.17 | 209.76 | 209.07 | 209.36 | 8775851.0 |
| 2015-03-19 14:00:00 | SPY | ETF | 209.35 | 209.81 | 209.32 | 209.68 | 11792344.0 |
| 2015-03-19 15:00:00 | SPY | ETF | 209.69 | 209.85 | 209.31 | 209.48 | 24457881.0 |
| 2015-03-19 16:00:00 | SPY | ETF | 209.48 | 209.65 | 209.3319 | 209.44 | 6265942.0 |
| 2015-03-19 17:00:00 | SPY | ETF | 209.43 | 209.5 | 209.28 | 209.34 | 4486215.0 |
| 2015-03-19 18:00:00 | SPY | ETF | 209.31 | 209.31 | 209.18 | 209.18 | 83224.0 |
| 2015-03-19 19:00:00 | SPY | ETF | 209.18 | 209.45 | 209.18 | 209.43 | 58227.0 |
| 2015-03-19 04:00:00 | QQQ | ETF | 108.1 | 108.4 | 108.0 | 108.0 | 7278.0 |
| 2015-03-19 06:00:00 | QQQ | ETF | 108.06 | 108.12 | 108.06 | 108.11 | 7600.0 |
| 2015-03-19 07:00:00 | QQQ | ETF | 108.08 | 108.13 | 108.04 | 108.08 | 223654.0 |
| 2015-03-19 08:00:00 | QQQ | ETF | 108.07 | 108.1 | 107.9 | 107.985 | 355005.0 |
| 2015-03-19 09:00:00 | QQQ | ETF | 107.98 | 108.25 | 107.9 | 108.2 | 3077853.0 |
| 2015-03-19 10:00:00 | QQQ | ETF | 108.2 | 108.38 | 108.03 | 108.1999 | 4750184.0 |
| 2015-03-19 11:00:00 | QQQ | ETF | 108.19 | 108.28 | 108.0 | 108.17 | 3345059.0 |
| 2015-03-19 12:00:00 | QQQ | ETF | 108.17 | 108.22 | 107.925 | 107.94 | 2290848.0 |
| 2015-03-19 13:00:00 | QQQ | ETF | 107.93 | 108.29 | 107.87 | 108.07 | 2282084.0 |
| 2015-03-19 14:00:00 | QQQ | ETF | 108.08 | 108.285 | 108.05 | 108.255 | 1980878.0 |
| 2015-03-19 15:00:00 | QQQ | ETF | 108.255 | 108.31 | 108.04 | 108.06 | 4683616.0 |
| 2015-03-19 16:00:00 | QQQ | ETF | 108.07 | 108.224 | 107.9476 | 108.09 | 2723487.0 |
| 2015-03-19 17:00:00 | QQQ | ETF | 108.08 | 108.08 | 108.01 | 108.08 | 9116.0 |
| 2015-03-19 18:00:00 | QQQ | ETF | 108.03 | 108.03 | 108.0 | 108.0 | 11825.0 |
| 2015-03-19 19:00:00 | QQQ | ETF | 108.01 | 108.08 | 108.01 | 108.06 | 6500.0 |
| 2015-03-19 05:00:00 | IWM | ETF | 124.31 | 124.35 | 124.31 | 124.31 | 300.0 |
| 2015-03-19 06:00:00 | IWM | ETF | 124.31 | 124.41 | 124.31 | 124.41 | 2100.0 |
| 2015-03-19 07:00:00 | IWM | ETF | 124.41 | 124.42 | 124.41 | 124.41 | 2100.0 |
| 2015-03-19 08:00:00 | IWM | ETF | 124.53 | 124.53 | 124.11 | 124.17 | 247850.0 |
| 2015-03-19 09:00:00 | IWM | ETF | 124.2 | 124.76 | 124.16 | 124.69 | 3494936.0 |
| 2015-03-19 10:00:00 | IWM | ETF | 124.72 | 124.89 | 124.54 | 124.85 | 2584257.0 |
| 2015-03-19 11:00:00 | IWM | ETF | 124.84 | 124.855 | 124.44 | 124.535 | 1888397.0 |
| 2015-03-19 12:00:00 | IWM | ETF | 124.535 | 124.63 | 124.42 | 124.48 | 1466197.0 |
| 2015-03-19 13:00:00 | IWM | ETF | 124.47 | 124.78 | 124.44 | 124.67 | 2362313.0 |
| 2015-03-19 14:00:00 | IWM | ETF | 124.675 | 124.9 | 124.67 | 124.88 | 2925735.0 |
| 2015-03-19 15:00:00 | IWM | ETF | 124.88 | 124.96 | 124.73 | 124.89 | 4175589.0 |
| 2015-03-19 16:00:00 | IWM | ETF | 124.89 | 125.07 | 124.87 | 125.05 | 2528089.0 |
| 2015-03-19 17:00:00 | IWM | ETF | 125.04 | 125.08 | 124.89 | 124.89 | 41499.0 |
| 2015-03-19 18:00:00 | IWM | ETF | 125.03 | 125.05 | 125.03 | 125.05 | 2400.0 |
| 2015-03-19 19:00:00 | IWM | ETF | 124.96 | 125.04 | 124.96 | 124.97 | 50780.0 |
| 2015-03-19 08:00:00 | DIA | ETF | 180.35 | 180.56 | 180.2 | 180.28 | 6860.0 |
| 2015-03-19 09:00:00 | DIA | ETF | 180.22 | 180.31 | 179.7272 | 180.13 | 950316.0 |
| 2015-03-19 10:00:00 | DIA | ETF | 180.12 | 180.39 | 179.7236 | 179.89 | 1033454.0 |
| 2015-03-19 11:00:00 | DIA | ETF | 179.91 | 180.07 | 179.31 | 179.58 | 754887.0 |
> showing 50 of 7,510 rows — these rows as CSV