PREVIEW / etf_30min / 2015-12-15
file: by_date/etf_30min/2015/2015-12-15.parquet size: 395 KB rows: 13,351
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-15 04:00:00 | SPY | ETF | 203.76 | 204.13 | 203.76 | 204.07 | 35482.0 |
| 2015-12-15 04:30:00 | SPY | ETF | 204.02 | 204.2 | 203.87 | 204.11 | 126254.0 |
| 2015-12-15 05:00:00 | SPY | ETF | 204.15 | 204.27 | 203.72 | 203.72 | 39526.0 |
| 2015-12-15 05:30:00 | SPY | ETF | 203.88 | 204.11 | 203.84 | 204.11 | 60775.0 |
| 2015-12-15 06:00:00 | SPY | ETF | 204.12 | 204.21 | 203.92 | 203.97 | 83105.0 |
| 2015-12-15 06:30:00 | SPY | ETF | 204.01 | 204.32 | 204.01 | 204.19 | 78255.0 |
| 2015-12-15 07:00:00 | SPY | ETF | 204.13 | 204.23 | 204.05 | 204.12 | 84167.0 |
| 2015-12-15 07:30:00 | SPY | ETF | 204.11 | 204.11 | 203.8 | 203.91 | 261922.0 |
| 2015-12-15 08:00:00 | SPY | ETF | 203.91 | 204.17 | 202.818 | 203.89 | 642613.0 |
| 2015-12-15 08:30:00 | SPY | ETF | 203.87 | 204.89 | 203.8 | 204.8 | 1418962.0 |
| 2015-12-15 09:00:00 | SPY | ETF | 204.78 | 204.85 | 204.61 | 204.71 | 1290439.0 |
| 2015-12-15 09:30:00 | SPY | ETF | 204.7 | 205.74 | 204.54 | 205.542 | 18174449.0 |
| 2015-12-15 10:00:00 | SPY | ETF | 205.55 | 205.64 | 205.01 | 205.27 | 12829917.0 |
| 2015-12-15 10:30:00 | SPY | ETF | 205.28 | 205.49 | 204.915 | 205.16 | 8730022.0 |
| 2015-12-15 11:00:00 | SPY | ETF | 205.17 | 205.42 | 205.0 | 205.24 | 8913771.0 |
| 2015-12-15 11:30:00 | SPY | ETF | 205.2499 | 205.4 | 204.58 | 204.98 | 7863677.0 |
| 2015-12-15 12:00:00 | SPY | ETF | 204.98 | 205.46 | 204.89 | 205.365 | 7180327.0 |
| 2015-12-15 12:30:00 | SPY | ETF | 205.365 | 206.11 | 205.3639 | 206.0025 | 15910792.0 |
| 2015-12-15 13:00:00 | SPY | ETF | 206.01 | 206.08 | 205.33 | 205.36 | 6649828.0 |
| 2015-12-15 13:30:00 | SPY | ETF | 205.35 | 205.92 | 205.24 | 205.81 | 7009529.0 |
| 2015-12-15 14:00:00 | SPY | ETF | 205.815 | 206.02 | 205.59 | 205.79 | 7302556.0 |
| 2015-12-15 14:30:00 | SPY | ETF | 205.79 | 205.9499 | 205.58 | 205.68 | 4744577.0 |
| 2015-12-15 15:00:00 | SPY | ETF | 205.69 | 205.72 | 202.8666 | 205.101 | 10033846.0 |
| 2015-12-15 15:30:00 | SPY | ETF | 205.09 | 205.42 | 204.81 | 205.09 | 22949282.0 |
| 2015-12-15 16:00:00 | SPY | ETF | 205.08 | 205.38 | 202.8653 | 205.36 | 8436277.0 |
| 2015-12-15 16:30:00 | SPY | ETF | 205.36 | 205.41 | 205.27 | 205.27 | 271019.0 |
| 2015-12-15 17:00:00 | SPY | ETF | 205.3 | 205.36 | 205.3 | 205.34 | 1348266.0 |
| 2015-12-15 17:30:00 | SPY | ETF | 205.32 | 205.36 | 205.3 | 205.3 | 61958.0 |
| 2015-12-15 18:00:00 | SPY | ETF | 205.31 | 205.41 | 205.19 | 205.35 | 88009.0 |
| 2015-12-15 18:30:00 | SPY | ETF | 205.35 | 205.4 | 205.21 | 205.24 | 37161.0 |
| 2015-12-15 19:00:00 | SPY | ETF | 205.24 | 205.42 | 205.06 | 205.34 | 81563.0 |
| 2015-12-15 19:30:00 | SPY | ETF | 205.34 | 205.34 | 205.17 | 205.23 | 100693.0 |
| 2015-12-15 04:00:00 | QQQ | ETF | 111.83 | 112.34 | 111.83 | 112.33 | 20762.0 |
| 2015-12-15 04:30:00 | QQQ | ETF | 112.38 | 112.38 | 112.37 | 112.37 | 7950.0 |
| 2015-12-15 05:00:00 | QQQ | ETF | 112.16 | 112.16 | 112.16 | 112.16 | 200.0 |
| 2015-12-15 05:30:00 | QQQ | ETF | 112.2 | 112.28 | 112.2 | 112.28 | 1000.0 |
| 2015-12-15 06:00:00 | QQQ | ETF | 112.3 | 112.3 | 112.24 | 112.24 | 1410.0 |
| 2015-12-15 06:30:00 | QQQ | ETF | 112.22 | 112.3 | 112.22 | 112.25 | 13200.0 |
| 2015-12-15 07:00:00 | QQQ | ETF | 112.2 | 112.25 | 112.17 | 112.22 | 5784.0 |
| 2015-12-15 07:30:00 | QQQ | ETF | 112.2 | 112.2 | 112.05 | 112.17 | 37178.0 |
| 2015-12-15 08:00:00 | QQQ | ETF | 112.1999 | 112.24 | 112.08 | 112.13 | 224178.0 |
| 2015-12-15 08:30:00 | QQQ | ETF | 112.15 | 112.7 | 112.15 | 112.66 | 230063.0 |
| 2015-12-15 09:00:00 | QQQ | ETF | 112.67 | 112.7 | 112.59 | 112.62 | 528901.0 |
| 2015-12-15 09:30:00 | QQQ | ETF | 112.6 | 113.23 | 112.39 | 113.1185 | 7173397.0 |
| 2015-12-15 10:00:00 | QQQ | ETF | 113.13 | 113.17 | 112.87 | 113.06 | 3402313.0 |
| 2015-12-15 10:30:00 | QQQ | ETF | 113.07 | 113.11 | 112.84 | 112.96 | 2422063.0 |
| 2015-12-15 11:00:00 | QQQ | ETF | 112.96 | 112.97 | 112.71 | 112.839 | 1755743.0 |
| 2015-12-15 11:30:00 | QQQ | ETF | 112.835 | 112.89 | 112.3401 | 112.55 | 2273726.0 |
| 2015-12-15 12:00:00 | QQQ | ETF | 112.54 | 112.99 | 112.5 | 112.95 | 2278729.0 |
| 2015-12-15 12:30:00 | QQQ | ETF | 112.9599 | 113.28 | 112.945 | 113.2 | 3448375.0 |
> showing 50 of 13,351 rows — these rows as CSV