PREVIEW / etf_30min / 2015-07-02
file: by_date/etf_30min/2015/2015-07-02.parquet size: 373 KB rows: 12,688
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-07-02 04:00:00 | SPY | ETF | 207.88 | 208.13 | 207.39 | 208.1 | 16900.0 |
| 2015-07-02 05:00:00 | SPY | ETF | 207.96 | 207.96 | 207.76 | 207.81 | 23600.0 |
| 2015-07-02 05:30:00 | SPY | ETF | 207.88 | 207.99 | 207.86 | 207.98 | 2510.0 |
| 2015-07-02 06:00:00 | SPY | ETF | 207.91 | 207.99 | 207.87 | 207.98 | 19325.0 |
| 2015-07-02 06:30:00 | SPY | ETF | 207.99 | 208.09 | 207.96 | 208.03 | 32537.0 |
| 2015-07-02 07:00:00 | SPY | ETF | 208.03 | 208.1 | 207.85 | 207.9 | 61907.0 |
| 2015-07-02 07:30:00 | SPY | ETF | 207.93 | 208.11 | 207.93 | 208.02 | 77510.0 |
| 2015-07-02 08:00:00 | SPY | ETF | 208.01 | 208.03 | 207.84 | 207.92 | 425718.0 |
| 2015-07-02 08:30:00 | SPY | ETF | 207.86 | 208.48 | 206.03 | 208.24 | 1090660.0 |
| 2015-07-02 09:00:00 | SPY | ETF | 208.22 | 208.27 | 207.5 | 208.07 | 1019686.0 |
| 2015-07-02 09:30:00 | SPY | ETF | 208.07 | 208.27 | 207.8 | 207.85 | 11199308.0 |
| 2015-07-02 10:00:00 | SPY | ETF | 207.86 | 208.01 | 207.68 | 207.83 | 5324441.0 |
| 2015-07-02 10:30:00 | SPY | ETF | 207.83 | 207.875 | 207.48 | 207.675 | 5888706.0 |
| 2015-07-02 11:00:00 | SPY | ETF | 207.67 | 207.7 | 207.22 | 207.29 | 5327791.0 |
| 2015-07-02 11:30:00 | SPY | ETF | 207.28 | 207.45 | 207.1 | 207.23 | 5900671.0 |
| 2015-07-02 12:00:00 | SPY | ETF | 207.23 | 207.33 | 206.89 | 206.95 | 5359438.0 |
| 2015-07-02 12:30:00 | SPY | ETF | 206.955 | 207.11 | 206.89 | 207.0799 | 4435751.0 |
| 2015-07-02 13:00:00 | SPY | ETF | 207.07 | 207.07 | 206.83 | 207.03 | 4245487.0 |
| 2015-07-02 13:30:00 | SPY | ETF | 207.02 | 207.17 | 206.92 | 206.955 | 4020770.0 |
| 2015-07-02 14:00:00 | SPY | ETF | 206.955 | 207.075 | 206.81 | 206.995 | 3404596.0 |
| 2015-07-02 14:30:00 | SPY | ETF | 207.0 | 207.28 | 206.91 | 207.2014 | 4666123.0 |
| 2015-07-02 15:00:00 | SPY | ETF | 207.21 | 207.51 | 207.0601 | 207.48 | 9407379.0 |
| 2015-07-02 15:30:00 | SPY | ETF | 207.48 | 207.64 | 207.22 | 207.3 | 15499860.0 |
| 2015-07-02 16:00:00 | SPY | ETF | 207.29 | 207.975 | 207.24 | 207.48 | 9105617.0 |
| 2015-07-02 16:30:00 | SPY | ETF | 207.47 | 207.54 | 207.32 | 207.47 | 1214022.0 |
| 2015-07-02 17:00:00 | SPY | ETF | 207.48 | 207.51 | 207.45 | 207.48 | 32368.0 |
| 2015-07-02 17:30:00 | SPY | ETF | 207.5 | 207.55 | 207.47 | 207.52 | 30002.0 |
| 2015-07-02 18:00:00 | SPY | ETF | 207.49 | 207.55 | 207.45 | 207.46 | 37690.0 |
| 2015-07-02 18:30:00 | SPY | ETF | 207.46 | 207.5 | 207.45 | 207.46 | 24003.0 |
| 2015-07-02 19:00:00 | SPY | ETF | 207.47 | 207.47 | 207.37 | 207.4 | 25047.0 |
| 2015-07-02 19:30:00 | SPY | ETF | 207.4 | 207.47 | 207.4 | 207.45 | 5904.0 |
| 2015-07-02 04:00:00 | QQQ | ETF | 108.08 | 108.13 | 108.08 | 108.12 | 597.0 |
| 2015-07-02 06:30:00 | QQQ | ETF | 108.22 | 108.22 | 108.16 | 108.16 | 4800.0 |
| 2015-07-02 07:00:00 | QQQ | ETF | 108.18 | 108.19 | 108.08 | 108.12 | 43600.0 |
| 2015-07-02 07:30:00 | QQQ | ETF | 108.13 | 108.18 | 108.11 | 108.16 | 18108.0 |
| 2015-07-02 08:00:00 | QQQ | ETF | 108.16 | 108.18 | 108.13 | 108.16 | 84279.0 |
| 2015-07-02 08:30:00 | QQQ | ETF | 108.13 | 108.42 | 108.13 | 108.31 | 104840.0 |
| 2015-07-02 09:00:00 | QQQ | ETF | 108.32 | 108.32 | 108.09 | 108.22 | 311381.0 |
| 2015-07-02 09:30:00 | QQQ | ETF | 108.23 | 108.32 | 108.04 | 108.06 | 2655183.0 |
| 2015-07-02 10:00:00 | QQQ | ETF | 108.06 | 108.13 | 107.9 | 108.05 | 1517138.0 |
| 2015-07-02 10:30:00 | QQQ | ETF | 108.06 | 108.08 | 107.84 | 107.9801 | 867329.0 |
| 2015-07-02 11:00:00 | QQQ | ETF | 107.99 | 107.99 | 107.73 | 107.81 | 918540.0 |
| 2015-07-02 11:30:00 | QQQ | ETF | 107.8 | 107.88 | 107.725 | 107.79 | 963714.0 |
| 2015-07-02 12:00:00 | QQQ | ETF | 107.8 | 107.83 | 107.62 | 107.67 | 788682.0 |
| 2015-07-02 12:30:00 | QQQ | ETF | 107.6675 | 107.77 | 107.66 | 107.76 | 491433.0 |
| 2015-07-02 13:00:00 | QQQ | ETF | 107.76 | 107.77 | 107.6301 | 107.74 | 726130.0 |
| 2015-07-02 13:30:00 | QQQ | ETF | 107.75 | 107.83 | 107.72 | 107.7461 | 642751.0 |
| 2015-07-02 14:00:00 | QQQ | ETF | 107.74 | 107.817 | 107.69 | 107.78 | 426100.0 |
| 2015-07-02 14:30:00 | QQQ | ETF | 107.775 | 107.935 | 107.75 | 107.9 | 734038.0 |
| 2015-07-02 15:00:00 | QQQ | ETF | 107.91 | 108.06 | 107.8 | 108.04 | 787559.0 |
> showing 50 of 12,688 rows — these rows as CSV