PREVIEW / etf_30min / 2015-06-29
file: by_date/etf_30min/2015/2015-06-29.parquet size: 412 KB rows: 13,964
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-06-29 04:00:00 | SPY | ETF | 208.05 | 208.08 | 207.65 | 208.05 | 53498.0 |
| 2015-06-29 04:30:00 | SPY | ETF | 208.05 | 208.37 | 207.96 | 208.3 | 23275.0 |
| 2015-06-29 05:00:00 | SPY | ETF | 208.11 | 208.35 | 207.77 | 207.78 | 37637.0 |
| 2015-06-29 05:30:00 | SPY | ETF | 207.89 | 208.04 | 207.8 | 207.9 | 13026.0 |
| 2015-06-29 06:00:00 | SPY | ETF | 207.83 | 207.91 | 207.52 | 207.56 | 72151.0 |
| 2015-06-29 06:30:00 | SPY | ETF | 207.56 | 207.82 | 207.41 | 207.78 | 214627.0 |
| 2015-06-29 07:00:00 | SPY | ETF | 207.8 | 207.82 | 207.61 | 207.79 | 253288.0 |
| 2015-06-29 07:30:00 | SPY | ETF | 207.75 | 208.06 | 207.73 | 208.0 | 431294.0 |
| 2015-06-29 08:00:00 | SPY | ETF | 208.0 | 208.01 | 206.805 | 207.9 | 1278856.0 |
| 2015-06-29 08:30:00 | SPY | ETF | 207.93 | 208.05 | 207.82 | 207.94 | 717452.0 |
| 2015-06-29 09:00:00 | SPY | ETF | 207.93 | 208.25 | 207.32 | 208.04 | 1969195.0 |
| 2015-06-29 09:30:00 | SPY | ETF | 208.045 | 208.82 | 207.8 | 208.3 | 21270786.0 |
| 2015-06-29 10:00:00 | SPY | ETF | 208.29 | 208.73 | 207.94 | 207.985 | 10720533.0 |
| 2015-06-29 10:30:00 | SPY | ETF | 207.98 | 208.33 | 207.71 | 207.7599 | 8180934.0 |
| 2015-06-29 11:00:00 | SPY | ETF | 207.76 | 207.81 | 207.4 | 207.63 | 12591598.0 |
| 2015-06-29 11:30:00 | SPY | ETF | 207.64 | 207.68 | 207.24 | 207.5 | 6752674.0 |
| 2015-06-29 12:00:00 | SPY | ETF | 207.5 | 207.625 | 207.11 | 207.2 | 7957188.0 |
| 2015-06-29 12:30:00 | SPY | ETF | 207.19 | 207.6143 | 207.0 | 207.12 | 6632980.0 |
| 2015-06-29 13:00:00 | SPY | ETF | 207.12 | 209.828 | 206.75 | 206.95 | 11915773.0 |
| 2015-06-29 13:30:00 | SPY | ETF | 206.955 | 207.13 | 206.7 | 206.86 | 7857786.0 |
| 2015-06-29 14:00:00 | SPY | ETF | 206.845 | 206.86 | 206.225 | 206.27 | 13535552.0 |
| 2015-06-29 14:30:00 | SPY | ETF | 206.27 | 206.72 | 206.05 | 206.21 | 13280261.0 |
| 2015-06-29 15:00:00 | SPY | ETF | 206.21 | 206.36 | 205.93 | 205.995 | 14392190.0 |
| 2015-06-29 15:30:00 | SPY | ETF | 205.992 | 206.12 | 205.33 | 205.44 | 35151828.0 |
| 2015-06-29 16:00:00 | SPY | ETF | 205.39 | 205.72 | 205.36 | 205.64 | 10250359.0 |
| 2015-06-29 16:30:00 | SPY | ETF | 205.64 | 205.9 | 205.51 | 205.85 | 3559191.0 |
| 2015-06-29 17:00:00 | SPY | ETF | 205.85 | 205.92 | 205.74 | 205.75 | 139528.0 |
| 2015-06-29 17:30:00 | SPY | ETF | 205.74 | 205.96 | 205.42 | 205.94 | 2309226.0 |
| 2015-06-29 18:00:00 | SPY | ETF | 205.96 | 205.97 | 205.72 | 205.78 | 132286.0 |
| 2015-06-29 18:30:00 | SPY | ETF | 205.8 | 205.9 | 205.8 | 205.9 | 37723.0 |
| 2015-06-29 19:00:00 | SPY | ETF | 205.9 | 205.99 | 205.87 | 205.94 | 73943.0 |
| 2015-06-29 19:30:00 | SPY | ETF | 205.94 | 206.0 | 205.91 | 205.98 | 93211.0 |
| 2015-06-29 04:00:00 | QQQ | ETF | 108.32 | 108.32 | 108.0 | 108.16 | 11957.0 |
| 2015-06-29 04:30:00 | QQQ | ETF | 108.19 | 108.19 | 108.15 | 108.15 | 6500.0 |
| 2015-06-29 05:00:00 | QQQ | ETF | 108.28 | 108.28 | 108.02 | 108.02 | 564.0 |
| 2015-06-29 05:30:00 | QQQ | ETF | 108.17 | 108.17 | 108.04 | 108.04 | 7201.0 |
| 2015-06-29 06:00:00 | QQQ | ETF | 108.03 | 108.05 | 107.9 | 107.9 | 2900.0 |
| 2015-06-29 06:30:00 | QQQ | ETF | 107.89 | 107.89 | 107.84 | 107.84 | 3300.0 |
| 2015-06-29 07:00:00 | QQQ | ETF | 108.01 | 108.14 | 107.93 | 107.94 | 93564.0 |
| 2015-06-29 07:30:00 | QQQ | ETF | 108.02 | 108.12 | 107.97 | 108.12 | 19568.0 |
| 2015-06-29 08:00:00 | QQQ | ETF | 108.12 | 108.14 | 107.94 | 108.03 | 74716.0 |
| 2015-06-29 08:30:00 | QQQ | ETF | 108.02 | 108.1 | 107.98 | 108.08 | 36030.0 |
| 2015-06-29 09:00:00 | QQQ | ETF | 108.09 | 108.17 | 107.92 | 108.06 | 365538.0 |
| 2015-06-29 09:30:00 | QQQ | ETF | 108.06 | 108.66 | 107.89 | 108.345 | 6926623.0 |
| 2015-06-29 10:00:00 | QQQ | ETF | 108.345 | 108.58 | 108.18 | 108.2 | 3134574.0 |
| 2015-06-29 10:30:00 | QQQ | ETF | 108.19 | 108.3672 | 108.01 | 108.04 | 2001262.0 |
| 2015-06-29 11:00:00 | QQQ | ETF | 108.04 | 108.08 | 107.83 | 107.94 | 2465241.0 |
| 2015-06-29 11:30:00 | QQQ | ETF | 107.95 | 107.96 | 107.71 | 107.8599 | 1840743.0 |
| 2015-06-29 12:00:00 | QQQ | ETF | 107.855 | 107.97 | 107.69 | 107.76 | 1433304.0 |
| 2015-06-29 12:30:00 | QQQ | ETF | 107.77 | 107.8 | 107.66 | 107.74 | 880446.0 |
> showing 50 of 13,964 rows — these rows as CSV