PREVIEW / etf_30min / 2006-09-27
file: by_date/etf_30min/2006/2006-09-27.parquet size: 82 KB rows: 2,872
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-09-27 04:00:00 | SPY | ETF | 133.64 | 133.64 | 133.64 | 133.64 | 100.0 |
| 2006-09-27 07:00:00 | SPY | ETF | 133.72 | 133.81 | 133.72 | 133.79 | 22700.0 |
| 2006-09-27 07:30:00 | SPY | ETF | 133.78 | 133.82 | 133.78 | 133.8 | 153200.0 |
| 2006-09-27 08:00:00 | SPY | ETF | 133.74 | 133.83 | 133.74 | 133.82 | 288500.0 |
| 2006-09-27 08:30:00 | SPY | ETF | 133.81 | 133.81 | 133.33 | 133.34 | 1783500.0 |
| 2006-09-27 09:00:00 | SPY | ETF | 133.34 | 133.47 | 133.29 | 133.47 | 921600.0 |
| 2006-09-27 09:30:00 | SPY | ETF | 133.49 | 133.79 | 133.44 | 133.69 | 10525300.0 |
| 2006-09-27 10:00:00 | SPY | ETF | 133.68 | 133.95 | 133.47 | 133.59 | 7867000.0 |
| 2006-09-27 10:30:00 | SPY | ETF | 133.6 | 133.86 | 133.4 | 133.65 | 6368100.0 |
| 2006-09-27 11:00:00 | SPY | ETF | 133.69 | 133.81 | 133.5 | 133.7 | 3865700.0 |
| 2006-09-27 11:30:00 | SPY | ETF | 133.71 | 133.92 | 133.69 | 133.86 | 5143900.0 |
| 2006-09-27 12:00:00 | SPY | ETF | 133.86 | 133.97 | 133.63 | 133.66 | 2731100.0 |
| 2006-09-27 12:30:00 | SPY | ETF | 133.65 | 133.84 | 133.64 | 133.75 | 1623000.0 |
| 2006-09-27 13:00:00 | SPY | ETF | 133.75 | 133.9 | 133.75 | 133.8 | 2200300.0 |
| 2006-09-27 13:30:00 | SPY | ETF | 133.8 | 133.81 | 133.55 | 133.73 | 4215300.0 |
| 2006-09-27 14:00:00 | SPY | ETF | 133.71 | 133.81 | 133.46 | 133.52 | 6615000.0 |
| 2006-09-27 14:30:00 | SPY | ETF | 133.52 | 133.6 | 133.3 | 133.53 | 7578500.0 |
| 2006-09-27 15:00:00 | SPY | ETF | 133.53 | 133.69 | 133.27 | 133.5 | 7974800.0 |
| 2006-09-27 15:30:00 | SPY | ETF | 133.51 | 133.68 | 133.46 | 133.6302 | 4418200.0 |
| 2006-09-27 16:00:00 | SPY | ETF | 133.66 | 133.75 | 133.59 | 133.72 | 1018800.0 |
| 2006-09-27 16:30:00 | SPY | ETF | 133.72 | 133.72 | 133.43 | 133.66 | 741500.0 |
| 2006-09-27 17:00:00 | SPY | ETF | 133.7 | 133.72 | 133.6 | 133.66 | 443700.0 |
| 2006-09-27 17:30:00 | SPY | ETF | 133.69 | 133.7 | 133.69 | 133.7 | 900.0 |
| 2006-09-27 18:00:00 | SPY | ETF | 133.7 | 133.7 | 133.67 | 133.67 | 800.0 |
| 2006-09-27 19:00:00 | SPY | ETF | 133.68 | 133.68 | 133.68 | 133.68 | 400.0 |
| 2006-09-27 09:30:00 | QQQ | ETF | 40.7 | 40.85 | 40.66 | 40.81 | 12226600.0 |
| 2006-09-27 10:00:00 | QQQ | ETF | 40.81 | 40.95 | 40.67 | 40.74 | 16505700.0 |
| 2006-09-27 10:30:00 | QQQ | ETF | 40.74 | 40.88 | 40.7 | 40.83 | 10353300.0 |
| 2006-09-27 11:00:00 | QQQ | ETF | 40.83 | 40.9 | 40.74 | 40.82 | 6505200.0 |
| 2006-09-27 11:30:00 | QQQ | ETF | 40.84 | 40.92 | 40.81 | 40.89 | 5619900.0 |
| 2006-09-27 12:00:00 | QQQ | ETF | 40.9 | 40.94 | 40.77 | 40.79 | 5256100.0 |
| 2006-09-27 12:30:00 | QQQ | ETF | 40.79 | 40.84 | 40.77 | 40.8 | 3320800.0 |
| 2006-09-27 13:00:00 | QQQ | ETF | 40.81 | 40.85 | 40.76 | 40.77 | 5495900.0 |
| 2006-09-27 13:30:00 | QQQ | ETF | 40.77 | 40.78 | 40.67 | 40.75 | 6934800.0 |
| 2006-09-27 14:00:00 | QQQ | ETF | 40.76 | 40.8 | 40.62 | 40.64 | 5314800.0 |
| 2006-09-27 14:30:00 | QQQ | ETF | 40.64 | 40.67 | 40.51 | 40.6 | 7822000.0 |
| 2006-09-27 15:00:00 | QQQ | ETF | 40.61 | 40.77 | 40.5 | 40.61 | 7645000.0 |
| 2006-09-27 15:30:00 | QQQ | ETF | 40.61 | 40.71 | 40.59 | 40.71 | 8226200.0 |
| 2006-09-27 07:30:00 | IWM | ETF | 72.45 | 72.51 | 72.45 | 72.51 | 4500.0 |
| 2006-09-27 08:00:00 | IWM | ETF | 72.48 | 72.55 | 72.48 | 72.51 | 46100.0 |
| 2006-09-27 08:30:00 | IWM | ETF | 72.56 | 72.56 | 72.11 | 72.17 | 312700.0 |
| 2006-09-27 09:00:00 | IWM | ETF | 72.17 | 72.23 | 72.11 | 72.23 | 269900.0 |
| 2006-09-27 09:30:00 | IWM | ETF | 72.21 | 72.74 | 72.2 | 72.59 | 4607700.0 |
| 2006-09-27 10:00:00 | IWM | ETF | 72.59 | 72.85 | 72.47 | 72.65 | 3845200.0 |
| 2006-09-27 10:30:00 | IWM | ETF | 72.65 | 72.96 | 72.51 | 72.71 | 3116000.0 |
| 2006-09-27 11:00:00 | IWM | ETF | 72.71 | 72.84 | 72.55 | 72.74 | 2604700.0 |
| 2006-09-27 11:30:00 | IWM | ETF | 72.75 | 72.92 | 72.7 | 72.86 | 2180100.0 |
| 2006-09-27 12:00:00 | IWM | ETF | 72.87 | 72.96 | 72.74 | 72.78 | 2056700.0 |
| 2006-09-27 12:30:00 | IWM | ETF | 72.77 | 72.91 | 72.73 | 72.83 | 1210500.0 |
| 2006-09-27 13:00:00 | IWM | ETF | 72.83 | 72.89 | 72.75 | 72.79 | 1538000.0 |
> showing 50 of 2,872 rows — these rows as CSV