PREVIEW / etf_30min / 2004-03-29
file: by_date/etf_30min/2004/2004-03-29.parquet size: 35 KB rows: 1,182
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-03-29 08:00:00 | SPY | ETF | 111.64 | 111.73 | 111.63 | 111.67 | 131600.0 |
| 2004-03-29 08:30:00 | SPY | ETF | 111.69 | 111.7 | 111.61 | 111.62 | 27900.0 |
| 2004-03-29 09:00:00 | SPY | ETF | 111.61 | 111.71 | 111.61 | 111.63 | 33100.0 |
| 2004-03-29 09:30:00 | SPY | ETF | 111.63 | 112.16 | 111.58 | 112.05 | 7359100.0 |
| 2004-03-29 10:00:00 | SPY | ETF | 112.04 | 112.52 | 112.04 | 112.35 | 4733800.0 |
| 2004-03-29 10:30:00 | SPY | ETF | 112.36 | 112.58 | 112.34 | 112.53 | 2661100.0 |
| 2004-03-29 11:00:00 | SPY | ETF | 112.52 | 112.61 | 112.42 | 112.53 | 3564200.0 |
| 2004-03-29 11:30:00 | SPY | ETF | 112.53 | 112.59 | 112.46 | 112.58 | 1169500.0 |
| 2004-03-29 12:00:00 | SPY | ETF | 112.59 | 112.64 | 112.5 | 112.58 | 1286900.0 |
| 2004-03-29 12:30:00 | SPY | ETF | 112.58 | 112.62 | 112.43 | 112.5 | 1123900.0 |
| 2004-03-29 13:00:00 | SPY | ETF | 112.51 | 112.51 | 112.35 | 112.45 | 1733400.0 |
| 2004-03-29 13:30:00 | SPY | ETF | 112.49 | 112.585 | 112.44 | 112.57 | 1560100.0 |
| 2004-03-29 14:00:00 | SPY | ETF | 112.59 | 112.74 | 112.48 | 112.53 | 1937100.0 |
| 2004-03-29 14:30:00 | SPY | ETF | 112.52 | 112.61 | 112.36 | 112.59 | 1727300.0 |
| 2004-03-29 15:00:00 | SPY | ETF | 112.6 | 112.74 | 112.45 | 112.54 | 1901900.0 |
| 2004-03-29 15:30:00 | SPY | ETF | 112.52 | 112.52 | 112.12 | 112.48 | 7823500.0 |
| 2004-03-29 16:00:00 | SPY | ETF | 112.47 | 112.65 | 112.45 | 112.54 | 2095800.0 |
| 2004-03-29 16:30:00 | SPY | ETF | 112.56 | 112.56 | 112.48 | 112.5 | 422900.0 |
| 2004-03-29 17:00:00 | SPY | ETF | 112.51 | 112.52 | 112.47 | 112.5 | 484900.0 |
| 2004-03-29 17:30:00 | SPY | ETF | 112.5 | 112.54 | 112.5 | 112.5 | 2200.0 |
| 2004-03-29 18:00:00 | SPY | ETF | 112.48 | 112.5 | 112.46 | 112.5 | 900.0 |
| 2004-03-29 18:30:00 | SPY | ETF | 112.51 | 112.51 | 112.51 | 112.51 | 100.0 |
| 2004-03-29 19:00:00 | SPY | ETF | 112.48 | 112.48 | 112.48 | 112.48 | 1400.0 |
| 2004-03-29 08:00:00 | QQQ | ETF | 35.53 | 35.57 | 35.51 | 35.52 | 64200.0 |
| 2004-03-29 08:30:00 | QQQ | ETF | 35.52 | 35.53 | 35.5 | 35.51 | 105900.0 |
| 2004-03-29 09:00:00 | QQQ | ETF | 35.51 | 35.55 | 35.5 | 35.52 | 212100.0 |
| 2004-03-29 09:30:00 | QQQ | ETF | 35.51 | 35.8 | 35.5 | 35.75 | 15400200.0 |
| 2004-03-29 10:00:00 | QQQ | ETF | 35.751 | 35.92 | 35.74 | 35.81 | 12967700.0 |
| 2004-03-29 10:30:00 | QQQ | ETF | 35.82 | 35.91 | 35.81 | 35.87 | 7014200.0 |
| 2004-03-29 11:00:00 | QQQ | ETF | 35.87 | 35.95 | 35.85 | 35.92 | 8528800.0 |
| 2004-03-29 11:30:00 | QQQ | ETF | 35.914 | 35.93 | 35.88 | 35.92 | 3772300.0 |
| 2004-03-29 12:00:00 | QQQ | ETF | 35.92 | 35.94 | 35.89 | 35.929 | 2634600.0 |
| 2004-03-29 12:30:00 | QQQ | ETF | 35.93 | 35.96 | 35.85 | 35.87 | 4615700.0 |
| 2004-03-29 13:00:00 | QQQ | ETF | 35.86 | 35.88 | 35.79 | 35.857 | 4283000.0 |
| 2004-03-29 13:30:00 | QQQ | ETF | 35.856 | 35.88 | 35.83 | 35.877 | 2139300.0 |
| 2004-03-29 14:00:00 | QQQ | ETF | 35.878 | 35.92 | 35.8 | 35.83 | 3826400.0 |
| 2004-03-29 14:30:00 | QQQ | ETF | 35.83 | 35.85 | 35.72 | 35.83 | 7300100.0 |
| 2004-03-29 15:00:00 | QQQ | ETF | 35.83 | 35.91 | 35.75 | 35.79 | 7802700.0 |
| 2004-03-29 15:30:00 | QQQ | ETF | 35.783 | 35.85 | 35.61 | 35.85 | 13807800.0 |
| 2004-03-29 16:00:00 | QQQ | ETF | 35.85 | 35.89 | 35.78 | 35.82 | 4591400.0 |
| 2004-03-29 16:30:00 | QQQ | ETF | 35.81 | 35.85 | 35.801 | 35.82 | 413200.0 |
| 2004-03-29 17:00:00 | QQQ | ETF | 35.82 | 35.831 | 35.81 | 35.82 | 41400.0 |
| 2004-03-29 17:30:00 | QQQ | ETF | 35.81 | 35.82 | 35.8 | 35.8 | 18900.0 |
| 2004-03-29 18:00:00 | QQQ | ETF | 35.81 | 35.831 | 35.81 | 35.83 | 35200.0 |
| 2004-03-29 18:30:00 | QQQ | ETF | 35.83 | 35.83 | 35.81 | 35.81 | 4800.0 |
| 2004-03-29 19:00:00 | QQQ | ETF | 35.81 | 35.81 | 35.8 | 35.8 | 9700.0 |
| 2004-03-29 19:30:00 | QQQ | ETF | 35.8 | 35.8 | 35.78 | 35.78 | 4800.0 |
| 2004-03-29 08:00:00 | IWM | ETF | 57.6 | 57.6 | 57.5 | 57.5 | 5000.0 |
| 2004-03-29 08:30:00 | IWM | ETF | 57.5 | 57.5 | 57.485 | 57.485 | 12200.0 |
| 2004-03-29 09:00:00 | IWM | ETF | 57.48 | 57.48 | 57.48 | 57.48 | 2000.0 |
> showing 50 of 1,182 rows — these rows as CSV