PREVIEW / etf_30min / 2003-08-12
file: by_date/etf_30min/2003/2003-08-12.parquet size: 22 KB rows: 676
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-08-12 08:00:00 | SPY | ETF | 98.9 | 98.9 | 98.85 | 98.87 | 8300.0 |
| 2003-08-12 08:30:00 | SPY | ETF | 98.82 | 98.84 | 98.78 | 98.79 | 15300.0 |
| 2003-08-12 09:00:00 | SPY | ETF | 98.79 | 98.81 | 98.72 | 98.72 | 4800.0 |
| 2003-08-12 09:30:00 | SPY | ETF | 98.71 | 98.78 | 98.48 | 98.62 | 2260500.0 |
| 2003-08-12 10:00:00 | SPY | ETF | 98.6 | 98.89 | 98.57 | 98.74 | 1720300.0 |
| 2003-08-12 10:30:00 | SPY | ETF | 98.74 | 98.9 | 98.56 | 98.6 | 1135500.0 |
| 2003-08-12 11:00:00 | SPY | ETF | 98.64 | 98.77 | 98.53 | 98.57 | 676000.0 |
| 2003-08-12 11:30:00 | SPY | ETF | 98.59 | 98.65 | 98.42 | 98.65 | 1004100.0 |
| 2003-08-12 12:00:00 | SPY | ETF | 98.65 | 98.69 | 98.57 | 98.63 | 471000.0 |
| 2003-08-12 12:30:00 | SPY | ETF | 98.64 | 98.74 | 98.64 | 98.69 | 342900.0 |
| 2003-08-12 13:00:00 | SPY | ETF | 98.7 | 98.72 | 98.56 | 98.59 | 386800.0 |
| 2003-08-12 13:30:00 | SPY | ETF | 98.59 | 98.7 | 98.53 | 98.66 | 529000.0 |
| 2003-08-12 14:00:00 | SPY | ETF | 98.659 | 98.88 | 98.5 | 98.71 | 3422300.0 |
| 2003-08-12 14:30:00 | SPY | ETF | 98.71 | 99.29 | 98.45 | 99.06 | 7744900.0 |
| 2003-08-12 15:00:00 | SPY | ETF | 99.08 | 99.18 | 98.89 | 99.04 | 1797100.0 |
| 2003-08-12 15:30:00 | SPY | ETF | 99.06 | 99.56 | 98.98 | 99.54 | 4472100.0 |
| 2003-08-12 16:00:00 | SPY | ETF | 99.54 | 99.65 | 98.87 | 99.58 | 1545100.0 |
| 2003-08-12 16:30:00 | SPY | ETF | 99.52 | 99.6 | 99.51 | 99.55 | 36000.0 |
| 2003-08-12 17:00:00 | SPY | ETF | 99.54 | 99.54 | 99.44 | 99.5 | 109500.0 |
| 2003-08-12 17:30:00 | SPY | ETF | 99.5 | 99.55 | 99.47 | 99.5 | 82000.0 |
| 2003-08-12 18:00:00 | SPY | ETF | 99.52 | 99.57 | 99.52 | 99.56 | 4400.0 |
| 2003-08-12 18:30:00 | SPY | ETF | 99.52 | 99.52 | 99.5 | 99.5 | 6700.0 |
| 2003-08-12 19:00:00 | SPY | ETF | 99.45 | 99.47 | 99.44 | 99.45 | 6200.0 |
| 2003-08-12 19:30:00 | SPY | ETF | 99.5 | 99.5 | 99.5 | 99.5 | 5200.0 |
| 2003-08-12 08:00:00 | QQQ | ETF | 30.55 | 30.57 | 30.55 | 30.56 | 28000.0 |
| 2003-08-12 08:30:00 | QQQ | ETF | 30.55 | 30.57 | 30.53 | 30.54 | 40600.0 |
| 2003-08-12 09:00:00 | QQQ | ETF | 30.53 | 30.56 | 30.5 | 30.5 | 107600.0 |
| 2003-08-12 09:30:00 | QQQ | ETF | 30.51 | 30.57 | 30.326 | 30.4 | 5580100.0 |
| 2003-08-12 10:00:00 | QQQ | ETF | 30.41 | 30.55 | 30.41 | 30.48 | 3160100.0 |
| 2003-08-12 10:30:00 | QQQ | ETF | 30.49 | 30.55 | 30.4 | 30.44 | 3301700.0 |
| 2003-08-12 11:00:00 | QQQ | ETF | 30.44 | 30.51 | 30.42 | 30.45 | 1188200.0 |
| 2003-08-12 11:30:00 | QQQ | ETF | 30.45 | 30.46 | 30.41 | 30.45 | 1549300.0 |
| 2003-08-12 12:00:00 | QQQ | ETF | 30.45 | 30.5 | 30.44 | 30.47 | 780800.0 |
| 2003-08-12 12:30:00 | QQQ | ETF | 30.473 | 30.54 | 30.47 | 30.51 | 1162300.0 |
| 2003-08-12 13:00:00 | QQQ | ETF | 30.51 | 30.54 | 30.45 | 30.48 | 1014100.0 |
| 2003-08-12 13:30:00 | QQQ | ETF | 30.48 | 30.52 | 30.47 | 30.503 | 1015800.0 |
| 2003-08-12 14:00:00 | QQQ | ETF | 30.513 | 30.65 | 30.46 | 30.56 | 6632500.0 |
| 2003-08-12 14:30:00 | QQQ | ETF | 30.56 | 30.77 | 30.46 | 30.67 | 8745800.0 |
| 2003-08-12 15:00:00 | QQQ | ETF | 30.666 | 30.72 | 30.59 | 30.7 | 4933900.0 |
| 2003-08-12 15:30:00 | QQQ | ETF | 30.7 | 30.89 | 30.68 | 30.863 | 10458000.0 |
| 2003-08-12 16:00:00 | QQQ | ETF | 30.88 | 30.9 | 30.79 | 30.8 | 3556300.0 |
| 2003-08-12 16:30:00 | QQQ | ETF | 30.8 | 30.898 | 30.8 | 30.83 | 729800.0 |
| 2003-08-12 17:00:00 | QQQ | ETF | 30.819 | 30.82 | 30.74 | 30.78 | 216400.0 |
| 2003-08-12 17:30:00 | QQQ | ETF | 30.8 | 30.82 | 30.78 | 30.81 | 33600.0 |
| 2003-08-12 18:00:00 | QQQ | ETF | 30.82 | 30.844 | 30.8 | 30.82 | 59800.0 |
| 2003-08-12 18:30:00 | QQQ | ETF | 30.82 | 30.82 | 30.8 | 30.81 | 10500.0 |
| 2003-08-12 19:00:00 | QQQ | ETF | 30.81 | 30.82 | 30.8 | 30.8 | 2000.0 |
| 2003-08-12 19:30:00 | QQQ | ETF | 30.81 | 30.84 | 30.8 | 30.82 | 11700.0 |
| 2003-08-12 09:30:00 | IWM | ETF | 45.845 | 46.05 | 45.757 | 45.85 | 909400.0 |
| 2003-08-12 10:00:00 | IWM | ETF | 45.875 | 46.0 | 45.875 | 45.995 | 254200.0 |
> showing 50 of 676 rows — these rows as CSV