PREVIEW / etf_30min / 2003-09-29
file: by_date/etf_30min/2003/2003-09-29.parquet size: 24 KB rows: 726
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-09-29 08:00:00 | SPY | ETF | 100.28 | 100.37 | 100.25 | 100.32 | 59400.0 |
| 2003-09-29 08:30:00 | SPY | ETF | 100.32 | 100.38 | 100.28 | 100.28 | 98800.0 |
| 2003-09-29 09:00:00 | SPY | ETF | 100.3 | 100.3 | 100.25 | 100.25 | 28400.0 |
| 2003-09-29 09:30:00 | SPY | ETF | 100.3 | 100.52 | 100.247 | 100.25 | 2830400.0 |
| 2003-09-29 10:00:00 | SPY | ETF | 100.24 | 100.49 | 100.2 | 100.37 | 1593800.0 |
| 2003-09-29 10:30:00 | SPY | ETF | 100.36 | 100.43 | 99.92 | 100.07 | 3078900.0 |
| 2003-09-29 11:00:00 | SPY | ETF | 100.07 | 100.364 | 99.79 | 100.26 | 4219300.0 |
| 2003-09-29 11:30:00 | SPY | ETF | 100.25 | 100.45 | 100.18 | 100.42 | 1635400.0 |
| 2003-09-29 12:00:00 | SPY | ETF | 100.42 | 100.9 | 100.41 | 100.79 | 5124000.0 |
| 2003-09-29 12:30:00 | SPY | ETF | 100.79 | 100.86 | 100.65 | 100.78 | 1065700.0 |
| 2003-09-29 13:00:00 | SPY | ETF | 100.78 | 100.93 | 100.67 | 100.8 | 2023200.0 |
| 2003-09-29 13:30:00 | SPY | ETF | 100.83 | 100.85 | 100.59 | 100.8 | 1068900.0 |
| 2003-09-29 14:00:00 | SPY | ETF | 100.79 | 100.89 | 100.66 | 100.785 | 780200.0 |
| 2003-09-29 14:30:00 | SPY | ETF | 100.79 | 100.99 | 100.699 | 100.984 | 1295800.0 |
| 2003-09-29 15:00:00 | SPY | ETF | 100.97 | 100.97 | 100.5 | 100.64 | 2206800.0 |
| 2003-09-29 15:30:00 | SPY | ETF | 100.65 | 100.9 | 100.5 | 100.87 | 2602400.0 |
| 2003-09-29 16:00:00 | SPY | ETF | 100.85 | 100.94 | 100.7 | 100.9 | 1027500.0 |
| 2003-09-29 16:30:00 | SPY | ETF | 100.89 | 100.99 | 100.81 | 100.84 | 91400.0 |
| 2003-09-29 17:00:00 | SPY | ETF | 100.84 | 100.93 | 100.84 | 100.93 | 9000.0 |
| 2003-09-29 17:30:00 | SPY | ETF | 100.88 | 100.92 | 100.85 | 100.92 | 2500.0 |
| 2003-09-29 18:00:00 | SPY | ETF | 100.92 | 100.95 | 100.92 | 100.95 | 6800.0 |
| 2003-09-29 18:30:00 | SPY | ETF | 100.88 | 100.88 | 100.87 | 100.87 | 6000.0 |
| 2003-09-29 19:00:00 | SPY | ETF | 100.84 | 100.84 | 100.83 | 100.83 | 600.0 |
| 2003-09-29 19:30:00 | SPY | ETF | 100.81 | 100.82 | 100.81 | 100.82 | 2100.0 |
| 2003-09-29 08:00:00 | QQQ | ETF | 32.81 | 32.84 | 32.8 | 32.84 | 64000.0 |
| 2003-09-29 08:30:00 | QQQ | ETF | 32.82 | 32.86 | 32.8 | 32.83 | 34400.0 |
| 2003-09-29 09:00:00 | QQQ | ETF | 32.83 | 32.84 | 32.76 | 32.76 | 80700.0 |
| 2003-09-29 09:30:00 | QQQ | ETF | 32.758 | 32.94 | 32.73 | 32.81 | 10802900.0 |
| 2003-09-29 10:00:00 | QQQ | ETF | 32.805 | 32.88 | 32.72 | 32.8 | 4877100.0 |
| 2003-09-29 10:30:00 | QQQ | ETF | 32.83 | 32.857 | 32.6 | 32.68 | 8448400.0 |
| 2003-09-29 11:00:00 | QQQ | ETF | 32.681 | 32.79 | 32.45 | 32.76 | 13605500.0 |
| 2003-09-29 11:30:00 | QQQ | ETF | 32.75 | 32.82 | 32.68 | 32.8 | 5479700.0 |
| 2003-09-29 12:00:00 | QQQ | ETF | 32.79 | 33.01 | 32.79 | 32.977 | 8630900.0 |
| 2003-09-29 12:30:00 | QQQ | ETF | 32.98 | 33.02 | 32.87 | 33.0 | 5576800.0 |
| 2003-09-29 13:00:00 | QQQ | ETF | 32.99 | 33.12 | 32.93 | 33.07 | 4701000.0 |
| 2003-09-29 13:30:00 | QQQ | ETF | 33.06 | 33.1 | 32.95 | 33.05 | 3600000.0 |
| 2003-09-29 14:00:00 | QQQ | ETF | 33.05 | 33.1 | 33.0 | 33.053 | 2321900.0 |
| 2003-09-29 14:30:00 | QQQ | ETF | 33.05 | 33.16 | 32.995 | 33.129 | 3124300.0 |
| 2003-09-29 15:00:00 | QQQ | ETF | 33.139 | 33.151 | 32.85 | 32.96 | 4630000.0 |
| 2003-09-29 15:30:00 | QQQ | ETF | 32.96 | 33.132 | 32.88 | 33.11 | 5072100.0 |
| 2003-09-29 16:00:00 | QQQ | ETF | 33.1 | 33.2 | 33.08 | 33.14 | 3702500.0 |
| 2003-09-29 16:30:00 | QQQ | ETF | 33.14 | 33.16 | 33.12 | 33.13 | 454200.0 |
| 2003-09-29 17:00:00 | QQQ | ETF | 33.157 | 33.17 | 33.15 | 33.16 | 115100.0 |
| 2003-09-29 17:30:00 | QQQ | ETF | 33.15 | 33.16 | 33.15 | 33.16 | 59100.0 |
| 2003-09-29 18:00:00 | QQQ | ETF | 33.165 | 33.19 | 33.16 | 33.18 | 180700.0 |
| 2003-09-29 18:30:00 | QQQ | ETF | 33.18 | 33.18 | 33.18 | 33.18 | 1200.0 |
| 2003-09-29 19:00:00 | QQQ | ETF | 33.17 | 33.18 | 33.17 | 33.17 | 4300.0 |
| 2003-09-29 19:30:00 | QQQ | ETF | 33.16 | 33.18 | 33.16 | 33.16 | 10500.0 |
| 2003-09-29 09:00:00 | IWM | ETF | 48.0 | 48.435 | 48.0 | 48.435 | 2000.0 |
| 2003-09-29 09:30:00 | IWM | ETF | 48.625 | 48.79 | 48.49 | 48.58 | 1509200.0 |
> showing 50 of 726 rows — these rows as CSV