PREVIEW / etf_30min / 2003-12-23
file: by_date/etf_30min/2003/2003-12-23.parquet size: 27 KB rows: 879
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 |
|---|---|---|---|---|---|---|---|
| 2003-12-23 08:00:00 | SPY | ETF | 109.56 | 109.64 | 109.56 | 109.59 | 16300.0 |
| 2003-12-23 08:30:00 | SPY | ETF | 109.56 | 109.59 | 109.51 | 109.54 | 16400.0 |
| 2003-12-23 09:00:00 | SPY | ETF | 109.54 | 109.59 | 109.45 | 109.45 | 46700.0 |
| 2003-12-23 09:30:00 | SPY | ETF | 109.48 | 109.7 | 109.38 | 109.56 | 5397900.0 |
| 2003-12-23 10:00:00 | SPY | ETF | 109.57 | 109.95 | 109.55 | 109.82 | 3026400.0 |
| 2003-12-23 10:30:00 | SPY | ETF | 109.83 | 109.85 | 109.69 | 109.72 | 1063700.0 |
| 2003-12-23 11:00:00 | SPY | ETF | 109.7 | 109.83 | 109.67 | 109.76 | 1334900.0 |
| 2003-12-23 11:30:00 | SPY | ETF | 109.77 | 109.81 | 109.71 | 109.75 | 1806400.0 |
| 2003-12-23 12:00:00 | SPY | ETF | 109.73 | 109.8 | 109.7 | 109.71 | 1201900.0 |
| 2003-12-23 12:30:00 | SPY | ETF | 109.72 | 109.82 | 109.69 | 109.77 | 726600.0 |
| 2003-12-23 13:00:00 | SPY | ETF | 109.78 | 109.79 | 109.5 | 109.61 | 1548600.0 |
| 2003-12-23 13:30:00 | SPY | ETF | 109.6 | 109.75 | 109.59 | 109.7 | 870800.0 |
| 2003-12-23 14:00:00 | SPY | ETF | 109.7 | 109.76 | 109.43 | 109.52 | 1549500.0 |
| 2003-12-23 14:30:00 | SPY | ETF | 109.52 | 109.61 | 109.38 | 109.52 | 888400.0 |
| 2003-12-23 15:00:00 | SPY | ETF | 109.51 | 109.63 | 109.47 | 109.59 | 764700.0 |
| 2003-12-23 15:30:00 | SPY | ETF | 109.59 | 109.87 | 109.57 | 109.79 | 2134700.0 |
| 2003-12-23 16:00:00 | SPY | ETF | 109.79 | 109.83 | 109.62 | 109.73 | 873400.0 |
| 2003-12-23 16:30:00 | SPY | ETF | 109.73 | 109.73 | 109.44 | 109.55 | 45200.0 |
| 2003-12-23 17:00:00 | SPY | ETF | 109.55 | 109.55 | 109.5 | 109.54 | 35200.0 |
| 2003-12-23 17:30:00 | SPY | ETF | 109.52 | 109.73 | 109.52 | 109.52 | 3200.0 |
| 2003-12-23 18:00:00 | SPY | ETF | 109.52 | 109.52 | 109.43 | 109.48 | 8600.0 |
| 2003-12-23 19:00:00 | SPY | ETF | 109.46 | 109.46 | 109.35 | 109.35 | 500.0 |
| 2003-12-23 19:30:00 | SPY | ETF | 109.4 | 109.41 | 109.4 | 109.41 | 300.0 |
| 2003-12-23 08:00:00 | QQQ | ETF | 35.58 | 35.61 | 35.58 | 35.6 | 14000.0 |
| 2003-12-23 08:30:00 | QQQ | ETF | 35.6 | 35.61 | 35.55 | 35.6 | 77600.0 |
| 2003-12-23 09:00:00 | QQQ | ETF | 35.59 | 35.62 | 35.58 | 35.6 | 55600.0 |
| 2003-12-23 09:30:00 | QQQ | ETF | 35.6 | 35.76 | 35.53 | 35.707 | 9295000.0 |
| 2003-12-23 10:00:00 | QQQ | ETF | 35.709 | 35.98 | 35.709 | 35.93 | 10260300.0 |
| 2003-12-23 10:30:00 | QQQ | ETF | 35.94 | 35.95 | 35.78 | 35.8 | 3356900.0 |
| 2003-12-23 11:00:00 | QQQ | ETF | 35.8 | 35.89 | 35.79 | 35.867 | 2052900.0 |
| 2003-12-23 11:30:00 | QQQ | ETF | 35.87 | 35.948 | 35.85 | 35.86 | 8485300.0 |
| 2003-12-23 12:00:00 | QQQ | ETF | 35.87 | 35.93 | 35.82 | 35.85 | 1943600.0 |
| 2003-12-23 12:30:00 | QQQ | ETF | 35.85 | 35.93 | 35.83 | 35.92 | 1679900.0 |
| 2003-12-23 13:00:00 | QQQ | ETF | 35.93 | 35.93 | 35.83 | 35.86 | 2095400.0 |
| 2003-12-23 13:30:00 | QQQ | ETF | 35.861 | 35.91 | 35.85 | 35.88 | 1332100.0 |
| 2003-12-23 14:00:00 | QQQ | ETF | 35.88 | 35.92 | 35.76 | 35.82 | 2901300.0 |
| 2003-12-23 14:30:00 | QQQ | ETF | 35.822 | 35.857 | 35.73 | 35.84 | 2668700.0 |
| 2003-12-23 15:00:00 | QQQ | ETF | 35.84 | 35.91 | 35.81 | 35.9 | 2642500.0 |
| 2003-12-23 15:30:00 | QQQ | ETF | 35.9 | 36.02 | 35.89 | 35.96 | 6902900.0 |
| 2003-12-23 16:00:00 | QQQ | ETF | 35.93 | 35.97 | 35.84 | 35.85 | 1726300.0 |
| 2003-12-23 16:30:00 | QQQ | ETF | 35.86 | 35.88 | 35.8 | 35.86 | 174800.0 |
| 2003-12-23 17:00:00 | QQQ | ETF | 35.87 | 35.89 | 35.823 | 35.84 | 44900.0 |
| 2003-12-23 17:30:00 | QQQ | ETF | 35.83 | 35.87 | 35.83 | 35.86 | 17100.0 |
| 2003-12-23 18:00:00 | QQQ | ETF | 35.86 | 35.86 | 35.836 | 35.84 | 27900.0 |
| 2003-12-23 18:30:00 | QQQ | ETF | 35.84 | 35.86 | 35.84 | 35.86 | 3800.0 |
| 2003-12-23 19:00:00 | QQQ | ETF | 35.86 | 35.86 | 35.83 | 35.83 | 5100.0 |
| 2003-12-23 19:30:00 | QQQ | ETF | 35.84 | 35.84 | 35.82 | 35.82 | 6000.0 |
| 2003-12-23 09:00:00 | IWM | ETF | 54.72 | 54.72 | 54.72 | 54.72 | 2000.0 |
| 2003-12-23 09:30:00 | IWM | ETF | 54.745 | 54.9455 | 54.62 | 54.778 | 398600.0 |
| 2003-12-23 10:00:00 | IWM | ETF | 54.8 | 55.025 | 54.79 | 54.97 | 1502400.0 |
> showing 50 of 879 rows — these rows as CSV