PREVIEW / etf_30min / 2015-12-04
file: by_date/etf_30min/2015/2015-12-04.parquet size: 394 KB rows: 13,168
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-12-04 04:00:00 | SPY | ETF | 206.81 | 206.9 | 206.61 | 206.89 | 29203.0 |
| 2015-12-04 04:30:00 | SPY | ETF | 206.84 | 206.87 | 206.52 | 206.64 | 22871.0 |
| 2015-12-04 05:00:00 | SPY | ETF | 206.61 | 206.62 | 206.43 | 206.61 | 25435.0 |
| 2015-12-04 05:30:00 | SPY | ETF | 206.57 | 206.79 | 206.42 | 206.79 | 7979.0 |
| 2015-12-04 06:00:00 | SPY | ETF | 206.69 | 206.81 | 206.57 | 206.65 | 10348.0 |
| 2015-12-04 06:30:00 | SPY | ETF | 206.58 | 206.64 | 206.46 | 206.64 | 12742.0 |
| 2015-12-04 07:00:00 | SPY | ETF | 206.61 | 206.61 | 206.31 | 206.41 | 29476.0 |
| 2015-12-04 07:30:00 | SPY | ETF | 206.44 | 206.44 | 206.19 | 206.26 | 138951.0 |
| 2015-12-04 08:00:00 | SPY | ETF | 206.49 | 207.23 | 205.61 | 206.26 | 498421.0 |
| 2015-12-04 08:30:00 | SPY | ETF | 206.32 | 206.97 | 206.1 | 206.11 | 2130872.0 |
| 2015-12-04 09:00:00 | SPY | ETF | 206.1 | 206.25 | 205.4 | 206.08 | 2071938.0 |
| 2015-12-04 09:30:00 | SPY | ETF | 206.08 | 207.68 | 205.93 | 207.295 | 21925289.0 |
| 2015-12-04 10:00:00 | SPY | ETF | 207.2989 | 207.83 | 206.99 | 207.685 | 13003877.0 |
| 2015-12-04 10:30:00 | SPY | ETF | 207.685 | 208.39 | 207.49 | 208.355 | 11547092.0 |
| 2015-12-04 11:00:00 | SPY | ETF | 208.35 | 208.5 | 207.95 | 207.96 | 11021541.0 |
| 2015-12-04 11:30:00 | SPY | ETF | 207.96 | 208.18 | 207.63 | 207.78 | 7607119.0 |
| 2015-12-04 12:00:00 | SPY | ETF | 207.78 | 208.07 | 207.58 | 207.84 | 6543614.0 |
| 2015-12-04 12:30:00 | SPY | ETF | 207.84 | 209.06 | 207.8 | 209.01 | 13137001.0 |
| 2015-12-04 13:00:00 | SPY | ETF | 209.03 | 209.56 | 208.97 | 209.33 | 19643967.0 |
| 2015-12-04 13:30:00 | SPY | ETF | 209.32 | 209.44 | 209.04 | 209.355 | 8651114.0 |
| 2015-12-04 14:00:00 | SPY | ETF | 209.36 | 209.465 | 209.04 | 209.34 | 8947452.0 |
| 2015-12-04 14:30:00 | SPY | ETF | 209.35 | 209.85 | 209.265 | 209.8199 | 12696236.0 |
| 2015-12-04 15:00:00 | SPY | ETF | 209.82 | 209.97 | 209.51 | 209.695 | 14152475.0 |
| 2015-12-04 15:30:00 | SPY | ETF | 209.7 | 209.74 | 209.32 | 209.63 | 21440009.0 |
| 2015-12-04 16:00:00 | SPY | ETF | 209.63 | 209.72 | 209.43 | 209.53 | 14995781.0 |
| 2015-12-04 16:30:00 | SPY | ETF | 209.55 | 209.66 | 208.5673 | 209.56 | 666873.0 |
| 2015-12-04 17:00:00 | SPY | ETF | 209.57 | 209.61 | 209.53 | 209.56 | 534187.0 |
| 2015-12-04 17:30:00 | SPY | ETF | 209.56 | 209.58 | 209.51 | 209.58 | 27002.0 |
| 2015-12-04 18:00:00 | SPY | ETF | 209.56 | 209.59 | 209.54 | 209.56 | 6465.0 |
| 2015-12-04 18:30:00 | SPY | ETF | 209.56 | 209.61 | 209.56 | 209.56 | 3869.0 |
| 2015-12-04 19:00:00 | SPY | ETF | 209.6 | 209.61 | 209.6 | 209.61 | 5405.0 |
| 2015-12-04 19:30:00 | SPY | ETF | 209.6 | 209.62 | 209.56 | 209.61 | 14206.0 |
| 2015-12-04 04:00:00 | QQQ | ETF | 113.1 | 113.18 | 113.1 | 113.1 | 750.0 |
| 2015-12-04 04:30:00 | QQQ | ETF | 113.1 | 113.1 | 113.1 | 113.1 | 100.0 |
| 2015-12-04 05:00:00 | QQQ | ETF | 112.95 | 112.95 | 112.95 | 112.95 | 500.0 |
| 2015-12-04 06:00:00 | QQQ | ETF | 112.96 | 113.04 | 112.96 | 113.04 | 700.0 |
| 2015-12-04 07:00:00 | QQQ | ETF | 112.89 | 112.89 | 112.8 | 112.82 | 3800.0 |
| 2015-12-04 07:30:00 | QQQ | ETF | 112.82 | 112.82 | 112.71 | 112.77 | 3284.0 |
| 2015-12-04 08:00:00 | QQQ | ETF | 112.75 | 112.77 | 112.51 | 112.74 | 47518.0 |
| 2015-12-04 08:30:00 | QQQ | ETF | 112.72 | 113.06 | 112.72 | 112.85 | 386390.0 |
| 2015-12-04 09:00:00 | QQQ | ETF | 112.74 | 112.88 | 112.44 | 112.84 | 361776.0 |
| 2015-12-04 09:30:00 | QQQ | ETF | 112.84 | 113.86 | 112.62 | 113.68 | 7269138.0 |
| 2015-12-04 10:00:00 | QQQ | ETF | 113.68 | 113.905 | 112.6339 | 113.79 | 4786966.0 |
| 2015-12-04 10:30:00 | QQQ | ETF | 113.79 | 114.39 | 113.65 | 114.359 | 2815863.0 |
| 2015-12-04 11:00:00 | QQQ | ETF | 114.36 | 114.48 | 114.2 | 114.21 | 2310424.0 |
| 2015-12-04 11:30:00 | QQQ | ETF | 114.21 | 114.28 | 114.01 | 114.18 | 1917901.0 |
| 2015-12-04 12:00:00 | QQQ | ETF | 114.17 | 114.369 | 114.06 | 114.27 | 966136.0 |
| 2015-12-04 12:30:00 | QQQ | ETF | 114.2765 | 114.87 | 114.25 | 114.85 | 2677867.0 |
| 2015-12-04 13:00:00 | QQQ | ETF | 114.86 | 115.08 | 114.82 | 114.92 | 2067978.0 |
| 2015-12-04 13:30:00 | QQQ | ETF | 114.93 | 115.04 | 114.8 | 115.01 | 1161485.0 |
> showing 50 of 13,168 rows — these rows as CSV