PREVIEW / etf_30min / 2004-02-04
file: by_date/etf_30min/2004/2004-02-04.parquet size: 36 KB rows: 1,198
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-02-04 08:00:00 | SPY | ETF | 113.21 | 113.26 | 113.13 | 113.15 | 19600.0 |
| 2004-02-04 08:30:00 | SPY | ETF | 113.15 | 113.19 | 113.15 | 113.15 | 15200.0 |
| 2004-02-04 09:00:00 | SPY | ETF | 113.22 | 113.27 | 113.22 | 113.22 | 13500.0 |
| 2004-02-04 09:30:00 | SPY | ETF | 113.19 | 113.4 | 113.14 | 113.21 | 3606000.0 |
| 2004-02-04 10:00:00 | SPY | ETF | 113.22 | 113.65 | 112.95 | 113.55 | 5794500.0 |
| 2004-02-04 10:30:00 | SPY | ETF | 113.57 | 113.73 | 113.46 | 113.6 | 3630300.0 |
| 2004-02-04 11:00:00 | SPY | ETF | 113.6 | 113.63 | 113.37 | 113.42 | 1301300.0 |
| 2004-02-04 11:30:00 | SPY | ETF | 113.44 | 113.69 | 113.36 | 113.47 | 1701600.0 |
| 2004-02-04 12:00:00 | SPY | ETF | 113.47 | 113.66 | 113.41 | 113.59 | 726600.0 |
| 2004-02-04 12:30:00 | SPY | ETF | 113.6 | 113.67 | 113.45 | 113.501 | 1275400.0 |
| 2004-02-04 13:00:00 | SPY | ETF | 113.51 | 113.67 | 113.47 | 113.52 | 1403300.0 |
| 2004-02-04 13:30:00 | SPY | ETF | 113.51 | 113.65 | 113.22 | 113.25 | 1807700.0 |
| 2004-02-04 14:00:00 | SPY | ETF | 113.24 | 113.31 | 112.79 | 113.02 | 5152600.0 |
| 2004-02-04 14:30:00 | SPY | ETF | 112.95 | 113.144 | 112.92 | 112.96 | 2336700.0 |
| 2004-02-04 15:00:00 | SPY | ETF | 112.95 | 113.37 | 112.89 | 113.21 | 3245200.0 |
| 2004-02-04 15:30:00 | SPY | ETF | 113.2 | 113.25 | 112.99 | 113.03 | 2657000.0 |
| 2004-02-04 16:00:00 | SPY | ETF | 113.05 | 113.09 | 112.8 | 112.88 | 1755700.0 |
| 2004-02-04 16:30:00 | SPY | ETF | 113.01 | 113.01 | 112.79 | 112.83 | 537700.0 |
| 2004-02-04 17:00:00 | SPY | ETF | 112.83 | 112.87 | 112.8 | 112.87 | 3000.0 |
| 2004-02-04 17:30:00 | SPY | ETF | 112.84 | 112.85 | 112.81 | 112.85 | 6500.0 |
| 2004-02-04 18:00:00 | SPY | ETF | 112.82 | 112.82 | 112.74 | 112.8 | 258500.0 |
| 2004-02-04 18:30:00 | SPY | ETF | 112.81 | 112.86 | 112.79 | 112.83 | 28700.0 |
| 2004-02-04 19:00:00 | SPY | ETF | 112.81 | 112.81 | 112.81 | 112.81 | 900.0 |
| 2004-02-04 19:30:00 | SPY | ETF | 112.82 | 112.83 | 112.81 | 112.81 | 3700.0 |
| 2004-02-04 08:00:00 | QQQ | ETF | 36.67 | 36.69 | 36.6 | 36.63 | 196000.0 |
| 2004-02-04 08:30:00 | QQQ | ETF | 36.64 | 36.65 | 36.6 | 36.63 | 201600.0 |
| 2004-02-04 09:00:00 | QQQ | ETF | 36.64 | 36.67 | 36.62 | 36.62 | 154300.0 |
| 2004-02-04 09:30:00 | QQQ | ETF | 36.62 | 36.74 | 36.59 | 36.69 | 11100300.0 |
| 2004-02-04 10:00:00 | QQQ | ETF | 36.7 | 36.805 | 36.51 | 36.74 | 12201300.0 |
| 2004-02-04 10:30:00 | QQQ | ETF | 36.75 | 36.864 | 36.68 | 36.723 | 7433700.0 |
| 2004-02-04 11:00:00 | QQQ | ETF | 36.73 | 36.75 | 36.62 | 36.64 | 4654000.0 |
| 2004-02-04 11:30:00 | QQQ | ETF | 36.64 | 36.775 | 36.61 | 36.69 | 5068100.0 |
| 2004-02-04 12:00:00 | QQQ | ETF | 36.69 | 36.76 | 36.65 | 36.75 | 4854200.0 |
| 2004-02-04 12:30:00 | QQQ | ETF | 36.752 | 36.795 | 36.65 | 36.69 | 3451300.0 |
| 2004-02-04 13:00:00 | QQQ | ETF | 36.69 | 36.791 | 36.68 | 36.72 | 2467100.0 |
| 2004-02-04 13:30:00 | QQQ | ETF | 36.71 | 36.77 | 36.58 | 36.59 | 5416300.0 |
| 2004-02-04 14:00:00 | QQQ | ETF | 36.59 | 36.63 | 36.329 | 36.43 | 17810700.0 |
| 2004-02-04 14:30:00 | QQQ | ETF | 36.44 | 36.52 | 36.39 | 36.4 | 7971600.0 |
| 2004-02-04 15:00:00 | QQQ | ETF | 36.43 | 36.56 | 36.35 | 36.45 | 7964000.0 |
| 2004-02-04 15:30:00 | QQQ | ETF | 36.47 | 36.47 | 36.33 | 36.404 | 10385800.0 |
| 2004-02-04 16:00:00 | QQQ | ETF | 36.4 | 36.43 | 36.32 | 36.37 | 4317800.0 |
| 2004-02-04 16:30:00 | QQQ | ETF | 36.37 | 36.38 | 36.34 | 36.35 | 277300.0 |
| 2004-02-04 17:00:00 | QQQ | ETF | 36.35 | 36.37 | 36.34 | 36.37 | 327500.0 |
| 2004-02-04 17:30:00 | QQQ | ETF | 36.34 | 36.39 | 36.33 | 36.36 | 401700.0 |
| 2004-02-04 18:00:00 | QQQ | ETF | 36.38 | 36.39 | 36.36 | 36.38 | 56000.0 |
| 2004-02-04 18:30:00 | QQQ | ETF | 36.38 | 36.39 | 36.35 | 36.37 | 5200.0 |
| 2004-02-04 19:00:00 | QQQ | ETF | 36.36 | 36.38 | 36.3 | 36.38 | 33000.0 |
| 2004-02-04 19:30:00 | QQQ | ETF | 36.36 | 36.39 | 36.36 | 36.38 | 3600.0 |
| 2004-02-04 08:30:00 | IWM | ETF | 57.215 | 57.235 | 57.215 | 57.235 | 5000.0 |
| 2004-02-04 09:00:00 | IWM | ETF | 57.26 | 57.325 | 57.255 | 57.325 | 34000.0 |
> showing 50 of 1,198 rows — these rows as CSV