PREVIEW / etf_30min / 2000-02-07
file: by_date/etf_30min/2000/2000-02-07.parquet size: 9 KB rows: 213
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-02-07 09:30:00 | SPY | ETF | 142.5625 | 142.7188 | 142.0 | 142.0 | 649200.0 |
| 2000-02-07 10:00:00 | SPY | ETF | 142.0 | 142.5 | 141.8125 | 142.4688 | 343900.0 |
| 2000-02-07 10:30:00 | SPY | ETF | 142.2812 | 142.5938 | 141.8438 | 142.125 | 255400.0 |
| 2000-02-07 11:00:00 | SPY | ETF | 141.7812 | 142.5 | 141.7812 | 142.3125 | 234600.0 |
| 2000-02-07 11:30:00 | SPY | ETF | 142.25 | 142.4062 | 141.9375 | 142.2188 | 180300.0 |
| 2000-02-07 12:00:00 | SPY | ETF | 142.0625 | 142.3125 | 141.6562 | 141.75 | 191700.0 |
| 2000-02-07 12:30:00 | SPY | ETF | 141.75 | 142.0 | 141.75 | 141.875 | 187300.0 |
| 2000-02-07 13:00:00 | SPY | ETF | 141.9688 | 142.125 | 141.625 | 141.9688 | 82100.0 |
| 2000-02-07 13:30:00 | SPY | ETF | 141.875 | 142.1875 | 141.7812 | 141.875 | 1122500.0 |
| 2000-02-07 14:00:00 | SPY | ETF | 141.875 | 142.0938 | 141.5 | 141.625 | 288500.0 |
| 2000-02-07 14:30:00 | SPY | ETF | 141.625 | 142.0938 | 141.4375 | 141.9688 | 919100.0 |
| 2000-02-07 15:00:00 | SPY | ETF | 142.1562 | 142.375 | 141.7188 | 142.1562 | 148100.0 |
| 2000-02-07 15:30:00 | SPY | ETF | 142.3125 | 142.7812 | 142.0625 | 142.7188 | 938900.0 |
| 2000-02-07 16:00:00 | SPY | ETF | 142.5312 | 142.6562 | 142.3125 | 142.375 | 255400.0 |
| 2000-02-07 16:30:00 | SPY | ETF | 142.375 | 142.375 | 142.375 | 142.375 | 1000.0 |
| 2000-02-07 09:30:00 | QQQ | ETF | 97.25 | 97.375 | 96.25 | 96.4375 | 2579000.0 |
| 2000-02-07 10:00:00 | QQQ | ETF | 96.625 | 97.5938 | 96.375 | 97.5938 | 1723600.0 |
| 2000-02-07 10:30:00 | QQQ | ETF | 97.375 | 97.625 | 96.8125 | 96.875 | 1681000.0 |
| 2000-02-07 11:00:00 | QQQ | ETF | 96.9062 | 97.375 | 96.5625 | 97.0625 | 1104800.0 |
| 2000-02-07 11:30:00 | QQQ | ETF | 97.0312 | 97.2344 | 96.7969 | 97.0469 | 426600.0 |
| 2000-02-07 12:00:00 | QQQ | ETF | 97.0625 | 97.125 | 96.6562 | 96.75 | 792400.0 |
| 2000-02-07 12:30:00 | QQQ | ETF | 96.75 | 97.0625 | 96.625 | 96.8594 | 334600.0 |
| 2000-02-07 13:00:00 | QQQ | ETF | 96.8594 | 96.9219 | 96.5 | 96.6406 | 701600.0 |
| 2000-02-07 13:30:00 | QQQ | ETF | 96.6719 | 97.1562 | 96.5938 | 96.7812 | 621000.0 |
| 2000-02-07 14:00:00 | QQQ | ETF | 96.75 | 97.1094 | 96.4375 | 96.4375 | 713800.0 |
| 2000-02-07 14:30:00 | QQQ | ETF | 96.5 | 97.0625 | 96.3125 | 96.9062 | 1183000.0 |
| 2000-02-07 15:00:00 | QQQ | ETF | 97.0 | 97.3594 | 96.6875 | 97.25 | 1249200.0 |
| 2000-02-07 15:30:00 | QQQ | ETF | 97.3438 | 98.25 | 97.1875 | 98.25 | 3926200.0 |
| 2000-02-07 16:00:00 | QQQ | ETF | 98.2344 | 98.2969 | 98.0156 | 98.2344 | 629000.0 |
| 2000-02-07 16:30:00 | QQQ | ETF | 98.0625 | 98.5 | 98.0 | 98.25 | 13600.0 |
| 2000-02-07 17:00:00 | QQQ | ETF | 98.4062 | 98.4062 | 98.4062 | 98.4062 | 10000.0 |
| 2000-02-07 17:30:00 | QQQ | ETF | 98.5 | 98.5 | 98.5 | 98.5 | 200.0 |
| 2000-02-07 18:00:00 | QQQ | ETF | 98.625 | 98.625 | 98.5 | 98.5 | 800.0 |
| 2000-02-07 09:30:00 | DIA | ETF | 109.1562 | 109.4688 | 108.8125 | 108.9688 | 118700.0 |
| 2000-02-07 10:00:00 | DIA | ETF | 108.875 | 109.2812 | 108.625 | 109.125 | 66800.0 |
| 2000-02-07 10:30:00 | DIA | ETF | 109.0312 | 109.25 | 108.625 | 108.625 | 48600.0 |
| 2000-02-07 11:00:00 | DIA | ETF | 108.5312 | 109.25 | 108.5312 | 109.0 | 18000.0 |
| 2000-02-07 11:30:00 | DIA | ETF | 109.0 | 109.125 | 108.8125 | 108.8125 | 10900.0 |
| 2000-02-07 12:00:00 | DIA | ETF | 109.0625 | 109.0625 | 108.5 | 108.75 | 22900.0 |
| 2000-02-07 12:30:00 | DIA | ETF | 108.8125 | 108.875 | 108.625 | 108.625 | 23500.0 |
| 2000-02-07 13:00:00 | DIA | ETF | 108.8125 | 108.8125 | 108.375 | 108.6562 | 19100.0 |
| 2000-02-07 13:30:00 | DIA | ETF | 108.5625 | 109.0312 | 108.5 | 108.7812 | 17000.0 |
| 2000-02-07 14:00:00 | DIA | ETF | 108.75 | 108.9375 | 108.5 | 108.7188 | 9300.0 |
| 2000-02-07 14:30:00 | DIA | ETF | 108.625 | 108.9375 | 108.5 | 108.875 | 32600.0 |
| 2000-02-07 15:00:00 | DIA | ETF | 108.9375 | 109.0938 | 108.6875 | 108.75 | 17300.0 |
| 2000-02-07 15:30:00 | DIA | ETF | 108.9062 | 109.2812 | 108.875 | 109.0 | 149100.0 |
| 2000-02-07 16:00:00 | DIA | ETF | 109.0312 | 109.0312 | 108.7188 | 108.75 | 62600.0 |
> showing 47 of 213 rows — these rows as CSV