PREVIEW / etf_30min / 2011-10-10
file: by_date/etf_30min/2011/2011-10-10.parquet size: 279 KB rows: 9,429
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 |
|---|---|---|---|---|---|---|---|
| 2011-10-10 04:00:00 | SPY | ETF | 116.91 | 117.32 | 116.91 | 117.31 | 7351.0 |
| 2011-10-10 04:30:00 | SPY | ETF | 117.16 | 117.43 | 117.14 | 117.4 | 16936.0 |
| 2011-10-10 05:00:00 | SPY | ETF | 117.4 | 117.4 | 117.35 | 117.4 | 1100.0 |
| 2011-10-10 05:30:00 | SPY | ETF | 117.35 | 117.46 | 117.35 | 117.46 | 2368.0 |
| 2011-10-10 06:00:00 | SPY | ETF | 117.42 | 117.77 | 117.42 | 117.71 | 74279.0 |
| 2011-10-10 06:30:00 | SPY | ETF | 117.68 | 117.7 | 117.43 | 117.47 | 71110.0 |
| 2011-10-10 07:00:00 | SPY | ETF | 117.45 | 117.71 | 117.4 | 117.64 | 683516.0 |
| 2011-10-10 07:30:00 | SPY | ETF | 117.63 | 117.66 | 117.35 | 117.48 | 531385.0 |
| 2011-10-10 08:00:00 | SPY | ETF | 117.45 | 117.7 | 117.44 | 117.58 | 822073.0 |
| 2011-10-10 08:30:00 | SPY | ETF | 117.58 | 117.63 | 117.4 | 117.46 | 798181.0 |
| 2011-10-10 09:00:00 | SPY | ETF | 117.46 | 117.69 | 117.44 | 117.68 | 1446909.0 |
| 2011-10-10 09:30:00 | SPY | ETF | 117.68 | 118.38 | 117.67 | 118.34 | 26919126.0 |
| 2011-10-10 10:00:00 | SPY | ETF | 118.33 | 118.94 | 118.21 | 118.791 | 21317538.0 |
| 2011-10-10 10:30:00 | SPY | ETF | 118.79 | 119.11 | 118.75 | 118.82 | 22251576.0 |
| 2011-10-10 11:00:00 | SPY | ETF | 118.82 | 118.89 | 118.65 | 118.8787 | 18472986.0 |
| 2011-10-10 11:30:00 | SPY | ETF | 118.87 | 119.03 | 118.76 | 118.941 | 7335203.0 |
| 2011-10-10 12:00:00 | SPY | ETF | 118.95 | 119.03 | 118.77 | 118.93 | 8820621.0 |
| 2011-10-10 12:30:00 | SPY | ETF | 118.94 | 118.98 | 118.73 | 118.841 | 6316307.0 |
| 2011-10-10 13:00:00 | SPY | ETF | 118.84 | 119.23 | 118.78 | 119.07 | 9636830.0 |
| 2011-10-10 13:30:00 | SPY | ETF | 119.06 | 119.1005 | 118.88 | 118.97 | 5268415.0 |
| 2011-10-10 14:00:00 | SPY | ETF | 118.98 | 119.06 | 118.75 | 118.98 | 6357881.0 |
| 2011-10-10 14:30:00 | SPY | ETF | 118.98 | 119.06 | 118.74 | 118.763 | 7924248.0 |
| 2011-10-10 15:00:00 | SPY | ETF | 118.76 | 118.83 | 118.24 | 118.4 | 20928468.0 |
| 2011-10-10 15:30:00 | SPY | ETF | 118.39 | 119.59 | 118.25 | 119.59 | 40034229.0 |
| 2011-10-10 16:00:00 | SPY | ETF | 119.6 | 119.78 | 118.3556 | 119.61 | 14838722.0 |
| 2011-10-10 16:30:00 | SPY | ETF | 119.62 | 119.7 | 118.868 | 119.56 | 4986849.0 |
| 2011-10-10 17:00:00 | SPY | ETF | 119.54 | 119.59 | 119.42 | 119.47 | 364335.0 |
| 2011-10-10 17:30:00 | SPY | ETF | 119.44 | 119.52 | 119.42 | 119.5 | 75526.0 |
| 2011-10-10 18:00:00 | SPY | ETF | 119.49 | 119.58 | 119.26 | 119.4 | 185747.0 |
| 2011-10-10 18:30:00 | SPY | ETF | 119.42 | 119.54 | 119.4 | 119.47 | 33320.0 |
| 2011-10-10 19:00:00 | SPY | ETF | 119.46 | 119.5 | 119.41 | 119.44 | 37337.0 |
| 2011-10-10 19:30:00 | SPY | ETF | 119.48 | 119.59 | 119.41 | 119.48 | 305880.0 |
| 2011-10-10 04:00:00 | QQQ | ETF | 54.68 | 54.74 | 54.68 | 54.73 | 3017.0 |
| 2011-10-10 04:30:00 | QQQ | ETF | 54.75 | 54.75 | 54.75 | 54.75 | 200.0 |
| 2011-10-10 05:00:00 | QQQ | ETF | 54.82 | 54.82 | 54.77 | 54.77 | 700.0 |
| 2011-10-10 05:30:00 | QQQ | ETF | 54.75 | 54.75 | 54.75 | 54.75 | 400.0 |
| 2011-10-10 06:00:00 | QQQ | ETF | 54.9 | 54.9 | 54.89 | 54.89 | 900.0 |
| 2011-10-10 06:30:00 | QQQ | ETF | 54.96 | 54.96 | 54.9 | 54.9 | 400.0 |
| 2011-10-10 07:00:00 | QQQ | ETF | 54.76 | 54.92 | 54.76 | 54.91 | 21020.0 |
| 2011-10-10 07:30:00 | QQQ | ETF | 54.9 | 54.95 | 54.8 | 54.85 | 71538.0 |
| 2011-10-10 08:00:00 | QQQ | ETF | 54.84 | 54.93 | 54.84 | 54.92 | 74627.0 |
| 2011-10-10 08:30:00 | QQQ | ETF | 54.92 | 54.93 | 54.84 | 54.88 | 108344.0 |
| 2011-10-10 09:00:00 | QQQ | ETF | 54.88 | 54.98 | 54.88 | 54.98 | 267628.0 |
| 2011-10-10 09:30:00 | QQQ | ETF | 54.98 | 55.38 | 54.89 | 55.36 | 6712562.0 |
| 2011-10-10 10:00:00 | QQQ | ETF | 55.37 | 55.75 | 55.29 | 55.6699 | 4927047.0 |
| 2011-10-10 10:30:00 | QQQ | ETF | 55.67 | 55.82 | 55.62 | 55.68 | 3781692.0 |
| 2011-10-10 11:00:00 | QQQ | ETF | 55.69 | 55.73 | 55.58 | 55.679 | 3376642.0 |
| 2011-10-10 11:30:00 | QQQ | ETF | 55.67 | 55.76 | 55.6114 | 55.72 | 1844932.0 |
| 2011-10-10 12:00:00 | QQQ | ETF | 55.73 | 55.76 | 55.61 | 55.66 | 1413200.0 |
| 2011-10-10 12:30:00 | QQQ | ETF | 55.66 | 55.7 | 55.55 | 55.6 | 1544788.0 |
> showing 50 of 9,429 rows — these rows as CSV