PREVIEW / etf_30min / 2003-06-24
file: by_date/etf_30min/2003/2003-06-24.parquet size: 23 KB rows: 688
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-06-24 08:00:00 | SPY | ETF | 98.38 | 98.5 | 98.38 | 98.49 | 13900.0 |
| 2003-06-24 08:30:00 | SPY | ETF | 98.52 | 98.63 | 98.49 | 98.49 | 14500.0 |
| 2003-06-24 09:00:00 | SPY | ETF | 98.5 | 98.51 | 98.14 | 98.14 | 45800.0 |
| 2003-06-24 09:30:00 | SPY | ETF | 98.15 | 98.87 | 98.02 | 98.81 | 8423600.0 |
| 2003-06-24 10:00:00 | SPY | ETF | 98.79 | 99.09 | 98.329 | 98.38 | 5589100.0 |
| 2003-06-24 10:30:00 | SPY | ETF | 98.4 | 98.58 | 98.1 | 98.39 | 2838400.0 |
| 2003-06-24 11:00:00 | SPY | ETF | 98.4 | 98.53 | 98.14 | 98.44 | 1388200.0 |
| 2003-06-24 11:30:00 | SPY | ETF | 98.43 | 98.46 | 98.23 | 98.44 | 951700.0 |
| 2003-06-24 12:00:00 | SPY | ETF | 98.43 | 98.64 | 98.31 | 98.6 | 1195500.0 |
| 2003-06-24 12:30:00 | SPY | ETF | 98.607 | 98.75 | 98.57 | 98.72 | 1314000.0 |
| 2003-06-24 13:00:00 | SPY | ETF | 98.72 | 98.79 | 98.55 | 98.66 | 1479800.0 |
| 2003-06-24 13:30:00 | SPY | ETF | 98.72 | 98.94 | 98.68 | 98.93 | 1408400.0 |
| 2003-06-24 14:00:00 | SPY | ETF | 98.94 | 99.06 | 98.81 | 98.83 | 2306200.0 |
| 2003-06-24 14:30:00 | SPY | ETF | 98.83 | 98.93 | 98.599 | 98.7 | 1351100.0 |
| 2003-06-24 15:00:00 | SPY | ETF | 98.7 | 98.98 | 98.62 | 98.98 | 865800.0 |
| 2003-06-24 15:30:00 | SPY | ETF | 98.98 | 99.01 | 98.56 | 98.65 | 3025100.0 |
| 2003-06-24 16:00:00 | SPY | ETF | 98.65 | 98.68 | 98.48 | 98.48 | 865900.0 |
| 2003-06-24 16:30:00 | SPY | ETF | 98.48 | 98.62 | 98.48 | 98.6 | 226400.0 |
| 2003-06-24 17:00:00 | SPY | ETF | 98.63 | 98.63 | 98.6 | 98.6 | 2400.0 |
| 2003-06-24 17:30:00 | SPY | ETF | 98.6 | 98.6 | 98.6 | 98.6 | 2900.0 |
| 2003-06-24 18:00:00 | SPY | ETF | 98.63 | 98.63 | 98.6 | 98.6 | 1600.0 |
| 2003-06-24 19:00:00 | SPY | ETF | 98.59 | 98.62 | 98.58 | 98.58 | 9200.0 |
| 2003-06-24 19:30:00 | SPY | ETF | 98.63 | 98.63 | 98.58 | 98.58 | 7800.0 |
| 2003-06-24 08:00:00 | QQQ | ETF | 29.8 | 29.87 | 29.8 | 29.86 | 33800.0 |
| 2003-06-24 08:30:00 | QQQ | ETF | 29.87 | 29.91 | 29.83 | 29.85 | 67600.0 |
| 2003-06-24 09:00:00 | QQQ | ETF | 29.86 | 29.86 | 29.68 | 29.7 | 129300.0 |
| 2003-06-24 09:30:00 | QQQ | ETF | 29.73 | 30.04 | 29.69 | 29.951 | 10595000.0 |
| 2003-06-24 10:00:00 | QQQ | ETF | 29.95 | 30.1 | 29.66 | 29.73 | 10896300.0 |
| 2003-06-24 10:30:00 | QQQ | ETF | 29.725 | 29.82 | 29.53 | 29.64 | 7884100.0 |
| 2003-06-24 11:00:00 | QQQ | ETF | 29.65 | 29.7 | 29.56 | 29.64 | 4317200.0 |
| 2003-06-24 11:30:00 | QQQ | ETF | 29.63 | 29.66 | 29.54 | 29.62 | 2912200.0 |
| 2003-06-24 12:00:00 | QQQ | ETF | 29.616 | 29.78 | 29.56 | 29.75 | 3776100.0 |
| 2003-06-24 12:30:00 | QQQ | ETF | 29.74 | 29.84 | 29.71 | 29.811 | 2699100.0 |
| 2003-06-24 13:00:00 | QQQ | ETF | 29.81 | 29.9 | 29.74 | 29.85 | 3626700.0 |
| 2003-06-24 13:30:00 | QQQ | ETF | 29.84 | 29.978 | 29.84 | 29.95 | 4534600.0 |
| 2003-06-24 14:00:00 | QQQ | ETF | 29.96 | 30.001 | 29.8 | 29.802 | 3664400.0 |
| 2003-06-24 14:30:00 | QQQ | ETF | 29.83 | 29.85 | 29.62 | 29.69 | 6116500.0 |
| 2003-06-24 15:00:00 | QQQ | ETF | 29.682 | 29.86 | 29.65 | 29.83 | 3952900.0 |
| 2003-06-24 15:30:00 | QQQ | ETF | 29.83 | 29.86 | 29.62 | 29.71 | 6473700.0 |
| 2003-06-24 16:00:00 | QQQ | ETF | 29.7 | 29.73 | 29.61 | 29.65 | 1976100.0 |
| 2003-06-24 16:30:00 | QQQ | ETF | 29.64 | 29.7 | 29.62 | 29.69 | 300300.0 |
| 2003-06-24 17:00:00 | QQQ | ETF | 29.69 | 29.7 | 29.673 | 29.68 | 30200.0 |
| 2003-06-24 17:30:00 | QQQ | ETF | 29.69 | 29.71 | 29.68 | 29.71 | 19800.0 |
| 2003-06-24 18:00:00 | QQQ | ETF | 29.72 | 29.74 | 29.7 | 29.71 | 11000.0 |
| 2003-06-24 18:30:00 | QQQ | ETF | 29.7 | 29.71 | 29.69 | 29.71 | 4700.0 |
| 2003-06-24 19:00:00 | QQQ | ETF | 29.71 | 29.71 | 29.7 | 29.7 | 3800.0 |
| 2003-06-24 19:30:00 | QQQ | ETF | 29.71 | 29.73 | 29.71 | 29.72 | 13200.0 |
| 2003-06-24 09:30:00 | IWM | ETF | 43.71 | 44.075 | 43.71 | 44.025 | 420800.0 |
| 2003-06-24 10:00:00 | IWM | ETF | 44.025 | 44.1155 | 43.7 | 43.75 | 641200.0 |
| 2003-06-24 10:30:00 | IWM | ETF | 43.715 | 43.78 | 43.49 | 43.57 | 353600.0 |
> showing 50 of 688 rows — these rows as CSV