PREVIEW / etf_30min / 2016-02-29
file: by_date/etf_30min/2016/2016-02-29.parquet size: 387 KB rows: 13,104
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 |
|---|---|---|---|---|---|---|---|
| 2016-02-29 04:00:00 | SPY | ETF | 193.91 | 193.94 | 193.45 | 193.57 | 41262.0 |
| 2016-02-29 04:30:00 | SPY | ETF | 193.54 | 193.72 | 193.53 | 193.6 | 16614.0 |
| 2016-02-29 05:00:00 | SPY | ETF | 193.75 | 194.64 | 193.75 | 194.1 | 46236.0 |
| 2016-02-29 05:30:00 | SPY | ETF | 194.13 | 194.21 | 193.95 | 193.97 | 12080.0 |
| 2016-02-29 06:00:00 | SPY | ETF | 193.97 | 194.14 | 193.78 | 193.97 | 65016.0 |
| 2016-02-29 06:30:00 | SPY | ETF | 194.0 | 194.66 | 194.0 | 194.53 | 105528.0 |
| 2016-02-29 07:00:00 | SPY | ETF | 194.51 | 194.64 | 194.35 | 194.64 | 67758.0 |
| 2016-02-29 07:30:00 | SPY | ETF | 194.62 | 194.91 | 194.5 | 194.58 | 126152.0 |
| 2016-02-29 08:00:00 | SPY | ETF | 194.53 | 195.08 | 193.9989 | 194.73 | 481636.0 |
| 2016-02-29 08:30:00 | SPY | ETF | 194.72 | 195.39 | 194.69 | 195.29 | 1115860.0 |
| 2016-02-29 09:00:00 | SPY | ETF | 195.29 | 195.3 | 195.01 | 195.09 | 383111.0 |
| 2016-02-29 09:30:00 | SPY | ETF | 195.11 | 195.38 | 194.71 | 195.1092 | 9403589.0 |
| 2016-02-29 10:00:00 | SPY | ETF | 195.1 | 195.24 | 194.72 | 194.96 | 7057755.0 |
| 2016-02-29 10:30:00 | SPY | ETF | 194.965 | 195.39 | 194.75 | 195.31 | 5319609.0 |
| 2016-02-29 11:00:00 | SPY | ETF | 195.31 | 195.8 | 195.31 | 195.575 | 5823748.0 |
| 2016-02-29 11:30:00 | SPY | ETF | 195.56 | 196.23 | 195.53 | 195.93 | 6475412.0 |
| 2016-02-29 12:00:00 | SPY | ETF | 195.93 | 196.03 | 195.63 | 195.74 | 5220189.0 |
| 2016-02-29 12:30:00 | SPY | ETF | 195.74 | 195.82 | 195.54 | 195.82 | 3531446.0 |
| 2016-02-29 13:00:00 | SPY | ETF | 195.82 | 195.88 | 195.47 | 195.475 | 4294760.0 |
| 2016-02-29 13:30:00 | SPY | ETF | 195.475 | 195.55 | 195.3 | 195.52 | 2682414.0 |
| 2016-02-29 14:00:00 | SPY | ETF | 195.52 | 195.55 | 194.6 | 194.91 | 10666792.0 |
| 2016-02-29 14:30:00 | SPY | ETF | 194.9058 | 194.96 | 194.3 | 194.38 | 10675169.0 |
| 2016-02-29 15:00:00 | SPY | ETF | 194.38 | 194.3992 | 193.71 | 194.19 | 13496218.0 |
| 2016-02-29 15:30:00 | SPY | ETF | 194.18 | 194.37 | 193.44 | 193.48 | 19556733.0 |
| 2016-02-29 16:00:00 | SPY | ETF | 193.48 | 195.0215 | 193.32 | 193.64 | 13267326.0 |
| 2016-02-29 16:30:00 | SPY | ETF | 193.62 | 195.1652 | 193.45 | 193.5 | 2196844.0 |
| 2016-02-29 17:00:00 | SPY | ETF | 193.51 | 195.755 | 193.45 | 193.47 | 289320.0 |
| 2016-02-29 17:30:00 | SPY | ETF | 193.45 | 193.6 | 193.44 | 193.48 | 494113.0 |
| 2016-02-29 18:00:00 | SPY | ETF | 193.48 | 193.78 | 193.38 | 193.78 | 134150.0 |
| 2016-02-29 18:30:00 | SPY | ETF | 193.78 | 193.96 | 193.56 | 193.81 | 193372.0 |
| 2016-02-29 19:00:00 | SPY | ETF | 193.81 | 193.93 | 193.6 | 193.61 | 63676.0 |
| 2016-02-29 19:30:00 | SPY | ETF | 193.62 | 193.68 | 193.24 | 193.24 | 96919.0 |
| 2016-02-29 04:00:00 | QQQ | ETF | 102.34 | 102.44 | 102.29 | 102.29 | 1291.0 |
| 2016-02-29 04:30:00 | QQQ | ETF | 102.3 | 102.34 | 102.3 | 102.3 | 310.0 |
| 2016-02-29 05:00:00 | QQQ | ETF | 102.37 | 102.8 | 102.37 | 102.64 | 7609.0 |
| 2016-02-29 05:30:00 | QQQ | ETF | 102.54 | 102.54 | 102.54 | 102.54 | 999.0 |
| 2016-02-29 06:00:00 | QQQ | ETF | 102.65 | 102.67 | 102.47 | 102.59 | 4699.0 |
| 2016-02-29 06:30:00 | QQQ | ETF | 102.7 | 102.95 | 102.7 | 102.95 | 1598.0 |
| 2016-02-29 07:00:00 | QQQ | ETF | 102.85 | 103.03 | 102.85 | 103.03 | 6269.0 |
| 2016-02-29 07:30:00 | QQQ | ETF | 103.08 | 103.16 | 103.01 | 103.01 | 18341.0 |
| 2016-02-29 08:00:00 | QQQ | ETF | 102.97 | 103.43 | 102.96 | 103.05 | 29461.0 |
| 2016-02-29 08:30:00 | QQQ | ETF | 103.12 | 103.43 | 103.12 | 103.4 | 84006.0 |
| 2016-02-29 09:00:00 | QQQ | ETF | 103.4 | 103.42 | 103.28 | 103.32 | 70826.0 |
| 2016-02-29 09:30:00 | QQQ | ETF | 103.31 | 103.73 | 103.19 | 103.58 | 3442547.0 |
| 2016-02-29 10:00:00 | QQQ | ETF | 103.58 | 103.73 | 103.34 | 103.54 | 2651959.0 |
| 2016-02-29 10:30:00 | QQQ | ETF | 103.54 | 103.72 | 103.43 | 103.6599 | 1254553.0 |
| 2016-02-29 11:00:00 | QQQ | ETF | 103.66 | 103.89 | 103.58 | 103.77 | 1147384.0 |
| 2016-02-29 11:30:00 | QQQ | ETF | 103.76 | 104.1 | 103.7419 | 103.99 | 1337621.0 |
| 2016-02-29 12:00:00 | QQQ | ETF | 103.98 | 104.06 | 103.8316 | 103.88 | 739595.0 |
| 2016-02-29 12:30:00 | QQQ | ETF | 103.88 | 103.94 | 103.75 | 103.94 | 735796.0 |
> showing 50 of 13,104 rows — these rows as CSV