PREVIEW / etf_30min / 2004-06-16
file: by_date/etf_30min/2004/2004-06-16.parquet size: 34 KB rows: 1,129
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-16 08:00:00 | SPY | ETF | 114.2 | 114.25 | 114.2 | 114.2 | 20900.0 |
| 2004-06-16 08:30:00 | SPY | ETF | 114.2 | 114.2 | 114.0 | 114.01 | 42900.0 |
| 2004-06-16 09:00:00 | SPY | ETF | 114.01 | 114.05 | 113.94 | 113.94 | 66500.0 |
| 2004-06-16 09:30:00 | SPY | ETF | 114.0 | 114.03 | 113.7 | 113.79 | 3698400.0 |
| 2004-06-16 10:00:00 | SPY | ETF | 113.79 | 114.0 | 113.72 | 113.92 | 3481800.0 |
| 2004-06-16 10:30:00 | SPY | ETF | 113.91 | 114.15 | 113.81 | 114.04 | 1623400.0 |
| 2004-06-16 11:00:00 | SPY | ETF | 114.04 | 114.06 | 113.84 | 113.87 | 1287300.0 |
| 2004-06-16 11:30:00 | SPY | ETF | 113.87 | 113.98 | 113.8 | 113.97 | 1367000.0 |
| 2004-06-16 12:00:00 | SPY | ETF | 113.96 | 113.98 | 113.8 | 113.95 | 903100.0 |
| 2004-06-16 12:30:00 | SPY | ETF | 113.95 | 114.07 | 113.86 | 113.99 | 1458700.0 |
| 2004-06-16 13:00:00 | SPY | ETF | 114.0 | 114.01 | 113.77 | 113.93 | 1032800.0 |
| 2004-06-16 13:30:00 | SPY | ETF | 113.92 | 113.99 | 113.9 | 113.93 | 1156200.0 |
| 2004-06-16 14:00:00 | SPY | ETF | 113.93 | 114.07 | 113.87 | 113.94 | 1682300.0 |
| 2004-06-16 14:30:00 | SPY | ETF | 113.95 | 114.11 | 113.91 | 114.0 | 1677700.0 |
| 2004-06-16 15:00:00 | SPY | ETF | 114.0 | 114.19 | 113.96 | 114.17 | 2080700.0 |
| 2004-06-16 15:30:00 | SPY | ETF | 114.18 | 114.2 | 113.965 | 114.02 | 2995200.0 |
| 2004-06-16 16:00:00 | SPY | ETF | 113.99 | 114.1 | 113.87 | 113.94 | 1266500.0 |
| 2004-06-16 16:30:00 | SPY | ETF | 113.94 | 114.0 | 113.9 | 113.98 | 68200.0 |
| 2004-06-16 17:00:00 | SPY | ETF | 113.98 | 114.03 | 113.93 | 113.97 | 74200.0 |
| 2004-06-16 17:30:00 | SPY | ETF | 113.98 | 113.98 | 113.98 | 113.98 | 1000.0 |
| 2004-06-16 18:00:00 | SPY | ETF | 113.95 | 113.96 | 113.91 | 113.91 | 3600.0 |
| 2004-06-16 19:00:00 | SPY | ETF | 113.96 | 113.96 | 113.96 | 113.96 | 100.0 |
| 2004-06-16 08:00:00 | QQQ | ETF | 36.85 | 36.86 | 36.84 | 36.86 | 28100.0 |
| 2004-06-16 08:30:00 | QQQ | ETF | 36.85 | 36.86 | 36.75 | 36.75 | 69400.0 |
| 2004-06-16 09:00:00 | QQQ | ETF | 36.75 | 36.78 | 36.72 | 36.78 | 113300.0 |
| 2004-06-16 09:30:00 | QQQ | ETF | 36.77 | 36.79 | 36.65 | 36.72 | 8598900.0 |
| 2004-06-16 10:00:00 | QQQ | ETF | 36.72 | 36.85 | 36.68 | 36.81 | 6469200.0 |
| 2004-06-16 10:30:00 | QQQ | ETF | 36.8 | 36.87 | 36.717 | 36.82 | 4898200.0 |
| 2004-06-16 11:00:00 | QQQ | ETF | 36.81 | 36.82 | 36.7 | 36.712 | 4883600.0 |
| 2004-06-16 11:30:00 | QQQ | ETF | 36.712 | 36.76 | 36.68 | 36.74 | 3763100.0 |
| 2004-06-16 12:00:00 | QQQ | ETF | 36.741 | 36.75 | 36.65 | 36.73 | 3115100.0 |
| 2004-06-16 12:30:00 | QQQ | ETF | 36.73 | 36.782 | 36.7 | 36.76 | 3232200.0 |
| 2004-06-16 13:00:00 | QQQ | ETF | 36.766 | 36.79 | 36.66 | 36.709 | 3030400.0 |
| 2004-06-16 13:30:00 | QQQ | ETF | 36.7 | 36.74 | 36.695 | 36.72 | 1939800.0 |
| 2004-06-16 14:00:00 | QQQ | ETF | 36.72 | 36.79 | 36.71 | 36.74 | 3558600.0 |
| 2004-06-16 14:30:00 | QQQ | ETF | 36.746 | 36.84 | 36.74 | 36.804 | 4940500.0 |
| 2004-06-16 15:00:00 | QQQ | ETF | 36.802 | 36.87 | 36.78 | 36.87 | 4966700.0 |
| 2004-06-16 15:30:00 | QQQ | ETF | 36.87 | 36.9 | 36.79 | 36.8 | 6092800.0 |
| 2004-06-16 16:00:00 | QQQ | ETF | 36.82 | 36.82 | 36.68 | 36.68 | 2403100.0 |
| 2004-06-16 16:30:00 | QQQ | ETF | 36.68 | 36.7 | 36.65 | 36.68 | 862100.0 |
| 2004-06-16 17:00:00 | QQQ | ETF | 36.69 | 36.69 | 36.63 | 36.64 | 721700.0 |
| 2004-06-16 17:30:00 | QQQ | ETF | 36.66 | 36.67 | 36.62 | 36.63 | 264200.0 |
| 2004-06-16 18:00:00 | QQQ | ETF | 36.61 | 36.65 | 36.61 | 36.65 | 481500.0 |
| 2004-06-16 18:30:00 | QQQ | ETF | 36.65 | 36.66 | 36.65 | 36.66 | 8500.0 |
| 2004-06-16 19:00:00 | QQQ | ETF | 36.66 | 36.66 | 36.66 | 36.66 | 1000.0 |
| 2004-06-16 19:30:00 | QQQ | ETF | 36.65 | 36.66 | 36.65 | 36.65 | 3000.0 |
| 2004-06-16 08:00:00 | IWM | ETF | 56.83 | 56.85 | 56.83 | 56.85 | 3000.0 |
| 2004-06-16 08:30:00 | IWM | ETF | 56.75 | 56.75 | 56.75 | 56.75 | 2000.0 |
| 2004-06-16 09:00:00 | IWM | ETF | 56.66 | 56.685 | 56.6 | 56.685 | 10600.0 |
| 2004-06-16 09:30:00 | IWM | ETF | 56.655 | 56.735 | 56.46 | 56.525 | 1406800.0 |
> showing 50 of 1,129 rows — these rows as CSV