PREVIEW / etf_30min / 2004-08-03
file: by_date/etf_30min/2004/2004-08-03.parquet size: 35 KB rows: 1,148
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-08-03 08:00:00 | SPY | ETF | 110.92 | 111.03 | 110.92 | 111.03 | 36600.0 |
| 2004-08-03 08:30:00 | SPY | ETF | 110.96 | 110.96 | 110.91 | 110.92 | 15000.0 |
| 2004-08-03 09:00:00 | SPY | ETF | 110.94 | 111.03 | 110.94 | 110.97 | 58900.0 |
| 2004-08-03 09:30:00 | SPY | ETF | 110.93 | 111.04 | 110.86 | 110.9 | 4336000.0 |
| 2004-08-03 10:00:00 | SPY | ETF | 110.91 | 110.95 | 110.59 | 110.59 | 3834300.0 |
| 2004-08-03 10:30:00 | SPY | ETF | 110.58 | 110.84 | 110.56 | 110.84 | 2295400.0 |
| 2004-08-03 11:00:00 | SPY | ETF | 110.84 | 110.92 | 110.73 | 110.81 | 2081000.0 |
| 2004-08-03 11:30:00 | SPY | ETF | 110.81 | 111.06 | 110.79 | 110.9 | 1687900.0 |
| 2004-08-03 12:00:00 | SPY | ETF | 110.9 | 111.03 | 110.84 | 110.94 | 1155600.0 |
| 2004-08-03 12:30:00 | SPY | ETF | 110.94 | 110.99 | 110.72 | 110.77 | 1504700.0 |
| 2004-08-03 13:00:00 | SPY | ETF | 110.76 | 110.82 | 110.62 | 110.74 | 1847400.0 |
| 2004-08-03 13:30:00 | SPY | ETF | 110.72 | 110.9 | 110.65 | 110.84 | 2003000.0 |
| 2004-08-03 14:00:00 | SPY | ETF | 110.84 | 110.86 | 110.45 | 110.57 | 4383700.0 |
| 2004-08-03 14:30:00 | SPY | ETF | 110.57 | 110.64 | 110.35 | 110.47 | 4492200.0 |
| 2004-08-03 15:00:00 | SPY | ETF | 110.46 | 110.63 | 110.32 | 110.43 | 3188400.0 |
| 2004-08-03 15:30:00 | SPY | ETF | 110.41 | 110.61 | 110.32 | 110.35 | 3285000.0 |
| 2004-08-03 16:00:00 | SPY | ETF | 110.38 | 110.4 | 110.16 | 110.2 | 3527300.0 |
| 2004-08-03 16:30:00 | SPY | ETF | 110.24 | 110.26 | 110.16 | 110.17 | 92400.0 |
| 2004-08-03 17:00:00 | SPY | ETF | 110.17 | 110.5505 | 110.11 | 110.11 | 99500.0 |
| 2004-08-03 17:30:00 | SPY | ETF | 110.11 | 110.14 | 110.11 | 110.13 | 2200.0 |
| 2004-08-03 18:00:00 | SPY | ETF | 110.16 | 110.18 | 110.14 | 110.16 | 13200.0 |
| 2004-08-03 18:30:00 | SPY | ETF | 110.15 | 110.19 | 110.15 | 110.19 | 6500.0 |
| 2004-08-03 19:00:00 | SPY | ETF | 110.17 | 110.17 | 110.16 | 110.16 | 3000.0 |
| 2004-08-03 19:30:00 | SPY | ETF | 110.16 | 110.16 | 110.16 | 110.16 | 2800.0 |
| 2004-08-03 08:00:00 | QQQ | ETF | 34.88 | 34.91 | 34.87 | 34.9 | 37700.0 |
| 2004-08-03 08:30:00 | QQQ | ETF | 34.9 | 34.9 | 34.85 | 34.85 | 94200.0 |
| 2004-08-03 09:00:00 | QQQ | ETF | 34.88 | 34.89 | 34.85 | 34.85 | 85700.0 |
| 2004-08-03 09:30:00 | QQQ | ETF | 34.84 | 34.921 | 34.76 | 34.81 | 9133900.0 |
| 2004-08-03 10:00:00 | QQQ | ETF | 34.81 | 34.82 | 34.59 | 34.59 | 8435700.0 |
| 2004-08-03 10:30:00 | QQQ | ETF | 34.6 | 34.717 | 34.57 | 34.717 | 5349900.0 |
| 2004-08-03 11:00:00 | QQQ | ETF | 34.717 | 34.73 | 34.64 | 34.65 | 3981300.0 |
| 2004-08-03 11:30:00 | QQQ | ETF | 34.65 | 34.76 | 34.64 | 34.67 | 3724300.0 |
| 2004-08-03 12:00:00 | QQQ | ETF | 34.667 | 34.702 | 34.62 | 34.66 | 4101300.0 |
| 2004-08-03 12:30:00 | QQQ | ETF | 34.66 | 34.68 | 34.55 | 34.58 | 4414800.0 |
| 2004-08-03 13:00:00 | QQQ | ETF | 34.58 | 34.61 | 34.47 | 34.53 | 5687300.0 |
| 2004-08-03 13:30:00 | QQQ | ETF | 34.53 | 34.6 | 34.49 | 34.56 | 3532200.0 |
| 2004-08-03 14:00:00 | QQQ | ETF | 34.55 | 34.56 | 34.376 | 34.41 | 7261600.0 |
| 2004-08-03 14:30:00 | QQQ | ETF | 34.41 | 34.48 | 34.31 | 34.365 | 8303400.0 |
| 2004-08-03 15:00:00 | QQQ | ETF | 34.365 | 34.45 | 34.339 | 34.382 | 6203300.0 |
| 2004-08-03 15:30:00 | QQQ | ETF | 34.38 | 34.45 | 34.27 | 34.29 | 9779900.0 |
| 2004-08-03 16:00:00 | QQQ | ETF | 34.29 | 34.3 | 34.18 | 34.18 | 3716000.0 |
| 2004-08-03 16:30:00 | QQQ | ETF | 34.18 | 34.22 | 34.15 | 34.17 | 174300.0 |
| 2004-08-03 17:00:00 | QQQ | ETF | 34.17 | 34.19 | 34.151 | 34.151 | 167700.0 |
| 2004-08-03 17:30:00 | QQQ | ETF | 34.18 | 34.18 | 34.13 | 34.15 | 43000.0 |
| 2004-08-03 18:00:00 | QQQ | ETF | 34.14 | 34.18 | 34.14 | 34.16 | 29000.0 |
| 2004-08-03 18:30:00 | QQQ | ETF | 34.15 | 34.16 | 34.15 | 34.16 | 10700.0 |
| 2004-08-03 19:00:00 | QQQ | ETF | 34.15 | 34.17 | 34.15 | 34.17 | 5400.0 |
| 2004-08-03 19:30:00 | QQQ | ETF | 34.16 | 34.17 | 34.16 | 34.17 | 21000.0 |
| 2004-08-03 09:30:00 | IWM | ETF | 54.715 | 54.775 | 54.575 | 54.67 | 1019200.0 |
| 2004-08-03 10:00:00 | IWM | ETF | 54.725 | 54.77 | 54.315 | 54.33 | 1192200.0 |
> showing 50 of 1,148 rows — these rows as CSV