PREVIEW / etf_30min / 2004-06-22
file: by_date/etf_30min/2004/2004-06-22.parquet size: 35 KB rows: 1,168
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 |
|---|---|---|---|---|---|---|---|
| 2004-06-22 08:00:00 | SPY | ETF | 113.34 | 113.36 | 113.23 | 113.23 | 6100.0 |
| 2004-06-22 08:30:00 | SPY | ETF | 113.18 | 113.18 | 113.11 | 113.13 | 15900.0 |
| 2004-06-22 09:00:00 | SPY | ETF | 113.12 | 113.19 | 113.11 | 113.14 | 34800.0 |
| 2004-06-22 09:30:00 | SPY | ETF | 113.13 | 113.36 | 113.01 | 113.34 | 4867700.0 |
| 2004-06-22 10:00:00 | SPY | ETF | 113.34 | 113.38 | 113.14 | 113.19 | 1807600.0 |
| 2004-06-22 10:30:00 | SPY | ETF | 113.18 | 113.18 | 112.88 | 112.9 | 3942300.0 |
| 2004-06-22 11:00:00 | SPY | ETF | 112.9 | 112.9 | 112.67 | 112.82 | 2644400.0 |
| 2004-06-22 11:30:00 | SPY | ETF | 112.81 | 112.94 | 112.79 | 112.8685 | 2210400.0 |
| 2004-06-22 12:00:00 | SPY | ETF | 112.88 | 113.09 | 112.86 | 112.95 | 1912400.0 |
| 2004-06-22 12:30:00 | SPY | ETF | 112.97 | 113.26 | 112.94 | 113.149 | 1580600.0 |
| 2004-06-22 13:00:00 | SPY | ETF | 113.13 | 113.15 | 112.96 | 112.98 | 1307600.0 |
| 2004-06-22 13:30:00 | SPY | ETF | 112.98 | 113.28 | 112.96 | 113.15 | 1392500.0 |
| 2004-06-22 14:00:00 | SPY | ETF | 113.14 | 113.75 | 113.11 | 113.69 | 4039300.0 |
| 2004-06-22 14:30:00 | SPY | ETF | 113.7 | 113.82 | 113.54 | 113.67 | 2164900.0 |
| 2004-06-22 15:00:00 | SPY | ETF | 113.66 | 113.78 | 113.59 | 113.68 | 2018500.0 |
| 2004-06-22 15:30:00 | SPY | ETF | 113.68 | 113.8 | 113.5 | 113.78 | 3161300.0 |
| 2004-06-22 16:00:00 | SPY | ETF | 113.79 | 113.88 | 113.75 | 113.79 | 1329400.0 |
| 2004-06-22 16:30:00 | SPY | ETF | 113.79 | 113.83 | 113.79 | 113.8 | 30500.0 |
| 2004-06-22 17:00:00 | SPY | ETF | 113.78 | 113.8 | 113.77 | 113.77 | 201100.0 |
| 2004-06-22 18:00:00 | SPY | ETF | 113.81 | 113.82 | 113.8 | 113.82 | 3300.0 |
| 2004-06-22 18:30:00 | SPY | ETF | 113.8 | 113.8 | 113.8 | 113.8 | 4900.0 |
| 2004-06-22 19:30:00 | SPY | ETF | 113.77 | 113.8 | 113.77 | 113.8 | 500.0 |
| 2004-06-22 08:00:00 | QQQ | ETF | 36.25 | 36.27 | 36.23 | 36.23 | 144900.0 |
| 2004-06-22 08:30:00 | QQQ | ETF | 36.21 | 36.22 | 36.16 | 36.19 | 212000.0 |
| 2004-06-22 09:00:00 | QQQ | ETF | 36.19 | 36.21 | 36.14 | 36.14 | 112600.0 |
| 2004-06-22 09:30:00 | QQQ | ETF | 36.16 | 36.29 | 36.12 | 36.27 | 9296600.0 |
| 2004-06-22 10:00:00 | QQQ | ETF | 36.27 | 36.33 | 36.2 | 36.212 | 6156700.0 |
| 2004-06-22 10:30:00 | QQQ | ETF | 36.22 | 36.22 | 36.1 | 36.12 | 9529900.0 |
| 2004-06-22 11:00:00 | QQQ | ETF | 36.12 | 36.15 | 36.015 | 36.142 | 10286800.0 |
| 2004-06-22 11:30:00 | QQQ | ETF | 36.15 | 36.19 | 36.11 | 36.17 | 4493700.0 |
| 2004-06-22 12:00:00 | QQQ | ETF | 36.167 | 36.28 | 36.16 | 36.22 | 7717600.0 |
| 2004-06-22 12:30:00 | QQQ | ETF | 36.22 | 36.38 | 36.21 | 36.28 | 7798300.0 |
| 2004-06-22 13:00:00 | QQQ | ETF | 36.28 | 36.29 | 36.18 | 36.2077 | 2690400.0 |
| 2004-06-22 13:30:00 | QQQ | ETF | 36.207 | 36.35 | 36.187 | 36.3 | 4246900.0 |
| 2004-06-22 14:00:00 | QQQ | ETF | 36.293 | 36.551 | 36.28 | 36.52 | 9280300.0 |
| 2004-06-22 14:30:00 | QQQ | ETF | 36.528 | 36.65 | 36.45 | 36.59 | 9356100.0 |
| 2004-06-22 15:00:00 | QQQ | ETF | 36.59 | 36.64 | 36.54 | 36.59 | 6336000.0 |
| 2004-06-22 15:30:00 | QQQ | ETF | 36.592 | 36.68 | 36.54 | 36.67 | 8361800.0 |
| 2004-06-22 16:00:00 | QQQ | ETF | 36.676 | 36.7 | 36.64 | 36.68 | 2230400.0 |
| 2004-06-22 16:30:00 | QQQ | ETF | 36.661 | 36.68 | 36.65 | 36.67 | 172700.0 |
| 2004-06-22 17:00:00 | QQQ | ETF | 36.68 | 36.69 | 36.66 | 36.68 | 231600.0 |
| 2004-06-22 17:30:00 | QQQ | ETF | 36.68 | 36.69 | 36.67 | 36.68 | 36900.0 |
| 2004-06-22 18:00:00 | QQQ | ETF | 36.68 | 36.69 | 36.65 | 36.65 | 46300.0 |
| 2004-06-22 18:30:00 | QQQ | ETF | 36.67 | 36.67 | 36.65 | 36.65 | 1300.0 |
| 2004-06-22 19:00:00 | QQQ | ETF | 36.67 | 36.69 | 36.67 | 36.69 | 6400.0 |
| 2004-06-22 19:30:00 | QQQ | ETF | 36.67 | 36.67 | 36.67 | 36.67 | 3600.0 |
| 2004-06-22 08:30:00 | IWM | ETF | 56.755 | 56.755 | 56.755 | 56.755 | 200.0 |
| 2004-06-22 09:30:00 | IWM | ETF | 56.725 | 56.77 | 56.5 | 56.75 | 889600.0 |
| 2004-06-22 10:00:00 | IWM | ETF | 56.77 | 56.825 | 56.665 | 56.7 | 350000.0 |
| 2004-06-22 10:30:00 | IWM | ETF | 56.715 | 56.715 | 56.49 | 56.495 | 1038800.0 |
> showing 50 of 1,168 rows — these rows as CSV