PREVIEW / etf_30min / 2017-01-11
file: by_date/etf_30min/2017/2017-01-11.parquet size: 431 KB rows: 14,666
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 |
|---|---|---|---|---|---|---|---|
| 2017-01-11 04:00:00 | SPY | ETF | 226.15 | 226.33 | 226.06 | 226.33 | 16238.0 |
| 2017-01-11 04:30:00 | SPY | ETF | 226.3 | 226.52 | 226.27 | 226.52 | 18902.0 |
| 2017-01-11 05:00:00 | SPY | ETF | 226.51 | 226.51 | 226.46 | 226.46 | 2304.0 |
| 2017-01-11 05:30:00 | SPY | ETF | 226.49 | 226.49 | 226.42 | 226.48 | 3103.0 |
| 2017-01-11 06:00:00 | SPY | ETF | 226.46 | 226.48 | 226.41 | 226.41 | 5033.0 |
| 2017-01-11 06:30:00 | SPY | ETF | 226.44 | 226.53 | 226.36 | 226.53 | 11814.0 |
| 2017-01-11 07:00:00 | SPY | ETF | 226.48 | 226.51 | 226.33 | 226.35 | 23818.0 |
| 2017-01-11 07:30:00 | SPY | ETF | 226.3 | 226.3 | 226.15 | 226.15 | 53534.0 |
| 2017-01-11 08:00:00 | SPY | ETF | 226.48 | 226.48 | 226.12 | 226.17 | 82997.0 |
| 2017-01-11 08:30:00 | SPY | ETF | 226.16 | 226.3 | 226.16 | 226.26 | 75332.0 |
| 2017-01-11 09:00:00 | SPY | ETF | 226.25 | 226.52 | 226.25 | 226.36 | 398612.0 |
| 2017-01-11 09:30:00 | SPY | ETF | 226.36 | 226.81 | 226.27 | 226.8 | 5533726.0 |
| 2017-01-11 10:00:00 | SPY | ETF | 226.81 | 226.84 | 226.48 | 226.75 | 4128018.0 |
| 2017-01-11 10:30:00 | SPY | ETF | 226.75 | 227.0078 | 226.51 | 226.68 | 4446833.0 |
| 2017-01-11 11:00:00 | SPY | ETF | 226.685 | 227.02 | 226.16 | 226.19 | 5212694.0 |
| 2017-01-11 11:30:00 | SPY | ETF | 226.19 | 226.73 | 225.59 | 226.68 | 9107511.0 |
| 2017-01-11 12:00:00 | SPY | ETF | 226.68 | 226.83 | 226.13 | 226.5 | 5500506.0 |
| 2017-01-11 12:30:00 | SPY | ETF | 226.5 | 226.59 | 225.83 | 226.2659 | 4197355.0 |
| 2017-01-11 13:00:00 | SPY | ETF | 226.26 | 226.34 | 225.64 | 225.72 | 5038207.0 |
| 2017-01-11 13:30:00 | SPY | ETF | 225.71 | 226.45 | 225.64 | 226.33 | 5732985.0 |
| 2017-01-11 14:00:00 | SPY | ETF | 226.34 | 226.56 | 226.22 | 226.44 | 2918750.0 |
| 2017-01-11 14:30:00 | SPY | ETF | 226.44 | 226.73 | 226.43 | 226.625 | 2722931.0 |
| 2017-01-11 15:00:00 | SPY | ETF | 226.625 | 226.85 | 226.61 | 226.73 | 2592748.0 |
| 2017-01-11 15:30:00 | SPY | ETF | 226.72 | 227.07 | 226.71 | 227.06 | 8143279.0 |
| 2017-01-11 16:00:00 | SPY | ETF | 227.07 | 227.22 | 227.02 | 227.12 | 7048663.0 |
| 2017-01-11 16:30:00 | SPY | ETF | 227.1 | 227.21 | 226.46 | 227.15 | 600715.0 |
| 2017-01-11 17:00:00 | SPY | ETF | 227.14 | 227.18 | 227.07 | 227.15 | 218327.0 |
| 2017-01-11 17:30:00 | SPY | ETF | 227.13 | 227.14 | 227.08 | 227.11 | 39192.0 |
| 2017-01-11 18:00:00 | SPY | ETF | 227.09 | 227.09 | 227.03 | 227.03 | 43922.0 |
| 2017-01-11 18:30:00 | SPY | ETF | 227.04 | 227.06 | 227.02 | 227.05 | 13493.0 |
| 2017-01-11 19:00:00 | SPY | ETF | 227.07 | 227.07 | 226.95 | 226.96 | 19393.0 |
| 2017-01-11 19:30:00 | SPY | ETF | 226.96 | 226.96 | 226.88 | 226.94 | 23502.0 |
| 2017-01-11 04:00:00 | QQQ | ETF | 122.5 | 122.5 | 122.5 | 122.5 | 1032.0 |
| 2017-01-11 06:00:00 | QQQ | ETF | 122.72 | 122.72 | 122.72 | 122.72 | 300.0 |
| 2017-01-11 06:30:00 | QQQ | ETF | 122.7 | 122.72 | 122.68 | 122.72 | 1298.0 |
| 2017-01-11 07:00:00 | QQQ | ETF | 122.71 | 122.71 | 122.63 | 122.63 | 1800.0 |
| 2017-01-11 07:30:00 | QQQ | ETF | 122.66 | 122.66 | 122.57 | 122.59 | 6298.0 |
| 2017-01-11 08:00:00 | QQQ | ETF | 122.55 | 122.6 | 122.53 | 122.59 | 4975.0 |
| 2017-01-11 08:30:00 | QQQ | ETF | 122.6 | 122.62 | 122.6 | 122.62 | 12118.0 |
| 2017-01-11 09:00:00 | QQQ | ETF | 122.59 | 122.7 | 122.59 | 122.61 | 75988.0 |
| 2017-01-11 09:30:00 | QQQ | ETF | 122.63 | 122.74 | 122.51 | 122.7 | 2190185.0 |
| 2017-01-11 10:00:00 | QQQ | ETF | 122.72 | 122.82 | 122.56 | 122.75 | 1112003.0 |
| 2017-01-11 10:30:00 | QQQ | ETF | 122.75 | 122.89 | 122.66 | 122.76 | 1081536.0 |
| 2017-01-11 11:00:00 | QQQ | ETF | 122.77 | 122.88 | 122.32 | 122.35 | 1199050.0 |
| 2017-01-11 11:30:00 | QQQ | ETF | 122.34 | 122.665 | 122.02 | 122.64 | 2758031.0 |
| 2017-01-11 12:00:00 | QQQ | ETF | 122.65 | 122.74 | 122.37 | 122.57 | 1491091.0 |
| 2017-01-11 12:30:00 | QQQ | ETF | 122.58 | 122.61 | 122.23 | 122.44 | 863846.0 |
| 2017-01-11 13:00:00 | QQQ | ETF | 122.43 | 122.47 | 122.06 | 122.115 | 988648.0 |
| 2017-01-11 13:30:00 | QQQ | ETF | 122.11 | 122.46 | 122.06 | 122.4 | 1141815.0 |
| 2017-01-11 14:00:00 | QQQ | ETF | 122.41 | 122.55 | 122.345 | 122.515 | 646843.0 |
> showing 50 of 14,666 rows — these rows as CSV