PREVIEW / etf_30min / 2015-10-16
file: by_date/etf_30min/2015/2015-10-16.parquet size: 369 KB rows: 12,488
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-10-16 04:00:00 | SPY | ETF | 202.66 | 202.66 | 202.42 | 202.58 | 6615.0 |
| 2015-10-16 04:30:00 | SPY | ETF | 202.58 | 202.8 | 202.58 | 202.77 | 12813.0 |
| 2015-10-16 05:00:00 | SPY | ETF | 202.65 | 202.78 | 202.6 | 202.78 | 3872.0 |
| 2015-10-16 05:30:00 | SPY | ETF | 202.74 | 202.74 | 202.57 | 202.57 | 1104.0 |
| 2015-10-16 06:00:00 | SPY | ETF | 202.65 | 202.65 | 202.46 | 202.46 | 29324.0 |
| 2015-10-16 06:30:00 | SPY | ETF | 202.42 | 202.44 | 202.19 | 202.24 | 93251.0 |
| 2015-10-16 07:00:00 | SPY | ETF | 202.27 | 202.29 | 202.06 | 202.24 | 106447.0 |
| 2015-10-16 07:30:00 | SPY | ETF | 202.21 | 202.41 | 202.18 | 202.37 | 60223.0 |
| 2015-10-16 08:00:00 | SPY | ETF | 202.35 | 202.67 | 202.19 | 202.33 | 240407.0 |
| 2015-10-16 08:30:00 | SPY | ETF | 202.32 | 202.47 | 202.32 | 202.41 | 304336.0 |
| 2015-10-16 09:00:00 | SPY | ETF | 202.43 | 202.89 | 202.41 | 202.83 | 1790284.0 |
| 2015-10-16 09:30:00 | SPY | ETF | 202.83 | 203.02 | 202.46 | 202.63 | 15107389.0 |
| 2015-10-16 10:00:00 | SPY | ETF | 202.64 | 202.86 | 202.23 | 202.37 | 10031317.0 |
| 2015-10-16 10:30:00 | SPY | ETF | 202.36 | 202.62 | 202.25 | 202.528 | 6454423.0 |
| 2015-10-16 11:00:00 | SPY | ETF | 202.53 | 202.81 | 202.48 | 202.6 | 4049738.0 |
| 2015-10-16 11:30:00 | SPY | ETF | 202.61 | 202.96 | 202.5402 | 202.9421 | 3433229.0 |
| 2015-10-16 12:00:00 | SPY | ETF | 202.945 | 202.96 | 202.415 | 202.445 | 4135471.0 |
| 2015-10-16 12:30:00 | SPY | ETF | 202.4499 | 202.56 | 202.265 | 202.51 | 3042643.0 |
| 2015-10-16 13:00:00 | SPY | ETF | 202.51 | 202.6 | 202.35 | 202.38 | 4663128.0 |
| 2015-10-16 13:30:00 | SPY | ETF | 202.38 | 202.54 | 202.07 | 202.1 | 5099899.0 |
| 2015-10-16 14:00:00 | SPY | ETF | 202.0963 | 202.53 | 201.92 | 202.49 | 6511516.0 |
| 2015-10-16 14:30:00 | SPY | ETF | 202.5 | 202.88 | 202.44 | 202.74 | 5058478.0 |
| 2015-10-16 15:00:00 | SPY | ETF | 202.74 | 202.95 | 202.7 | 202.87 | 4565035.0 |
| 2015-10-16 15:30:00 | SPY | ETF | 202.865 | 203.29 | 202.86 | 203.14 | 20653995.0 |
| 2015-10-16 16:00:00 | SPY | ETF | 203.15 | 203.32 | 202.8986 | 203.28 | 8360844.0 |
| 2015-10-16 16:30:00 | SPY | ETF | 203.27 | 203.35 | 202.7059 | 203.34 | 2285748.0 |
| 2015-10-16 17:00:00 | SPY | ETF | 203.34 | 203.39 | 203.3 | 203.39 | 117424.0 |
| 2015-10-16 17:30:00 | SPY | ETF | 203.39 | 203.44 | 203.29 | 203.36 | 506996.0 |
| 2015-10-16 18:00:00 | SPY | ETF | 203.35 | 203.38 | 203.33 | 203.33 | 18337.0 |
| 2015-10-16 18:30:00 | SPY | ETF | 203.33 | 203.38 | 203.25 | 203.36 | 30256.0 |
| 2015-10-16 19:00:00 | SPY | ETF | 203.36 | 203.36 | 203.32 | 203.33 | 7988.0 |
| 2015-10-16 19:30:00 | SPY | ETF | 203.33 | 203.36 | 203.31 | 203.36 | 14540.0 |
| 2015-10-16 04:00:00 | QQQ | ETF | 107.77 | 107.77 | 107.77 | 107.77 | 105.0 |
| 2015-10-16 04:30:00 | QQQ | ETF | 108.0 | 108.06 | 108.0 | 108.03 | 13530.0 |
| 2015-10-16 05:30:00 | QQQ | ETF | 108.02 | 108.04 | 108.01 | 108.04 | 2000.0 |
| 2015-10-16 06:00:00 | QQQ | ETF | 108.02 | 108.02 | 107.94 | 107.94 | 3000.0 |
| 2015-10-16 06:30:00 | QQQ | ETF | 107.9 | 107.9 | 107.75 | 107.78 | 1900.0 |
| 2015-10-16 07:00:00 | QQQ | ETF | 107.74 | 107.74 | 107.68 | 107.68 | 6279.0 |
| 2015-10-16 07:30:00 | QQQ | ETF | 107.73 | 107.8 | 107.73 | 107.8 | 5498.0 |
| 2015-10-16 08:00:00 | QQQ | ETF | 107.78 | 107.79 | 107.68 | 107.76 | 94340.0 |
| 2015-10-16 08:30:00 | QQQ | ETF | 107.79 | 107.82 | 107.71 | 107.75 | 10517.0 |
| 2015-10-16 09:00:00 | QQQ | ETF | 107.74 | 107.95 | 107.74 | 107.89 | 151402.0 |
| 2015-10-16 09:30:00 | QQQ | ETF | 107.9 | 107.93 | 107.58 | 107.71 | 4011637.0 |
| 2015-10-16 10:00:00 | QQQ | ETF | 107.71 | 107.88 | 107.55 | 107.74 | 2165156.0 |
| 2015-10-16 10:30:00 | QQQ | ETF | 107.74 | 107.96 | 107.69 | 107.88 | 1137806.0 |
| 2015-10-16 11:00:00 | QQQ | ETF | 107.88 | 108.0483 | 107.84 | 107.86 | 1162049.0 |
| 2015-10-16 11:30:00 | QQQ | ETF | 107.87 | 108.02 | 107.8001 | 108.01 | 973889.0 |
| 2015-10-16 12:00:00 | QQQ | ETF | 108.01 | 108.019 | 107.69 | 107.695 | 846835.0 |
| 2015-10-16 12:30:00 | QQQ | ETF | 107.695 | 107.76 | 107.54 | 107.74 | 652199.0 |
| 2015-10-16 13:00:00 | QQQ | ETF | 107.73 | 107.8 | 107.6 | 107.68 | 734437.0 |
> showing 50 of 12,488 rows — these rows as CSV