PREVIEW / etf_30min / 2004-07-29
file: by_date/etf_30min/2004/2004-07-29.parquet size: 35 KB rows: 1,161
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-29 08:00:00 | SPY | ETF | 110.35 | 110.57 | 110.35 | 110.51 | 99300.0 |
| 2004-07-29 08:30:00 | SPY | ETF | 110.5 | 110.58 | 110.4 | 110.42 | 52600.0 |
| 2004-07-29 09:00:00 | SPY | ETF | 110.43 | 110.66 | 110.4 | 110.55 | 464100.0 |
| 2004-07-29 09:30:00 | SPY | ETF | 110.54 | 110.6 | 110.21 | 110.54 | 4342800.0 |
| 2004-07-29 10:00:00 | SPY | ETF | 110.55 | 110.58 | 110.15 | 110.29 | 4396700.0 |
| 2004-07-29 10:30:00 | SPY | ETF | 110.31 | 110.51 | 110.18 | 110.44 | 2725400.0 |
| 2004-07-29 11:00:00 | SPY | ETF | 110.44 | 110.49 | 110.24 | 110.28 | 1742300.0 |
| 2004-07-29 11:30:00 | SPY | ETF | 110.28 | 110.46 | 110.25 | 110.44 | 1652200.0 |
| 2004-07-29 12:00:00 | SPY | ETF | 110.44 | 110.72 | 110.36 | 110.69 | 2891700.0 |
| 2004-07-29 12:30:00 | SPY | ETF | 110.68 | 110.85 | 110.61 | 110.68 | 3065100.0 |
| 2004-07-29 13:00:00 | SPY | ETF | 110.68 | 110.8 | 110.55 | 110.58 | 1860500.0 |
| 2004-07-29 13:30:00 | SPY | ETF | 110.58 | 110.61 | 110.41 | 110.45 | 2252000.0 |
| 2004-07-29 14:00:00 | SPY | ETF | 110.45 | 110.49 | 110.05 | 110.15 | 3781100.0 |
| 2004-07-29 14:30:00 | SPY | ETF | 110.15 | 110.49 | 110.0 | 110.49 | 4263400.0 |
| 2004-07-29 15:00:00 | SPY | ETF | 110.48 | 110.86 | 110.43 | 110.46 | 6815800.0 |
| 2004-07-29 15:30:00 | SPY | ETF | 110.48 | 110.6 | 110.33 | 110.55 | 5019500.0 |
| 2004-07-29 16:00:00 | SPY | ETF | 110.58 | 110.65 | 110.45 | 110.5 | 2030800.0 |
| 2004-07-29 16:30:00 | SPY | ETF | 110.56 | 110.67 | 110.54 | 110.67 | 65600.0 |
| 2004-07-29 17:00:00 | SPY | ETF | 110.65 | 110.65 | 110.59 | 110.59 | 45300.0 |
| 2004-07-29 17:30:00 | SPY | ETF | 110.6 | 110.63 | 110.56 | 110.6 | 102600.0 |
| 2004-07-29 18:00:00 | SPY | ETF | 110.58 | 110.6 | 110.58 | 110.59 | 800.0 |
| 2004-07-29 18:30:00 | SPY | ETF | 110.59 | 110.59 | 110.59 | 110.59 | 2800.0 |
| 2004-07-29 19:30:00 | SPY | ETF | 110.57 | 110.57 | 110.55 | 110.55 | 1000.0 |
| 2004-07-29 08:00:00 | QQQ | ETF | 34.54 | 34.72 | 34.54 | 34.72 | 289500.0 |
| 2004-07-29 08:30:00 | QQQ | ETF | 34.7 | 34.72 | 34.61 | 34.62 | 108200.0 |
| 2004-07-29 09:00:00 | QQQ | ETF | 34.61 | 34.78 | 34.6 | 34.7 | 477700.0 |
| 2004-07-29 09:30:00 | QQQ | ETF | 34.71 | 34.76 | 34.6 | 34.734 | 10770500.0 |
| 2004-07-29 10:00:00 | QQQ | ETF | 34.73 | 34.77 | 34.559 | 34.62 | 8316800.0 |
| 2004-07-29 10:30:00 | QQQ | ETF | 34.62 | 34.71 | 34.535 | 34.68 | 5490600.0 |
| 2004-07-29 11:00:00 | QQQ | ETF | 34.68 | 34.74 | 34.63 | 34.63 | 3825400.0 |
| 2004-07-29 11:30:00 | QQQ | ETF | 34.63 | 34.71 | 34.61 | 34.65 | 2901300.0 |
| 2004-07-29 12:00:00 | QQQ | ETF | 34.66 | 34.84 | 34.63 | 34.812 | 5819000.0 |
| 2004-07-29 12:30:00 | QQQ | ETF | 34.82 | 34.92 | 34.76 | 34.79 | 9144000.0 |
| 2004-07-29 13:00:00 | QQQ | ETF | 34.78 | 34.9 | 34.76 | 34.789 | 4164500.0 |
| 2004-07-29 13:30:00 | QQQ | ETF | 34.789 | 34.79 | 34.67 | 34.68 | 4257800.0 |
| 2004-07-29 14:00:00 | QQQ | ETF | 34.68 | 34.7 | 34.5 | 34.56 | 9454500.0 |
| 2004-07-29 14:30:00 | QQQ | ETF | 34.55 | 34.73 | 34.51 | 34.73 | 6443200.0 |
| 2004-07-29 15:00:00 | QQQ | ETF | 34.73 | 34.89 | 34.707 | 34.74 | 10047600.0 |
| 2004-07-29 15:30:00 | QQQ | ETF | 34.73 | 34.81 | 34.65 | 34.77 | 9797100.0 |
| 2004-07-29 16:00:00 | QQQ | ETF | 34.78 | 34.87 | 34.733 | 34.83 | 2360500.0 |
| 2004-07-29 16:30:00 | QQQ | ETF | 34.83 | 34.86 | 34.81 | 34.84 | 352000.0 |
| 2004-07-29 17:00:00 | QQQ | ETF | 34.85 | 34.87 | 34.813 | 34.83 | 109800.0 |
| 2004-07-29 17:30:00 | QQQ | ETF | 34.83 | 34.84 | 34.78 | 34.83 | 48000.0 |
| 2004-07-29 18:00:00 | QQQ | ETF | 34.82 | 34.84 | 34.8 | 34.83 | 51600.0 |
| 2004-07-29 18:30:00 | QQQ | ETF | 34.84 | 34.85 | 34.83 | 34.83 | 25900.0 |
| 2004-07-29 19:00:00 | QQQ | ETF | 34.82 | 34.82 | 34.82 | 34.82 | 500.0 |
| 2004-07-29 19:30:00 | QQQ | ETF | 34.84 | 34.84 | 34.84 | 34.84 | 1200.0 |
| 2004-07-29 08:00:00 | IWM | ETF | 54.215 | 54.215 | 54.215 | 54.215 | 50000.0 |
| 2004-07-29 08:30:00 | IWM | ETF | 54.3 | 54.3 | 54.27 | 54.27 | 2400.0 |
| 2004-07-29 09:00:00 | IWM | ETF | 54.27 | 54.42 | 54.27 | 54.42 | 16600.0 |
> showing 50 of 1,161 rows — these rows as CSV