PREVIEW / etf_30min / 2000-02-04
file: by_date/etf_30min/2000/2000-02-04.parquet size: 10 KB rows: 218
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-04 09:30:00 | SPY | ETF | 143.1875 | 144.0 | 143.1875 | 143.7188 | 899900.0 |
| 2000-02-04 10:00:00 | SPY | ETF | 143.6562 | 143.8438 | 143.0625 | 143.0938 | 1151700.0 |
| 2000-02-04 10:30:00 | SPY | ETF | 143.1562 | 143.5625 | 142.875 | 143.375 | 210500.0 |
| 2000-02-04 11:00:00 | SPY | ETF | 143.5938 | 143.5938 | 143.0 | 143.0312 | 168500.0 |
| 2000-02-04 11:30:00 | SPY | ETF | 143.125 | 143.7188 | 143.0 | 143.25 | 179800.0 |
| 2000-02-04 12:00:00 | SPY | ETF | 143.25 | 143.5 | 143.0312 | 143.125 | 99000.0 |
| 2000-02-04 12:30:00 | SPY | ETF | 143.125 | 143.75 | 143.125 | 143.5 | 156500.0 |
| 2000-02-04 13:00:00 | SPY | ETF | 143.4375 | 143.625 | 143.25 | 143.625 | 152900.0 |
| 2000-02-04 13:30:00 | SPY | ETF | 143.6875 | 143.6875 | 143.0312 | 143.25 | 275100.0 |
| 2000-02-04 14:00:00 | SPY | ETF | 143.125 | 143.5938 | 142.875 | 143.5 | 129500.0 |
| 2000-02-04 14:30:00 | SPY | ETF | 143.5938 | 143.8438 | 143.2188 | 143.5938 | 180400.0 |
| 2000-02-04 15:00:00 | SPY | ETF | 143.625 | 143.6562 | 142.4062 | 142.6562 | 311700.0 |
| 2000-02-04 15:30:00 | SPY | ETF | 142.375 | 142.9062 | 142.125 | 142.7812 | 624400.0 |
| 2000-02-04 16:00:00 | SPY | ETF | 142.8438 | 142.8438 | 142.5312 | 142.5938 | 380500.0 |
| 2000-02-04 09:30:00 | QQQ | ETF | 97.0 | 98.0 | 96.75 | 97.75 | 3759600.0 |
| 2000-02-04 10:00:00 | QQQ | ETF | 97.8125 | 97.8594 | 96.9375 | 97.0312 | 2426400.0 |
| 2000-02-04 10:30:00 | QQQ | ETF | 97.2812 | 97.4688 | 96.75 | 97.4062 | 2462600.0 |
| 2000-02-04 11:00:00 | QQQ | ETF | 97.4688 | 97.625 | 97.0625 | 97.1875 | 1643200.0 |
| 2000-02-04 11:30:00 | QQQ | ETF | 97.1875 | 97.8438 | 97.0938 | 97.3438 | 1466600.0 |
| 2000-02-04 12:00:00 | QQQ | ETF | 97.3125 | 97.625 | 97.2188 | 97.375 | 617200.0 |
| 2000-02-04 12:30:00 | QQQ | ETF | 97.3438 | 97.9062 | 97.25 | 97.8438 | 942400.0 |
| 2000-02-04 13:00:00 | QQQ | ETF | 97.7812 | 97.9375 | 97.5312 | 97.9375 | 662400.0 |
| 2000-02-04 13:30:00 | QQQ | ETF | 97.9375 | 97.9375 | 97.25 | 97.375 | 1302400.0 |
| 2000-02-04 14:00:00 | QQQ | ETF | 97.25 | 97.9844 | 97.125 | 97.9688 | 968200.0 |
| 2000-02-04 14:30:00 | QQQ | ETF | 97.9844 | 98.2344 | 97.7656 | 98.0 | 1805400.0 |
| 2000-02-04 15:00:00 | QQQ | ETF | 98.0625 | 98.1875 | 96.9375 | 96.9375 | 2080000.0 |
| 2000-02-04 15:30:00 | QQQ | ETF | 96.9062 | 97.0 | 96.2188 | 96.75 | 5743400.0 |
| 2000-02-04 16:00:00 | QQQ | ETF | 96.6719 | 96.9844 | 96.5625 | 96.9062 | 601400.0 |
| 2000-02-04 16:30:00 | QQQ | ETF | 96.9062 | 96.9062 | 96.9062 | 96.9062 | 200.0 |
| 2000-02-04 18:00:00 | QQQ | ETF | 97.0 | 97.0 | 97.0 | 97.0 | 200.0 |
| 2000-02-04 09:30:00 | DIA | ETF | 110.4375 | 110.9688 | 110.4375 | 110.625 | 142800.0 |
| 2000-02-04 10:00:00 | DIA | ETF | 110.375 | 110.5 | 110.0625 | 110.25 | 25500.0 |
| 2000-02-04 10:30:00 | DIA | ETF | 110.25 | 110.3125 | 109.875 | 110.125 | 24800.0 |
| 2000-02-04 11:00:00 | DIA | ETF | 110.1875 | 110.3438 | 109.9688 | 109.9688 | 11900.0 |
| 2000-02-04 11:30:00 | DIA | ETF | 110.1875 | 110.625 | 110.0312 | 110.25 | 32400.0 |
| 2000-02-04 12:00:00 | DIA | ETF | 110.2188 | 110.4062 | 109.9688 | 110.2812 | 11400.0 |
| 2000-02-04 12:30:00 | DIA | ETF | 110.0625 | 110.5938 | 110.0625 | 110.4688 | 12900.0 |
| 2000-02-04 13:00:00 | DIA | ETF | 110.3125 | 110.4375 | 110.0625 | 110.3125 | 17200.0 |
| 2000-02-04 13:30:00 | DIA | ETF | 110.5 | 110.5 | 109.9375 | 110.0312 | 18600.0 |
| 2000-02-04 14:00:00 | DIA | ETF | 110.0312 | 110.375 | 109.9375 | 110.375 | 16900.0 |
| 2000-02-04 14:30:00 | DIA | ETF | 110.375 | 110.4688 | 110.0312 | 110.25 | 12300.0 |
| 2000-02-04 15:00:00 | DIA | ETF | 110.3438 | 110.3438 | 109.4688 | 109.4688 | 63100.0 |
| 2000-02-04 15:30:00 | DIA | ETF | 109.5 | 110.0 | 109.3438 | 109.8125 | 59500.0 |
| 2000-02-04 16:00:00 | DIA | ETF | 109.8438 | 109.8438 | 109.5938 | 109.75 | 22600.0 |
> showing 44 of 218 rows — these rows as CSV