PREVIEW / etf_1hour / 2015-10-12
file: by_date/etf_1hour/2015/2015-10-12.parquet size: 233 KB rows: 7,395
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-12 04:00:00 | SPY | ETF | 201.52 | 201.6 | 201.3 | 201.3 | 5303.0 |
| 2015-10-12 05:00:00 | SPY | ETF | 201.32 | 201.37 | 201.15 | 201.37 | 15089.0 |
| 2015-10-12 06:00:00 | SPY | ETF | 201.39 | 201.54 | 201.34 | 201.5 | 61164.0 |
| 2015-10-12 07:00:00 | SPY | ETF | 201.51 | 201.57 | 201.31 | 201.51 | 74507.0 |
| 2015-10-12 08:00:00 | SPY | ETF | 201.51 | 201.56 | 201.21 | 201.29 | 323263.0 |
| 2015-10-12 09:00:00 | SPY | ETF | 201.31 | 201.56 | 200.98 | 201.18 | 7232629.0 |
| 2015-10-12 10:00:00 | SPY | ETF | 201.17 | 201.44 | 200.91 | 201.05 | 7506599.0 |
| 2015-10-12 11:00:00 | SPY | ETF | 201.045 | 201.76 | 201.02 | 201.5 | 7491669.0 |
| 2015-10-12 12:00:00 | SPY | ETF | 201.49 | 201.67 | 201.31 | 201.41 | 3982006.0 |
| 2015-10-12 13:00:00 | SPY | ETF | 201.415 | 201.47 | 201.14 | 201.32 | 4676888.0 |
| 2015-10-12 14:00:00 | SPY | ETF | 201.325 | 201.49 | 201.25 | 201.39 | 9197374.0 |
| 2015-10-12 15:00:00 | SPY | ETF | 201.395 | 201.7 | 201.35 | 201.55 | 10266512.0 |
| 2015-10-12 16:00:00 | SPY | ETF | 201.57 | 202.06 | 201.3753 | 201.95 | 4599152.0 |
| 2015-10-12 17:00:00 | SPY | ETF | 201.96 | 201.96 | 201.78 | 201.89 | 199575.0 |
| 2015-10-12 18:00:00 | SPY | ETF | 201.83 | 201.87 | 201.71 | 201.71 | 121422.0 |
| 2015-10-12 19:00:00 | SPY | ETF | 201.74 | 201.77 | 201.69 | 201.74 | 30598.0 |
| 2015-10-12 04:00:00 | QQQ | ETF | 106.59 | 106.59 | 106.58 | 106.58 | 500.0 |
| 2015-10-12 05:00:00 | QQQ | ETF | 106.47 | 106.47 | 106.34 | 106.35 | 2200.0 |
| 2015-10-12 06:00:00 | QQQ | ETF | 106.45 | 106.5 | 106.45 | 106.48 | 1450.0 |
| 2015-10-12 07:00:00 | QQQ | ETF | 106.58 | 106.58 | 106.45 | 106.58 | 10851.0 |
| 2015-10-12 08:00:00 | QQQ | ETF | 106.53 | 106.69 | 106.53 | 106.68 | 45466.0 |
| 2015-10-12 09:00:00 | QQQ | ETF | 106.69 | 106.87 | 106.39 | 106.56 | 2415017.0 |
| 2015-10-12 10:00:00 | QQQ | ETF | 106.53 | 106.73 | 106.35 | 106.58 | 3415337.0 |
| 2015-10-12 11:00:00 | QQQ | ETF | 106.58 | 106.9899 | 106.56 | 106.8 | 1984542.0 |
| 2015-10-12 12:00:00 | QQQ | ETF | 106.8 | 106.95 | 106.685 | 106.71 | 1226781.0 |
| 2015-10-12 13:00:00 | QQQ | ETF | 106.72 | 106.8131 | 106.56 | 106.73 | 1149399.0 |
| 2015-10-12 14:00:00 | QQQ | ETF | 106.73 | 106.86 | 106.7 | 106.74 | 1162536.0 |
| 2015-10-12 15:00:00 | QQQ | ETF | 106.74 | 106.91 | 106.69 | 106.78 | 3512605.0 |
| 2015-10-12 16:00:00 | QQQ | ETF | 106.79 | 107.02 | 106.74 | 106.95 | 420276.0 |
| 2015-10-12 17:00:00 | QQQ | ETF | 106.95 | 106.96 | 106.88 | 106.92 | 2021.0 |
| 2015-10-12 18:00:00 | QQQ | ETF | 106.89 | 106.92 | 106.88 | 106.88 | 3123.0 |
| 2015-10-12 19:00:00 | QQQ | ETF | 106.83 | 106.83 | 106.81 | 106.82 | 950.0 |
| 2015-10-12 06:00:00 | IWM | ETF | 115.84 | 115.85 | 115.84 | 115.85 | 500.0 |
| 2015-10-12 07:00:00 | IWM | ETF | 115.84 | 115.84 | 115.78 | 115.82 | 1380.0 |
| 2015-10-12 08:00:00 | IWM | ETF | 115.88 | 115.88 | 115.64 | 115.67 | 9445.0 |
| 2015-10-12 09:00:00 | IWM | ETF | 115.7 | 115.9899 | 115.31 | 115.45 | 2322031.0 |
| 2015-10-12 10:00:00 | IWM | ETF | 115.43 | 115.68 | 115.07 | 115.44 | 3298441.0 |
| 2015-10-12 11:00:00 | IWM | ETF | 115.44 | 115.88 | 115.41 | 115.59 | 2208675.0 |
| 2015-10-12 12:00:00 | IWM | ETF | 115.58 | 115.71 | 115.38 | 115.48 | 1897764.0 |
| 2015-10-12 13:00:00 | IWM | ETF | 115.48 | 115.6 | 115.27 | 115.46 | 1393670.0 |
| 2015-10-12 14:00:00 | IWM | ETF | 115.46 | 115.68 | 115.45 | 115.47 | 1800026.0 |
| 2015-10-12 15:00:00 | IWM | ETF | 115.46 | 115.66 | 115.425 | 115.58 | 3352896.0 |
| 2015-10-12 16:00:00 | IWM | ETF | 115.59 | 115.92 | 115.49 | 115.82 | 1206992.0 |
| 2015-10-12 17:00:00 | IWM | ETF | 115.84 | 115.85 | 115.82 | 115.82 | 11415.0 |
| 2015-10-12 18:00:00 | IWM | ETF | 115.77 | 115.77 | 115.77 | 115.77 | 200.0 |
| 2015-10-12 19:00:00 | IWM | ETF | 115.78 | 115.81 | 115.78 | 115.8 | 3119.0 |
| 2015-10-12 07:00:00 | DIA | ETF | 170.85 | 170.9 | 170.85 | 170.9 | 1100.0 |
| 2015-10-12 08:00:00 | DIA | ETF | 170.89 | 170.89 | 170.79 | 170.83 | 900.0 |
| 2015-10-12 09:00:00 | DIA | ETF | 170.67 | 170.94 | 170.47 | 170.77 | 434847.0 |
| 2015-10-12 10:00:00 | DIA | ETF | 170.74 | 170.94 | 170.54 | 170.66 | 575380.0 |
> showing 50 of 7,395 rows — these rows as CSV