PREVIEW / etf_1hour / 2015-02-03
file: by_date/etf_1hour/2015/2015-02-03.parquet size: 247 KB rows: 7,811
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-02-03 04:00:00 | SPY | ETF | 202.87 | 202.99 | 202.15 | 202.21 | 14850.0 |
| 2015-02-03 05:00:00 | SPY | ETF | 202.2 | 202.76 | 202.2 | 202.59 | 33763.0 |
| 2015-02-03 06:00:00 | SPY | ETF | 202.55 | 203.2 | 202.5 | 202.97 | 210419.0 |
| 2015-02-03 07:00:00 | SPY | ETF | 202.96 | 203.14 | 202.59 | 202.75 | 458927.0 |
| 2015-02-03 08:00:00 | SPY | ETF | 202.3 | 202.96 | 202.3 | 202.88 | 1134711.0 |
| 2015-02-03 09:00:00 | SPY | ETF | 202.9 | 203.89 | 202.82 | 203.82 | 17286324.0 |
| 2015-02-03 10:00:00 | SPY | ETF | 203.81 | 203.86 | 202.74 | 202.76 | 17900661.0 |
| 2015-02-03 11:00:00 | SPY | ETF | 202.75 | 203.54 | 202.67 | 202.8 | 12136575.0 |
| 2015-02-03 12:00:00 | SPY | ETF | 202.8 | 203.43 | 202.55 | 203.22 | 9283683.0 |
| 2015-02-03 13:00:00 | SPY | ETF | 203.22 | 204.32 | 203.12 | 204.29 | 12754648.0 |
| 2015-02-03 14:00:00 | SPY | ETF | 204.3 | 204.48 | 203.63 | 204.2 | 13098499.0 |
| 2015-02-03 15:00:00 | SPY | ETF | 204.21 | 204.85 | 204.041 | 204.8 | 29682459.0 |
| 2015-02-03 16:00:00 | SPY | ETF | 204.8 | 204.84 | 203.6572 | 204.59 | 7956959.0 |
| 2015-02-03 17:00:00 | SPY | ETF | 204.58 | 204.61 | 204.52 | 204.55 | 1186725.0 |
| 2015-02-03 18:00:00 | SPY | ETF | 204.53 | 204.59 | 204.38 | 204.4 | 194762.0 |
| 2015-02-03 19:00:00 | SPY | ETF | 204.4 | 204.65 | 204.4 | 204.63 | 147586.0 |
| 2015-02-03 04:00:00 | QQQ | ETF | 102.35 | 102.35 | 102.31 | 102.31 | 13500.0 |
| 2015-02-03 05:00:00 | QQQ | ETF | 102.14 | 102.35 | 102.1 | 102.35 | 9250.0 |
| 2015-02-03 06:00:00 | QQQ | ETF | 102.25 | 102.5 | 102.25 | 102.47 | 14700.0 |
| 2015-02-03 07:00:00 | QQQ | ETF | 102.38 | 102.59 | 102.29 | 102.4 | 539889.0 |
| 2015-02-03 08:00:00 | QQQ | ETF | 102.34 | 102.54 | 102.14 | 102.37 | 379396.0 |
| 2015-02-03 09:00:00 | QQQ | ETF | 102.37 | 102.79 | 102.26 | 102.61 | 4048600.0 |
| 2015-02-03 10:00:00 | QQQ | ETF | 102.61 | 102.64 | 101.861 | 101.9 | 5183765.0 |
| 2015-02-03 11:00:00 | QQQ | ETF | 101.9 | 102.24 | 101.771 | 101.81 | 3168777.0 |
| 2015-02-03 12:00:00 | QQQ | ETF | 101.81 | 102.19 | 101.68 | 102.09 | 2454376.0 |
| 2015-02-03 13:00:00 | QQQ | ETF | 102.11 | 102.61 | 102.04 | 102.6 | 2596427.0 |
| 2015-02-03 14:00:00 | QQQ | ETF | 102.6 | 102.71 | 102.32 | 102.71 | 2003633.0 |
| 2015-02-03 15:00:00 | QQQ | ETF | 102.71 | 103.03 | 102.5801 | 102.98 | 5843029.0 |
| 2015-02-03 16:00:00 | QQQ | ETF | 102.98 | 103.06 | 102.0502 | 102.8 | 2596495.0 |
| 2015-02-03 17:00:00 | QQQ | ETF | 102.77 | 102.84 | 102.76 | 102.76 | 10025.0 |
| 2015-02-03 18:00:00 | QQQ | ETF | 102.71 | 102.71 | 102.64 | 102.66 | 9266.0 |
| 2015-02-03 19:00:00 | QQQ | ETF | 102.66 | 102.75 | 102.66 | 102.75 | 5454.0 |
| 2015-02-03 04:00:00 | IWM | ETF | 117.04 | 117.39 | 117.04 | 117.39 | 250.0 |
| 2015-02-03 06:00:00 | IWM | ETF | 117.25 | 117.5 | 117.25 | 117.5 | 27000.0 |
| 2015-02-03 07:00:00 | IWM | ETF | 117.35 | 117.45 | 117.17 | 117.28 | 97276.0 |
| 2015-02-03 08:00:00 | IWM | ETF | 117.27 | 117.35 | 116.92 | 117.31 | 170770.0 |
| 2015-02-03 09:00:00 | IWM | ETF | 117.34 | 118.6 | 117.22 | 118.6 | 4588408.0 |
| 2015-02-03 10:00:00 | IWM | ETF | 118.59 | 118.7 | 117.69 | 117.71 | 6162008.0 |
| 2015-02-03 11:00:00 | IWM | ETF | 117.71 | 118.23 | 117.68 | 117.85 | 4063129.0 |
| 2015-02-03 12:00:00 | IWM | ETF | 117.85 | 118.18 | 117.74 | 118.03 | 1870884.0 |
| 2015-02-03 13:00:00 | IWM | ETF | 118.03 | 118.54 | 117.93 | 118.53 | 2270420.0 |
| 2015-02-03 14:00:00 | IWM | ETF | 118.54 | 118.7 | 118.05 | 118.55 | 2849885.0 |
| 2015-02-03 15:00:00 | IWM | ETF | 118.55 | 119.0 | 118.45 | 118.84 | 7391957.0 |
| 2015-02-03 16:00:00 | IWM | ETF | 118.84 | 118.94 | 118.6 | 118.81 | 2571976.0 |
| 2015-02-03 17:00:00 | IWM | ETF | 118.8 | 118.83 | 118.75 | 118.76 | 16723.0 |
| 2015-02-03 18:00:00 | IWM | ETF | 118.7 | 118.7 | 118.7 | 118.7 | 300.0 |
| 2015-02-03 19:00:00 | IWM | ETF | 118.63 | 118.63 | 118.63 | 118.63 | 308.0 |
| 2015-02-03 04:00:00 | DIA | ETF | 174.0 | 174.0 | 173.43 | 173.43 | 400.0 |
| 2015-02-03 05:00:00 | DIA | ETF | 173.49 | 173.52 | 173.49 | 173.52 | 200.0 |
| 2015-02-03 06:00:00 | DIA | ETF | 173.57 | 173.95 | 173.57 | 173.95 | 520.0 |
> showing 50 of 7,811 rows — these rows as CSV