PREVIEW / etf_30min / 2000-11-09
file: by_date/etf_30min/2000/2000-11-09.parquet size: 12 KB rows: 288
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 |
|---|---|---|---|---|---|---|---|
| 2000-11-09 09:30:00 | SPY | ETF | 140.0 | 140.5 | 139.0625 | 140.2812 | 1926300.0 |
| 2000-11-09 10:00:00 | SPY | ETF | 140.4062 | 140.4688 | 139.8438 | 140.3438 | 451100.0 |
| 2000-11-09 10:30:00 | SPY | ETF | 140.3438 | 141.2188 | 140.1562 | 140.5625 | 600300.0 |
| 2000-11-09 11:00:00 | SPY | ETF | 140.5625 | 140.7188 | 140.1875 | 140.5 | 120100.0 |
| 2000-11-09 11:30:00 | SPY | ETF | 140.375 | 140.5938 | 140.0625 | 140.4688 | 101700.0 |
| 2000-11-09 12:00:00 | SPY | ETF | 140.6562 | 140.6562 | 139.7812 | 140.0625 | 75400.0 |
| 2000-11-09 12:30:00 | SPY | ETF | 140.0625 | 140.0938 | 139.4062 | 139.7188 | 265200.0 |
| 2000-11-09 13:00:00 | SPY | ETF | 139.625 | 139.8125 | 139.0938 | 139.2188 | 93800.0 |
| 2000-11-09 13:30:00 | SPY | ETF | 139.2812 | 139.3125 | 137.25 | 137.9688 | 1675000.0 |
| 2000-11-09 14:00:00 | SPY | ETF | 138.0 | 138.8125 | 137.8438 | 138.5938 | 853400.0 |
| 2000-11-09 14:30:00 | SPY | ETF | 138.5625 | 140.3438 | 138.5625 | 140.0312 | 1219200.0 |
| 2000-11-09 15:00:00 | SPY | ETF | 140.0312 | 140.5 | 139.125 | 140.5 | 581200.0 |
| 2000-11-09 15:30:00 | SPY | ETF | 140.5625 | 140.75 | 139.8438 | 140.4062 | 681400.0 |
| 2000-11-09 16:00:00 | SPY | ETF | 140.4062 | 140.4062 | 138.1562 | 138.1562 | 436200.0 |
| 2000-11-09 16:30:00 | SPY | ETF | 139.8438 | 139.8438 | 139.8438 | 139.8438 | 868000.0 |
| 2000-11-09 09:30:00 | QQQ | ETF | 74.75 | 75.875 | 73.7812 | 75.8438 | 11986500.0 |
| 2000-11-09 10:00:00 | QQQ | ETF | 75.75 | 75.8438 | 74.75 | 75.625 | 4498000.0 |
| 2000-11-09 10:30:00 | QQQ | ETF | 75.7188 | 76.9375 | 75.5938 | 75.8438 | 5095000.0 |
| 2000-11-09 11:00:00 | QQQ | ETF | 75.75 | 76.0 | 75.1562 | 75.4688 | 1934500.0 |
| 2000-11-09 11:30:00 | QQQ | ETF | 75.4688 | 76.0 | 74.9375 | 76.0 | 2085300.0 |
| 2000-11-09 12:00:00 | QQQ | ETF | 76.0 | 76.1875 | 74.75 | 75.0312 | 1843900.0 |
| 2000-11-09 12:30:00 | QQQ | ETF | 75.0625 | 75.25 | 74.375 | 74.9062 | 2538200.0 |
| 2000-11-09 13:00:00 | QQQ | ETF | 74.9375 | 75.25 | 74.1875 | 74.4375 | 2182600.0 |
| 2000-11-09 13:30:00 | QQQ | ETF | 74.375 | 74.4375 | 73.0 | 73.7188 | 9166700.0 |
| 2000-11-09 14:00:00 | QQQ | ETF | 73.75 | 74.5 | 73.625 | 74.375 | 4841400.0 |
| 2000-11-09 14:30:00 | QQQ | ETF | 74.4062 | 76.125 | 74.3125 | 75.7812 | 6455500.0 |
| 2000-11-09 15:00:00 | QQQ | ETF | 75.7812 | 76.125 | 74.875 | 76.125 | 3259800.0 |
| 2000-11-09 15:30:00 | QQQ | ETF | 76.0938 | 76.625 | 75.375 | 76.3125 | 3456200.0 |
| 2000-11-09 16:00:00 | QQQ | ETF | 76.2812 | 76.5 | 75.0 | 76.5 | 1588400.0 |
| 2000-11-09 16:30:00 | QQQ | ETF | 75.75 | 76.4375 | 75.375 | 76.0625 | 21200.0 |
| 2000-11-09 17:00:00 | QQQ | ETF | 76.0 | 76.125 | 75.6875 | 75.75 | 7300.0 |
| 2000-11-09 17:30:00 | QQQ | ETF | 75.75 | 76.0 | 75.5 | 76.0 | 6900.0 |
| 2000-11-09 18:00:00 | QQQ | ETF | 75.75 | 75.75 | 75.25 | 75.25 | 4100.0 |
| 2000-11-09 09:30:00 | IWM | ETF | 49.375 | 49.5 | 49.125 | 49.4688 | 57000.0 |
| 2000-11-09 10:00:00 | IWM | ETF | 49.3438 | 49.5156 | 49.3438 | 49.4688 | 24800.0 |
| 2000-11-09 10:30:00 | IWM | ETF | 49.5938 | 49.6875 | 49.4688 | 49.6562 | 13400.0 |
| 2000-11-09 11:00:00 | IWM | ETF | 49.4688 | 49.5 | 49.4688 | 49.5 | 30400.0 |
| 2000-11-09 11:30:00 | IWM | ETF | 49.4688 | 49.4688 | 49.2344 | 49.4375 | 2800.0 |
| 2000-11-09 12:00:00 | IWM | ETF | 49.2812 | 49.2812 | 49.2812 | 49.2812 | 2000.0 |
| 2000-11-09 12:30:00 | IWM | ETF | 49.2188 | 49.2188 | 49.2188 | 49.2188 | 3600.0 |
| 2000-11-09 13:00:00 | IWM | ETF | 49.0625 | 49.1875 | 49.0 | 49.0 | 25400.0 |
| 2000-11-09 13:30:00 | IWM | ETF | 48.7188 | 48.7188 | 48.7188 | 48.7188 | 31000.0 |
| 2000-11-09 14:00:00 | IWM | ETF | 48.5312 | 48.8438 | 48.5312 | 48.8438 | 33800.0 |
| 2000-11-09 14:30:00 | IWM | ETF | 49.1562 | 49.1562 | 49.1562 | 49.1562 | 200.0 |
| 2000-11-09 15:00:00 | IWM | ETF | 49.125 | 49.125 | 49.125 | 49.125 | 2000.0 |
| 2000-11-09 15:30:00 | IWM | ETF | 49.4688 | 49.4688 | 49.3125 | 49.375 | 22200.0 |
| 2000-11-09 16:00:00 | IWM | ETF | 49.3125 | 49.3125 | 49.25 | 49.25 | 400.0 |
| 2000-11-09 09:30:00 | DIA | ETF | 107.9375 | 108.5625 | 107.4375 | 108.5625 | 447800.0 |
| 2000-11-09 10:00:00 | DIA | ETF | 108.5 | 108.7188 | 107.875 | 108.25 | 542300.0 |
| 2000-11-09 10:30:00 | DIA | ETF | 108.125 | 108.9688 | 108.125 | 108.625 | 104600.0 |
> showing 50 of 288 rows — these rows as CSV