PREVIEW / etf_30min / 2006-09-29
file: by_date/etf_30min/2006/2006-09-29.parquet size: 79 KB rows: 2,846
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-29 07:30:00 | SPY | ETF | 133.93 | 133.93 | 133.9 | 133.92 | 5900.0 |
| 2006-09-29 08:00:00 | SPY | ETF | 133.93 | 133.98 | 133.87 | 133.93 | 355100.0 |
| 2006-09-29 08:30:00 | SPY | ETF | 133.92 | 134.06 | 133.79 | 133.98 | 767600.0 |
| 2006-09-29 09:00:00 | SPY | ETF | 133.96 | 134.02 | 133.79 | 133.79 | 1350100.0 |
| 2006-09-29 09:30:00 | SPY | ETF | 133.8 | 133.9 | 133.6 | 133.7 | 4126000.0 |
| 2006-09-29 10:00:00 | SPY | ETF | 133.71 | 133.94 | 133.7 | 133.78 | 6227000.0 |
| 2006-09-29 10:30:00 | SPY | ETF | 133.77 | 133.84 | 133.65 | 133.77 | 3666400.0 |
| 2006-09-29 11:00:00 | SPY | ETF | 133.77 | 133.81 | 133.59 | 133.64 | 2864200.0 |
| 2006-09-29 11:30:00 | SPY | ETF | 133.63 | 133.94 | 133.62 | 133.82 | 3277400.0 |
| 2006-09-29 12:00:00 | SPY | ETF | 133.82 | 133.8501 | 133.7 | 133.82 | 2227100.0 |
| 2006-09-29 12:30:00 | SPY | ETF | 133.81 | 133.82 | 133.73 | 133.77 | 368300.0 |
| 2006-09-29 13:00:00 | SPY | ETF | 133.77 | 133.88 | 133.66 | 133.67 | 1651300.0 |
| 2006-09-29 13:30:00 | SPY | ETF | 133.67 | 133.82 | 133.66 | 133.76 | 1987500.0 |
| 2006-09-29 14:00:00 | SPY | ETF | 133.76 | 133.83 | 133.72 | 133.78 | 1819700.0 |
| 2006-09-29 14:30:00 | SPY | ETF | 133.78 | 133.81 | 133.65 | 133.69 | 1978400.0 |
| 2006-09-29 15:00:00 | SPY | ETF | 133.68 | 133.7 | 133.54 | 133.69 | 3475700.0 |
| 2006-09-29 15:30:00 | SPY | ETF | 133.7 | 133.7 | 133.48 | 133.48 | 5080800.0 |
| 2006-09-29 16:00:00 | SPY | ETF | 133.49 | 133.66 | 133.48 | 133.6 | 2994500.0 |
| 2006-09-29 16:30:00 | SPY | ETF | 133.61 | 133.61 | 133.56 | 133.56 | 840300.0 |
| 2006-09-29 17:00:00 | SPY | ETF | 133.57 | 133.6 | 133.55 | 133.6 | 5600.0 |
| 2006-09-29 17:30:00 | SPY | ETF | 133.6 | 133.64 | 133.6 | 133.61 | 11700.0 |
| 2006-09-29 18:00:00 | SPY | ETF | 133.61 | 133.61 | 133.55 | 133.55 | 25000.0 |
| 2006-09-29 19:30:00 | SPY | ETF | 133.55 | 133.67 | 133.55 | 133.67 | 2500.0 |
| 2006-09-29 09:30:00 | QQQ | ETF | 40.89 | 40.92 | 40.65 | 40.75 | 15503200.0 |
| 2006-09-29 10:00:00 | QQQ | ETF | 40.75 | 40.91 | 40.75 | 40.86 | 11668800.0 |
| 2006-09-29 10:30:00 | QQQ | ETF | 40.86 | 40.9 | 40.8 | 40.88 | 5829600.0 |
| 2006-09-29 11:00:00 | QQQ | ETF | 40.88 | 40.92 | 40.78 | 40.83 | 4374700.0 |
| 2006-09-29 11:30:00 | QQQ | ETF | 40.83 | 40.93 | 40.82 | 40.91 | 2669600.0 |
| 2006-09-29 12:00:00 | QQQ | ETF | 40.91 | 40.91 | 40.84 | 40.89 | 2757900.0 |
| 2006-09-29 12:30:00 | QQQ | ETF | 40.88 | 40.88 | 40.81 | 40.87 | 2994800.0 |
| 2006-09-29 13:00:00 | QQQ | ETF | 40.87 | 40.91 | 40.79 | 40.79 | 3269800.0 |
| 2006-09-29 13:30:00 | QQQ | ETF | 40.79 | 40.85 | 40.77 | 40.82 | 2764700.0 |
| 2006-09-29 14:00:00 | QQQ | ETF | 40.81 | 40.84 | 40.78 | 40.8 | 3634100.0 |
| 2006-09-29 14:30:00 | QQQ | ETF | 40.8 | 40.82 | 40.72 | 40.75 | 2905400.0 |
| 2006-09-29 15:00:00 | QQQ | ETF | 40.75 | 40.77 | 40.7 | 40.75 | 3704200.0 |
| 2006-09-29 15:30:00 | QQQ | ETF | 40.75 | 40.75 | 40.62 | 40.64 | 15800200.0 |
| 2006-09-29 08:00:00 | IWM | ETF | 72.82 | 72.9 | 72.82 | 72.85 | 14500.0 |
| 2006-09-29 08:30:00 | IWM | ETF | 72.79 | 72.9 | 72.79 | 72.9 | 25800.0 |
| 2006-09-29 09:00:00 | IWM | ETF | 72.88 | 72.88 | 72.74 | 72.75 | 85500.0 |
| 2006-09-29 09:30:00 | IWM | ETF | 72.71 | 72.99 | 72.56 | 72.71 | 4695000.0 |
| 2006-09-29 10:00:00 | IWM | ETF | 72.72 | 72.97 | 72.7 | 72.75 | 3528100.0 |
| 2006-09-29 10:30:00 | IWM | ETF | 72.75 | 72.83 | 72.66 | 72.8 | 1693100.0 |
| 2006-09-29 11:00:00 | IWM | ETF | 72.8 | 72.85 | 72.6 | 72.68 | 1654600.0 |
| 2006-09-29 11:30:00 | IWM | ETF | 72.67 | 72.84 | 72.67 | 72.8 | 954800.0 |
| 2006-09-29 12:00:00 | IWM | ETF | 72.79 | 72.8 | 72.67 | 72.78 | 424400.0 |
| 2006-09-29 12:30:00 | IWM | ETF | 72.78 | 72.8 | 72.68 | 72.79 | 1123700.0 |
| 2006-09-29 13:00:00 | IWM | ETF | 72.78 | 72.85 | 72.63 | 72.63 | 1120900.0 |
| 2006-09-29 13:30:00 | IWM | ETF | 72.64 | 72.76 | 72.62 | 72.67 | 759300.0 |
| 2006-09-29 14:00:00 | IWM | ETF | 72.66 | 72.75 | 72.64 | 72.74 | 612000.0 |
| 2006-09-29 14:30:00 | IWM | ETF | 72.74 | 72.77 | 72.55 | 72.59 | 2315800.0 |
> showing 50 of 2,846 rows — these rows as CSV