PREVIEW / etf_30min / 2011-11-21
file: by_date/etf_30min/2011/2011-11-21.parquet size: 296 KB rows: 9,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 |
|---|---|---|---|---|---|---|---|
| 2011-11-21 04:00:00 | SPY | ETF | 120.78 | 120.78 | 119.92 | 119.92 | 69871.0 |
| 2011-11-21 04:30:00 | SPY | ETF | 119.98 | 120.15 | 119.93 | 120.08 | 84100.0 |
| 2011-11-21 05:00:00 | SPY | ETF | 120.08 | 120.13 | 120.05 | 120.09 | 3760.0 |
| 2011-11-21 05:30:00 | SPY | ETF | 120.02 | 120.17 | 119.93 | 120.17 | 3875.0 |
| 2011-11-21 06:00:00 | SPY | ETF | 120.05 | 120.2 | 119.95 | 120.0 | 33364.0 |
| 2011-11-21 06:30:00 | SPY | ETF | 119.94 | 120.07 | 119.79 | 119.97 | 75202.0 |
| 2011-11-21 07:00:00 | SPY | ETF | 119.98 | 120.14 | 119.79 | 120.03 | 298197.0 |
| 2011-11-21 07:30:00 | SPY | ETF | 120.08 | 120.21 | 119.92 | 120.18 | 521363.0 |
| 2011-11-21 08:00:00 | SPY | ETF | 120.07 | 120.8222 | 119.97 | 120.09 | 608958.0 |
| 2011-11-21 08:30:00 | SPY | ETF | 120.1 | 120.85 | 119.92 | 120.38 | 1513291.0 |
| 2011-11-21 09:00:00 | SPY | ETF | 120.38 | 120.51 | 120.11 | 120.18 | 2164509.0 |
| 2011-11-21 09:30:00 | SPY | ETF | 120.2 | 120.35 | 119.47 | 119.65 | 31133656.0 |
| 2011-11-21 10:00:00 | SPY | ETF | 119.64 | 119.78 | 119.32 | 119.54 | 19490888.0 |
| 2011-11-21 10:30:00 | SPY | ETF | 119.54 | 119.589 | 118.9 | 118.95 | 17728409.0 |
| 2011-11-21 11:00:00 | SPY | ETF | 118.96 | 119.29 | 118.75 | 119.12 | 18825542.0 |
| 2011-11-21 11:30:00 | SPY | ETF | 119.12 | 119.18 | 118.65 | 119.14 | 17204064.0 |
| 2011-11-21 12:00:00 | SPY | ETF | 119.15 | 119.26 | 118.87 | 118.929 | 11153675.0 |
| 2011-11-21 12:30:00 | SPY | ETF | 118.9289 | 119.24 | 118.85 | 119.04 | 7078538.0 |
| 2011-11-21 13:00:00 | SPY | ETF | 119.03 | 119.48 | 119.02 | 119.24 | 9270457.0 |
| 2011-11-21 13:30:00 | SPY | ETF | 119.24 | 119.26 | 118.88 | 118.93 | 6645518.0 |
| 2011-11-21 14:00:00 | SPY | ETF | 118.93 | 119.79 | 118.85 | 119.53 | 13564952.0 |
| 2011-11-21 14:30:00 | SPY | ETF | 119.52 | 119.94 | 119.48 | 119.51 | 14825912.0 |
| 2011-11-21 15:00:00 | SPY | ETF | 119.51 | 120.18 | 119.27 | 120.04 | 16185020.0 |
| 2011-11-21 15:30:00 | SPY | ETF | 120.05 | 120.26 | 119.64 | 119.66 | 24324770.0 |
| 2011-11-21 16:00:00 | SPY | ETF | 119.65 | 121.9337 | 119.1 | 119.61 | 10672203.0 |
| 2011-11-21 16:30:00 | SPY | ETF | 119.62 | 119.64 | 119.2 | 119.37 | 1068430.0 |
| 2011-11-21 17:00:00 | SPY | ETF | 119.37 | 119.42 | 119.1 | 119.36 | 420827.0 |
| 2011-11-21 17:30:00 | SPY | ETF | 119.3 | 119.36 | 119.22 | 119.35 | 2919261.0 |
| 2011-11-21 18:00:00 | SPY | ETF | 119.39 | 119.62 | 119.3 | 119.45 | 573236.0 |
| 2011-11-21 18:30:00 | SPY | ETF | 119.42 | 119.57 | 119.42 | 119.57 | 157872.0 |
| 2011-11-21 19:00:00 | SPY | ETF | 119.57 | 119.83 | 119.57 | 119.75 | 258562.0 |
| 2011-11-21 19:30:00 | SPY | ETF | 119.75 | 119.95 | 119.75 | 119.95 | 148973.0 |
| 2011-11-21 04:00:00 | QQQ | ETF | 54.85 | 54.85 | 54.65 | 54.65 | 2771.0 |
| 2011-11-21 04:30:00 | QQQ | ETF | 54.68 | 54.68 | 54.64 | 54.68 | 1936.0 |
| 2011-11-21 05:00:00 | QQQ | ETF | 54.66 | 54.75 | 54.66 | 54.72 | 11600.0 |
| 2011-11-21 05:30:00 | QQQ | ETF | 54.73 | 54.73 | 54.65 | 54.72 | 9350.0 |
| 2011-11-21 06:00:00 | QQQ | ETF | 54.68 | 54.83 | 54.68 | 54.7 | 17100.0 |
| 2011-11-21 06:30:00 | QQQ | ETF | 54.7 | 54.71 | 54.7 | 54.71 | 500.0 |
| 2011-11-21 07:00:00 | QQQ | ETF | 54.71 | 54.79 | 54.66 | 54.77 | 15365.0 |
| 2011-11-21 07:30:00 | QQQ | ETF | 54.78 | 54.81 | 54.7 | 54.74 | 56108.0 |
| 2011-11-21 08:00:00 | QQQ | ETF | 54.72 | 54.97 | 54.5 | 54.73 | 175598.0 |
| 2011-11-21 08:30:00 | QQQ | ETF | 54.73 | 54.86 | 54.73 | 54.81 | 210374.0 |
| 2011-11-21 09:00:00 | QQQ | ETF | 54.81 | 54.84 | 54.63 | 54.69 | 453759.0 |
| 2011-11-21 09:30:00 | QQQ | ETF | 54.69 | 54.73 | 54.15 | 54.208 | 7364107.0 |
| 2011-11-21 10:00:00 | QQQ | ETF | 54.23 | 54.26 | 54.04 | 54.1 | 3575507.0 |
| 2011-11-21 10:30:00 | QQQ | ETF | 54.11 | 54.19 | 53.89 | 53.91 | 4580896.0 |
| 2011-11-21 11:00:00 | QQQ | ETF | 53.91 | 54.09 | 53.86 | 53.99 | 3859420.0 |
| 2011-11-21 11:30:00 | QQQ | ETF | 53.98 | 54.03 | 53.78 | 53.99 | 3668728.0 |
| 2011-11-21 12:00:00 | QQQ | ETF | 53.99 | 54.06 | 53.92 | 53.94 | 2715394.0 |
| 2011-11-21 12:30:00 | QQQ | ETF | 53.9399 | 54.12 | 53.91 | 54.04 | 1788450.0 |
> showing 50 of 9,964 rows — these rows as CSV