PREVIEW / etf_30min / 2004-07-02
file: by_date/etf_30min/2004/2004-07-02.parquet size: 33 KB rows: 1,133
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-07-02 08:00:00 | SPY | ETF | 112.97 | 113.06 | 112.84 | 112.84 | 67800.0 |
| 2004-07-02 08:30:00 | SPY | ETF | 112.85 | 113.03 | 112.62 | 113.0 | 278500.0 |
| 2004-07-02 09:00:00 | SPY | ETF | 112.96 | 113.16 | 112.95 | 113.1 | 90500.0 |
| 2004-07-02 09:30:00 | SPY | ETF | 113.16 | 113.21 | 112.61 | 112.8 | 5950100.0 |
| 2004-07-02 10:00:00 | SPY | ETF | 112.82 | 113.21 | 112.6 | 113.2 | 3811300.0 |
| 2004-07-02 10:30:00 | SPY | ETF | 113.2 | 113.29 | 113.04 | 113.11 | 4192100.0 |
| 2004-07-02 11:00:00 | SPY | ETF | 113.1 | 113.15 | 112.94 | 113.0 | 1690000.0 |
| 2004-07-02 11:30:00 | SPY | ETF | 113.0 | 113.08 | 112.86 | 112.97 | 2535800.0 |
| 2004-07-02 12:00:00 | SPY | ETF | 112.98 | 113.17 | 112.72 | 112.81 | 1327200.0 |
| 2004-07-02 12:30:00 | SPY | ETF | 112.81 | 112.95 | 112.75 | 112.9 | 1493000.0 |
| 2004-07-02 13:00:00 | SPY | ETF | 112.9 | 113.04 | 112.83 | 112.95 | 894700.0 |
| 2004-07-02 13:30:00 | SPY | ETF | 112.95 | 113.04 | 112.91 | 112.98 | 837000.0 |
| 2004-07-02 14:00:00 | SPY | ETF | 112.98 | 112.98 | 112.68 | 112.87 | 2333200.0 |
| 2004-07-02 14:30:00 | SPY | ETF | 112.87 | 112.88 | 112.7 | 112.8 | 906200.0 |
| 2004-07-02 15:00:00 | SPY | ETF | 112.79 | 112.95 | 112.77 | 112.86 | 1589800.0 |
| 2004-07-02 15:30:00 | SPY | ETF | 112.85 | 113.01 | 112.73 | 112.8 | 2614700.0 |
| 2004-07-02 16:00:00 | SPY | ETF | 112.79 | 113.15 | 112.71 | 112.8 | 1331100.0 |
| 2004-07-02 16:30:00 | SPY | ETF | 112.8 | 112.8 | 112.72 | 112.72 | 13200.0 |
| 2004-07-02 17:00:00 | SPY | ETF | 112.72 | 112.77 | 112.72 | 112.72 | 13100.0 |
| 2004-07-02 17:30:00 | SPY | ETF | 112.77 | 112.77 | 112.77 | 112.77 | 100.0 |
| 2004-07-02 18:00:00 | SPY | ETF | 112.78 | 112.81 | 112.78 | 112.78 | 2500.0 |
| 2004-07-02 18:30:00 | SPY | ETF | 112.8 | 112.81 | 112.8 | 112.81 | 300.0 |
| 2004-07-02 19:30:00 | SPY | ETF | 112.78 | 112.78 | 112.78 | 112.78 | 200.0 |
| 2004-07-02 08:00:00 | QQQ | ETF | 37.05 | 37.12 | 37.04 | 37.07 | 123800.0 |
| 2004-07-02 08:30:00 | QQQ | ETF | 37.07 | 37.07 | 36.89 | 36.99 | 577300.0 |
| 2004-07-02 09:00:00 | QQQ | ETF | 36.97 | 37.03 | 36.94 | 37.03 | 182700.0 |
| 2004-07-02 09:30:00 | QQQ | ETF | 37.04 | 37.05 | 36.63 | 36.73 | 20036500.0 |
| 2004-07-02 10:00:00 | QQQ | ETF | 36.712 | 36.88 | 36.64 | 36.854 | 8845000.0 |
| 2004-07-02 10:30:00 | QQQ | ETF | 36.86 | 36.92 | 36.782 | 36.83 | 7162900.0 |
| 2004-07-02 11:00:00 | QQQ | ETF | 36.821 | 36.864 | 36.776 | 36.827 | 3252100.0 |
| 2004-07-02 11:30:00 | QQQ | ETF | 36.82 | 36.9 | 36.79 | 36.863 | 3574700.0 |
| 2004-07-02 12:00:00 | QQQ | ETF | 36.863 | 36.944 | 36.76 | 36.82 | 4678500.0 |
| 2004-07-02 12:30:00 | QQQ | ETF | 36.805 | 36.82 | 36.73 | 36.81 | 3204900.0 |
| 2004-07-02 13:00:00 | QQQ | ETF | 36.812 | 36.86 | 36.79 | 36.851 | 1558800.0 |
| 2004-07-02 13:30:00 | QQQ | ETF | 36.85 | 36.91 | 36.83 | 36.863 | 1964200.0 |
| 2004-07-02 14:00:00 | QQQ | ETF | 36.862 | 36.87 | 36.77 | 36.828 | 1881500.0 |
| 2004-07-02 14:30:00 | QQQ | ETF | 36.823 | 36.86 | 36.76 | 36.82 | 2218000.0 |
| 2004-07-02 15:00:00 | QQQ | ETF | 36.83 | 36.87 | 36.8 | 36.827 | 2953100.0 |
| 2004-07-02 15:30:00 | QQQ | ETF | 36.826 | 36.88 | 36.77 | 36.78 | 7620600.0 |
| 2004-07-02 16:00:00 | QQQ | ETF | 36.775 | 36.9 | 36.77 | 36.819 | 1585800.0 |
| 2004-07-02 16:30:00 | QQQ | ETF | 36.85 | 36.85 | 36.81 | 36.82 | 28200.0 |
| 2004-07-02 17:00:00 | QQQ | ETF | 36.81 | 36.83 | 36.81 | 36.828 | 14100.0 |
| 2004-07-02 17:30:00 | QQQ | ETF | 36.828 | 36.83 | 36.81 | 36.81 | 19700.0 |
| 2004-07-02 18:00:00 | QQQ | ETF | 36.82 | 36.84 | 36.81 | 36.839 | 11200.0 |
| 2004-07-02 19:00:00 | QQQ | ETF | 36.83 | 36.85 | 36.83 | 36.85 | 14100.0 |
| 2004-07-02 19:30:00 | QQQ | ETF | 36.82 | 36.84 | 36.82 | 36.83 | 2700.0 |
| 2004-07-02 08:30:00 | IWM | ETF | 57.93 | 58.035 | 57.89 | 57.9 | 111200.0 |
| 2004-07-02 09:00:00 | IWM | ETF | 57.935 | 58.005 | 57.935 | 58.005 | 105200.0 |
| 2004-07-02 09:30:00 | IWM | ETF | 58.045 | 58.225 | 57.65 | 57.705 | 1636600.0 |
| 2004-07-02 10:00:00 | IWM | ETF | 57.705 | 57.9 | 57.65 | 57.895 | 1046800.0 |
> showing 50 of 1,133 rows — these rows as CSV