PREVIEW / etf_30min / 2006-04-06
file: by_date/etf_30min/2006/2006-04-06.parquet size: 59 KB rows: 2,160
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-04-06 06:00:00 | SPY | ETF | 131.07 | 131.07 | 131.07 | 131.07 | 7000.0 |
| 2006-04-06 07:00:00 | SPY | ETF | 130.93 | 130.95 | 130.91 | 130.91 | 23000.0 |
| 2006-04-06 07:30:00 | SPY | ETF | 130.95 | 130.95 | 130.92 | 130.94 | 23900.0 |
| 2006-04-06 08:00:00 | SPY | ETF | 130.96 | 131.0 | 130.9 | 130.91 | 621500.0 |
| 2006-04-06 08:30:00 | SPY | ETF | 130.95 | 131.03 | 130.87 | 130.94 | 444300.0 |
| 2006-04-06 09:00:00 | SPY | ETF | 130.96 | 130.98 | 130.85 | 130.85 | 772000.0 |
| 2006-04-06 09:30:00 | SPY | ETF | 130.85 | 131.01 | 130.75 | 130.89 | 4868000.0 |
| 2006-04-06 10:00:00 | SPY | ETF | 130.89 | 130.98 | 130.71 | 130.72 | 3212700.0 |
| 2006-04-06 10:30:00 | SPY | ETF | 130.72 | 130.82 | 130.57 | 130.75 | 6464700.0 |
| 2006-04-06 11:00:00 | SPY | ETF | 130.75 | 130.93 | 130.71 | 130.79 | 2274900.0 |
| 2006-04-06 11:30:00 | SPY | ETF | 130.79 | 130.83 | 130.42 | 130.44 | 2432500.0 |
| 2006-04-06 12:00:00 | SPY | ETF | 130.45 | 130.49 | 130.19 | 130.24 | 5137200.0 |
| 2006-04-06 12:30:00 | SPY | ETF | 130.24 | 130.5 | 130.21 | 130.43 | 6483500.0 |
| 2006-04-06 13:00:00 | SPY | ETF | 130.43 | 130.72 | 130.39 | 130.66 | 2026900.0 |
| 2006-04-06 13:30:00 | SPY | ETF | 130.66 | 131.05 | 130.65 | 130.97 | 6270600.0 |
| 2006-04-06 14:00:00 | SPY | ETF | 130.97 | 131.21 | 130.89 | 130.94 | 5830300.0 |
| 2006-04-06 14:30:00 | SPY | ETF | 130.95 | 130.97 | 130.81 | 130.92 | 2261000.0 |
| 2006-04-06 15:00:00 | SPY | ETF | 130.91 | 130.94 | 130.79 | 130.84 | 1616500.0 |
| 2006-04-06 15:30:00 | SPY | ETF | 130.84 | 130.93 | 130.68 | 130.83 | 4796400.0 |
| 2006-04-06 16:00:00 | SPY | ETF | 130.83 | 130.93 | 130.82 | 130.88 | 749200.0 |
| 2006-04-06 16:30:00 | SPY | ETF | 130.87 | 130.89 | 130.83 | 130.86 | 55800.0 |
| 2006-04-06 17:00:00 | SPY | ETF | 130.88 | 130.9 | 130.85 | 130.9 | 100500.0 |
| 2006-04-06 17:30:00 | SPY | ETF | 130.9 | 130.9 | 130.83 | 130.87 | 7100.0 |
| 2006-04-06 18:00:00 | SPY | ETF | 130.88 | 130.91 | 130.88 | 130.9 | 4100.0 |
| 2006-04-06 18:30:00 | SPY | ETF | 130.88 | 130.88 | 130.88 | 130.88 | 200.0 |
| 2006-04-06 19:30:00 | SPY | ETF | 130.91 | 130.91 | 130.9 | 130.9 | 600.0 |
| 2006-04-06 09:30:00 | QQQ | ETF | 42.58 | 42.69 | 42.56 | 42.63 | 12725700.0 |
| 2006-04-06 10:00:00 | QQQ | ETF | 42.63 | 42.68 | 42.58 | 42.59 | 5162200.0 |
| 2006-04-06 10:30:00 | QQQ | ETF | 42.58 | 42.66 | 42.51 | 42.63 | 10292700.0 |
| 2006-04-06 11:00:00 | QQQ | ETF | 42.62 | 42.73 | 42.61 | 42.68 | 4524600.0 |
| 2006-04-06 11:30:00 | QQQ | ETF | 42.68 | 42.69 | 42.5 | 42.51 | 6415800.0 |
| 2006-04-06 12:00:00 | QQQ | ETF | 42.51 | 42.56 | 40.53 | 42.48 | 6069500.0 |
| 2006-04-06 12:30:00 | QQQ | ETF | 42.48 | 42.65 | 42.44 | 42.61 | 8474800.0 |
| 2006-04-06 13:00:00 | QQQ | ETF | 42.61 | 42.72 | 42.58 | 42.7 | 4759900.0 |
| 2006-04-06 13:30:00 | QQQ | ETF | 42.7 | 42.9 | 42.69 | 42.86 | 8239600.0 |
| 2006-04-06 14:00:00 | QQQ | ETF | 42.86 | 42.94 | 42.79 | 42.8 | 7686300.0 |
| 2006-04-06 14:30:00 | QQQ | ETF | 42.8 | 42.82 | 42.75 | 42.79 | 4327100.0 |
| 2006-04-06 15:00:00 | QQQ | ETF | 42.79 | 42.8 | 42.73 | 42.74 | 2533700.0 |
| 2006-04-06 15:30:00 | QQQ | ETF | 42.73 | 42.79 | 42.66 | 42.74 | 5304900.0 |
| 2006-04-06 08:00:00 | IWM | ETF | 76.05 | 76.05 | 75.99 | 75.99 | 1300.0 |
| 2006-04-06 08:30:00 | IWM | ETF | 75.95 | 76.05 | 75.95 | 76.03 | 5400.0 |
| 2006-04-06 09:00:00 | IWM | ETF | 76.03 | 76.03 | 75.92 | 75.93 | 150700.0 |
| 2006-04-06 09:30:00 | IWM | ETF | 75.94 | 76.04 | 75.84 | 75.97 | 1461300.0 |
| 2006-04-06 10:00:00 | IWM | ETF | 75.97 | 75.98 | 75.77 | 75.81 | 2496100.0 |
| 2006-04-06 10:30:00 | IWM | ETF | 75.81 | 75.92 | 75.73 | 75.8 | 2379900.0 |
| 2006-04-06 11:00:00 | IWM | ETF | 75.8 | 75.96 | 75.771 | 75.94 | 1082800.0 |
| 2006-04-06 11:30:00 | IWM | ETF | 75.94 | 75.96 | 75.59 | 75.61 | 1939200.0 |
| 2006-04-06 12:00:00 | IWM | ETF | 75.61 | 75.72 | 75.55 | 75.58 | 3496500.0 |
| 2006-04-06 12:30:00 | IWM | ETF | 75.58 | 75.75 | 75.55 | 75.69 | 734300.0 |
| 2006-04-06 13:00:00 | IWM | ETF | 75.7 | 75.96 | 75.65 | 75.93 | 1789000.0 |
> showing 50 of 2,160 rows — these rows as CSV