PREVIEW / etf_30min / 2015-12-02
file: by_date/etf_30min/2015/2015-12-02.parquet size: 389 KB rows: 13,004
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-02 04:00:00 | SPY | ETF | 210.89 | 211.0 | 210.83 | 210.83 | 13516.0 |
| 2015-12-02 04:30:00 | SPY | ETF | 210.76 | 210.93 | 210.76 | 210.93 | 4200.0 |
| 2015-12-02 05:00:00 | SPY | ETF | 210.91 | 211.11 | 210.91 | 210.96 | 8115.0 |
| 2015-12-02 05:30:00 | SPY | ETF | 210.96 | 211.02 | 210.9 | 211.01 | 1642.0 |
| 2015-12-02 06:00:00 | SPY | ETF | 211.0 | 211.09 | 210.86 | 210.86 | 17151.0 |
| 2015-12-02 06:30:00 | SPY | ETF | 210.84 | 210.93 | 210.78 | 210.78 | 3697.0 |
| 2015-12-02 07:00:00 | SPY | ETF | 210.81 | 210.84 | 210.63 | 210.66 | 83546.0 |
| 2015-12-02 07:30:00 | SPY | ETF | 210.65 | 210.82 | 210.48 | 210.81 | 126810.0 |
| 2015-12-02 08:00:00 | SPY | ETF | 210.77 | 210.91 | 210.59 | 210.76 | 264402.0 |
| 2015-12-02 08:30:00 | SPY | ETF | 210.8 | 210.8 | 210.46 | 210.58 | 195076.0 |
| 2015-12-02 09:00:00 | SPY | ETF | 210.56 | 210.7 | 210.53 | 210.61 | 430933.0 |
| 2015-12-02 09:30:00 | SPY | ETF | 210.615 | 210.95 | 210.45 | 210.8611 | 8898069.0 |
| 2015-12-02 10:00:00 | SPY | ETF | 210.865 | 211.0 | 210.49 | 210.6 | 6056949.0 |
| 2015-12-02 10:30:00 | SPY | ETF | 210.59 | 210.83 | 210.5 | 210.6 | 4135915.0 |
| 2015-12-02 11:00:00 | SPY | ETF | 210.59 | 210.61 | 210.135 | 210.17 | 6786458.0 |
| 2015-12-02 11:30:00 | SPY | ETF | 210.17 | 210.25 | 209.93 | 210.05 | 6384666.0 |
| 2015-12-02 12:00:00 | SPY | ETF | 210.06 | 210.23 | 209.82 | 210.19 | 5331771.0 |
| 2015-12-02 12:30:00 | SPY | ETF | 210.19 | 210.34 | 210.06 | 210.085 | 3652181.0 |
| 2015-12-02 13:00:00 | SPY | ETF | 210.075 | 210.19 | 209.9 | 210.14 | 4926401.0 |
| 2015-12-02 13:30:00 | SPY | ETF | 210.14 | 210.21 | 209.65 | 209.7185 | 5268292.0 |
| 2015-12-02 14:00:00 | SPY | ETF | 209.7108 | 209.72 | 208.88 | 209.02 | 10615203.0 |
| 2015-12-02 14:30:00 | SPY | ETF | 209.03 | 209.04 | 208.27 | 208.39 | 9643159.0 |
| 2015-12-02 15:00:00 | SPY | ETF | 208.3899 | 209.065 | 208.26 | 208.79 | 10485768.0 |
| 2015-12-02 15:30:00 | SPY | ETF | 208.79 | 208.92 | 208.23 | 208.5 | 18219672.0 |
| 2015-12-02 16:00:00 | SPY | ETF | 208.51 | 208.91 | 208.45 | 208.88 | 4282834.0 |
| 2015-12-02 16:30:00 | SPY | ETF | 208.88 | 209.14 | 208.87 | 209.05 | 223288.0 |
| 2015-12-02 17:00:00 | SPY | ETF | 209.05 | 213.54 | 208.54 | 209.03 | 688609.0 |
| 2015-12-02 17:30:00 | SPY | ETF | 209.05 | 209.05 | 208.92 | 209.0 | 40458.0 |
| 2015-12-02 18:00:00 | SPY | ETF | 209.0 | 209.04 | 208.48 | 208.81 | 174768.0 |
| 2015-12-02 18:30:00 | SPY | ETF | 208.76 | 208.95 | 208.76 | 208.88 | 44089.0 |
| 2015-12-02 19:00:00 | SPY | ETF | 208.85 | 208.9 | 208.75 | 208.85 | 28209.0 |
| 2015-12-02 19:30:00 | SPY | ETF | 208.86 | 208.97 | 208.86 | 208.94 | 25018.0 |
| 2015-12-02 04:00:00 | QQQ | ETF | 115.15 | 115.32 | 115.15 | 115.25 | 1200.0 |
| 2015-12-02 05:00:00 | QQQ | ETF | 115.4 | 115.46 | 115.4 | 115.46 | 200.0 |
| 2015-12-02 05:30:00 | QQQ | ETF | 115.37 | 115.37 | 115.37 | 115.37 | 100.0 |
| 2015-12-02 06:00:00 | QQQ | ETF | 115.36 | 115.36 | 115.34 | 115.34 | 200.0 |
| 2015-12-02 06:30:00 | QQQ | ETF | 115.33 | 115.33 | 115.33 | 115.33 | 100.0 |
| 2015-12-02 07:00:00 | QQQ | ETF | 115.31 | 115.31 | 115.25 | 115.25 | 200.0 |
| 2015-12-02 07:30:00 | QQQ | ETF | 115.19 | 115.23 | 115.19 | 115.23 | 20503.0 |
| 2015-12-02 08:00:00 | QQQ | ETF | 115.2 | 115.32 | 115.08 | 115.31 | 15996.0 |
| 2015-12-02 08:30:00 | QQQ | ETF | 115.33 | 115.33 | 115.16 | 115.17 | 20134.0 |
| 2015-12-02 09:00:00 | QQQ | ETF | 115.2 | 115.28 | 115.2 | 115.23 | 34493.0 |
| 2015-12-02 09:30:00 | QQQ | ETF | 115.23 | 115.68 | 115.18 | 115.66 | 2956938.0 |
| 2015-12-02 10:00:00 | QQQ | ETF | 115.66 | 115.73 | 115.47 | 115.6 | 2081238.0 |
| 2015-12-02 10:30:00 | QQQ | ETF | 115.6 | 115.75 | 115.54 | 115.5861 | 1068176.0 |
| 2015-12-02 11:00:00 | QQQ | ETF | 115.59 | 115.5969 | 115.345 | 115.38 | 1345667.0 |
| 2015-12-02 11:30:00 | QQQ | ETF | 115.38 | 115.48 | 115.32 | 115.44 | 854354.0 |
| 2015-12-02 12:00:00 | QQQ | ETF | 115.45 | 115.615 | 115.35 | 115.55 | 728566.0 |
| 2015-12-02 12:30:00 | QQQ | ETF | 115.55 | 115.62 | 115.435 | 115.57 | 571581.0 |
| 2015-12-02 13:00:00 | QQQ | ETF | 115.55 | 115.58 | 115.44 | 115.53 | 348538.0 |
> showing 50 of 13,004 rows — these rows as CSV