PREVIEW / etf_30min / 2006-11-10
file: by_date/etf_30min/2006/2006-11-10.parquet size: 84 KB rows: 2,956
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 |
|---|---|---|---|---|---|---|---|
| 2006-11-10 07:00:00 | SPY | ETF | 138.35 | 138.36 | 138.3 | 138.36 | 57000.0 |
| 2006-11-10 07:30:00 | SPY | ETF | 138.4 | 138.43 | 138.33 | 138.33 | 105600.0 |
| 2006-11-10 08:00:00 | SPY | ETF | 138.34 | 138.43 | 138.19 | 138.26 | 1209400.0 |
| 2006-11-10 08:30:00 | SPY | ETF | 138.25 | 138.28 | 138.22 | 138.27 | 151100.0 |
| 2006-11-10 09:00:00 | SPY | ETF | 138.24 | 138.28 | 138.1 | 138.12 | 382900.0 |
| 2006-11-10 09:30:00 | SPY | ETF | 138.14 | 138.28 | 137.99 | 138.14 | 6210400.0 |
| 2006-11-10 10:00:00 | SPY | ETF | 138.14 | 138.34 | 137.95 | 137.99 | 6547700.0 |
| 2006-11-10 10:30:00 | SPY | ETF | 137.99 | 138.2 | 137.94 | 138.06 | 3906200.0 |
| 2006-11-10 11:00:00 | SPY | ETF | 138.05 | 138.07 | 137.85 | 138.05 | 2522800.0 |
| 2006-11-10 11:30:00 | SPY | ETF | 138.03 | 138.17 | 137.91 | 137.99 | 4228600.0 |
| 2006-11-10 12:00:00 | SPY | ETF | 137.99 | 138.11 | 137.97 | 138.03 | 1292100.0 |
| 2006-11-10 12:30:00 | SPY | ETF | 138.02 | 138.11 | 137.97 | 138.03 | 1153800.0 |
| 2006-11-10 13:00:00 | SPY | ETF | 138.03 | 138.05 | 137.82 | 137.91 | 1669500.0 |
| 2006-11-10 13:30:00 | SPY | ETF | 137.91 | 137.99 | 137.72 | 137.83 | 4234700.0 |
| 2006-11-10 14:00:00 | SPY | ETF | 137.83 | 138.11 | 137.76 | 138.02 | 3513100.0 |
| 2006-11-10 14:30:00 | SPY | ETF | 138.02 | 138.2 | 137.93 | 138.11 | 1839700.0 |
| 2006-11-10 15:00:00 | SPY | ETF | 138.12 | 138.17 | 138.0 | 138.09 | 1905700.0 |
| 2006-11-10 15:30:00 | SPY | ETF | 138.08 | 138.3 | 138.07 | 138.27 | 4187900.0 |
| 2006-11-10 16:00:00 | SPY | ETF | 138.28 | 138.32 | 138.26 | 138.26 | 1030900.0 |
| 2006-11-10 16:30:00 | SPY | ETF | 138.27 | 138.29 | 138.22 | 138.29 | 56000.0 |
| 2006-11-10 17:00:00 | SPY | ETF | 138.29 | 138.35 | 138.29 | 138.32 | 521300.0 |
| 2006-11-10 17:30:00 | SPY | ETF | 138.32 | 138.33 | 138.31 | 138.31 | 500.0 |
| 2006-11-10 18:00:00 | SPY | ETF | 138.3 | 138.3 | 138.3 | 138.3 | 500.0 |
| 2006-11-10 09:30:00 | QQQ | ETF | 42.83 | 42.9 | 42.67 | 42.81 | 15169600.0 |
| 2006-11-10 10:00:00 | QQQ | ETF | 42.8 | 42.95 | 42.76 | 42.79 | 12124400.0 |
| 2006-11-10 10:30:00 | QQQ | ETF | 42.79 | 42.92 | 42.75 | 42.89 | 5015600.0 |
| 2006-11-10 11:00:00 | QQQ | ETF | 42.88 | 42.88 | 42.77 | 42.85 | 4109500.0 |
| 2006-11-10 11:30:00 | QQQ | ETF | 42.84 | 42.95 | 42.83 | 42.86 | 3647600.0 |
| 2006-11-10 12:00:00 | QQQ | ETF | 42.86 | 42.96 | 42.86 | 42.92 | 1914200.0 |
| 2006-11-10 12:30:00 | QQQ | ETF | 42.92 | 42.94 | 42.87 | 42.9 | 1952700.0 |
| 2006-11-10 13:00:00 | QQQ | ETF | 42.9 | 42.91 | 42.84 | 42.88 | 1671800.0 |
| 2006-11-10 13:30:00 | QQQ | ETF | 42.87 | 42.89 | 42.78 | 42.83 | 7500100.0 |
| 2006-11-10 14:00:00 | QQQ | ETF | 42.83 | 42.96 | 42.8 | 42.94 | 5270600.0 |
| 2006-11-10 14:30:00 | QQQ | ETF | 42.94 | 43.0 | 42.88 | 42.98 | 3044700.0 |
| 2006-11-10 15:00:00 | QQQ | ETF | 42.97 | 42.99 | 42.92 | 42.97 | 2416100.0 |
| 2006-11-10 15:30:00 | QQQ | ETF | 42.97 | 43.04 | 42.96 | 43.03 | 7996400.0 |
| 2006-11-10 08:00:00 | IWM | ETF | 75.95 | 75.95 | 75.78 | 75.78 | 10200.0 |
| 2006-11-10 08:30:00 | IWM | ETF | 75.82 | 75.85 | 75.77 | 75.8 | 54700.0 |
| 2006-11-10 09:00:00 | IWM | ETF | 75.83 | 75.86 | 75.73 | 75.77 | 75300.0 |
| 2006-11-10 09:30:00 | IWM | ETF | 75.77 | 76.0 | 75.61 | 75.77 | 7344200.0 |
| 2006-11-10 10:00:00 | IWM | ETF | 75.77 | 76.1 | 75.77 | 75.83 | 4908400.0 |
| 2006-11-10 10:30:00 | IWM | ETF | 75.82 | 76.03 | 75.75 | 75.94 | 4610200.0 |
| 2006-11-10 11:00:00 | IWM | ETF | 75.91 | 76.1 | 75.8 | 76.08 | 1880100.0 |
| 2006-11-10 11:30:00 | IWM | ETF | 76.08 | 76.25 | 76.05 | 76.15 | 2676100.0 |
| 2006-11-10 12:00:00 | IWM | ETF | 76.14 | 76.2 | 76.07 | 76.12 | 857300.0 |
| 2006-11-10 12:30:00 | IWM | ETF | 76.1276 | 76.19 | 75.97 | 76.03 | 810800.0 |
| 2006-11-10 13:00:00 | IWM | ETF | 76.03 | 76.08 | 75.9 | 75.96 | 660800.0 |
| 2006-11-10 13:30:00 | IWM | ETF | 75.96 | 76.09 | 75.85 | 76.01 | 1330800.0 |
| 2006-11-10 14:00:00 | IWM | ETF | 76.01 | 76.34 | 75.92 | 76.26 | 3000200.0 |
| 2006-11-10 14:30:00 | IWM | ETF | 76.26 | 76.39 | 76.15 | 76.33 | 1624500.0 |
> showing 50 of 2,956 rows — these rows as CSV