PREVIEW / etf_30min / 2003-11-21
file: by_date/etf_30min/2003/2003-11-21.parquet size: 25 KB rows: 802
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 |
|---|---|---|---|---|---|---|---|
| 2003-11-21 08:00:00 | SPY | ETF | 104.07 | 104.2 | 104.07 | 104.18 | 24600.0 |
| 2003-11-21 08:30:00 | SPY | ETF | 104.1 | 104.13 | 104.06 | 104.1 | 47600.0 |
| 2003-11-21 09:00:00 | SPY | ETF | 104.14 | 104.27 | 104.08 | 104.27 | 46300.0 |
| 2003-11-21 09:30:00 | SPY | ETF | 104.25 | 104.31 | 104.03 | 104.11 | 3629300.0 |
| 2003-11-21 10:00:00 | SPY | ETF | 104.08 | 104.24 | 103.87 | 104.18 | 2762800.0 |
| 2003-11-21 10:30:00 | SPY | ETF | 104.18 | 104.18 | 103.62 | 103.79 | 3513700.0 |
| 2003-11-21 11:00:00 | SPY | ETF | 103.78 | 104.15 | 103.78 | 104.07 | 2712200.0 |
| 2003-11-21 11:30:00 | SPY | ETF | 104.06 | 104.2 | 103.98 | 104.01 | 1263700.0 |
| 2003-11-21 12:00:00 | SPY | ETF | 104.0 | 104.12 | 103.9 | 103.99 | 993400.0 |
| 2003-11-21 12:30:00 | SPY | ETF | 103.99 | 104.13 | 103.9 | 104.12 | 714800.0 |
| 2003-11-21 13:00:00 | SPY | ETF | 104.11 | 104.33 | 104.05 | 104.23 | 2358700.0 |
| 2003-11-21 13:30:00 | SPY | ETF | 104.24 | 104.26 | 104.05 | 104.09 | 1016100.0 |
| 2003-11-21 14:00:00 | SPY | ETF | 104.09 | 104.16 | 103.96 | 104.09 | 751900.0 |
| 2003-11-21 14:30:00 | SPY | ETF | 104.12 | 104.14 | 103.8 | 103.91 | 1869700.0 |
| 2003-11-21 15:00:00 | SPY | ETF | 103.92 | 104.22 | 103.82 | 104.12 | 1907800.0 |
| 2003-11-21 15:30:00 | SPY | ETF | 104.1 | 104.12 | 103.92 | 104.04 | 2504200.0 |
| 2003-11-21 16:00:00 | SPY | ETF | 104.07 | 104.27 | 104.03 | 104.07 | 1542900.0 |
| 2003-11-21 16:30:00 | SPY | ETF | 104.07 | 104.12 | 104.0 | 104.0 | 41600.0 |
| 2003-11-21 17:00:00 | SPY | ETF | 104.05 | 104.1 | 104.0 | 104.1 | 6000.0 |
| 2003-11-21 17:30:00 | SPY | ETF | 104.1 | 104.14 | 104.1 | 104.12 | 3500.0 |
| 2003-11-21 18:00:00 | SPY | ETF | 104.12 | 104.12 | 104.12 | 104.12 | 1000.0 |
| 2003-11-21 18:30:00 | SPY | ETF | 104.12 | 104.12 | 104.12 | 104.12 | 400.0 |
| 2003-11-21 19:00:00 | SPY | ETF | 104.12 | 104.12 | 104.12 | 104.12 | 1900.0 |
| 2003-11-21 08:00:00 | QQQ | ETF | 33.97 | 34.06 | 33.97 | 34.03 | 122100.0 |
| 2003-11-21 08:30:00 | QQQ | ETF | 34.04 | 34.04 | 34.0 | 34.02 | 89800.0 |
| 2003-11-21 09:00:00 | QQQ | ETF | 34.03 | 34.06 | 34.01 | 34.06 | 92900.0 |
| 2003-11-21 09:30:00 | QQQ | ETF | 34.092 | 34.13 | 33.95 | 34.0 | 10160100.0 |
| 2003-11-21 10:00:00 | QQQ | ETF | 34.0 | 34.07 | 33.86 | 34.05 | 8206200.0 |
| 2003-11-21 10:30:00 | QQQ | ETF | 34.05 | 34.063 | 33.73 | 33.85 | 10346600.0 |
| 2003-11-21 11:00:00 | QQQ | ETF | 33.85 | 34.07 | 33.84 | 34.03 | 6166300.0 |
| 2003-11-21 11:30:00 | QQQ | ETF | 34.03 | 34.18 | 34.01 | 34.09 | 5362600.0 |
| 2003-11-21 12:00:00 | QQQ | ETF | 34.07 | 34.13 | 34.03 | 34.06 | 2012900.0 |
| 2003-11-21 12:30:00 | QQQ | ETF | 34.07 | 34.1 | 33.994 | 34.09 | 1942300.0 |
| 2003-11-21 13:00:00 | QQQ | ETF | 34.09 | 34.25 | 34.08 | 34.2 | 3043500.0 |
| 2003-11-21 13:30:00 | QQQ | ETF | 34.2 | 34.22 | 34.06 | 34.07 | 2757700.0 |
| 2003-11-21 14:00:00 | QQQ | ETF | 34.06 | 34.12 | 34.01 | 34.087 | 3119800.0 |
| 2003-11-21 14:30:00 | QQQ | ETF | 34.08 | 34.12 | 33.93 | 33.941 | 3952000.0 |
| 2003-11-21 15:00:00 | QQQ | ETF | 33.99 | 34.23 | 33.96 | 34.134 | 5623300.0 |
| 2003-11-21 15:30:00 | QQQ | ETF | 34.13 | 34.18 | 34.05 | 34.15 | 7168700.0 |
| 2003-11-21 16:00:00 | QQQ | ETF | 34.15 | 34.265 | 34.12 | 34.215 | 3638800.0 |
| 2003-11-21 16:30:00 | QQQ | ETF | 34.22 | 34.24 | 34.11 | 34.22 | 385100.0 |
| 2003-11-21 17:00:00 | QQQ | ETF | 34.212 | 34.22 | 34.16 | 34.21 | 31400.0 |
| 2003-11-21 17:30:00 | QQQ | ETF | 34.2 | 34.239 | 34.2 | 34.22 | 15700.0 |
| 2003-11-21 18:00:00 | QQQ | ETF | 34.22 | 34.23 | 34.21 | 34.22 | 14600.0 |
| 2003-11-21 18:30:00 | QQQ | ETF | 34.22 | 34.23 | 34.2 | 34.2 | 2400.0 |
| 2003-11-21 19:00:00 | QQQ | ETF | 34.19 | 34.23 | 34.19 | 34.21 | 3100.0 |
| 2003-11-21 19:30:00 | QQQ | ETF | 34.2 | 34.21 | 34.2 | 34.2 | 3000.0 |
| 2003-11-21 09:30:00 | IWM | ETF | 52.425 | 52.65 | 52.365 | 52.43 | 786600.0 |
| 2003-11-21 10:00:00 | IWM | ETF | 52.45 | 52.55 | 52.27 | 52.535 | 988600.0 |
| 2003-11-21 10:30:00 | IWM | ETF | 52.545 | 52.55 | 52.15 | 52.25 | 1475600.0 |
> showing 50 of 802 rows — these rows as CSV