PREVIEW / etf_30min / 2000-02-14
file: by_date/etf_30min/2000/2000-02-14.parquet size: 10 KB rows: 215
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-14 09:30:00 | SPY | ETF | 139.7812 | 139.7812 | 138.9375 | 139.0625 | 1389400.0 |
| 2000-02-14 10:00:00 | SPY | ETF | 138.9062 | 139.5312 | 138.5 | 138.5312 | 1207500.0 |
| 2000-02-14 10:30:00 | SPY | ETF | 138.5625 | 139.25 | 138.5312 | 139.125 | 480300.0 |
| 2000-02-14 11:00:00 | SPY | ETF | 139.125 | 139.75 | 139.0312 | 139.5312 | 828400.0 |
| 2000-02-14 11:30:00 | SPY | ETF | 139.5625 | 139.7188 | 139.25 | 139.625 | 217000.0 |
| 2000-02-14 12:00:00 | SPY | ETF | 139.6875 | 139.6875 | 139.0 | 139.0 | 141100.0 |
| 2000-02-14 12:30:00 | SPY | ETF | 138.9688 | 139.1875 | 138.7812 | 138.875 | 408900.0 |
| 2000-02-14 13:00:00 | SPY | ETF | 139.0 | 139.0938 | 138.5 | 138.5 | 157500.0 |
| 2000-02-14 13:30:00 | SPY | ETF | 138.5938 | 139.0938 | 138.3125 | 138.7812 | 709900.0 |
| 2000-02-14 14:00:00 | SPY | ETF | 138.875 | 138.9688 | 138.4375 | 138.8125 | 214700.0 |
| 2000-02-14 14:30:00 | SPY | ETF | 138.8125 | 139.2188 | 138.5 | 138.625 | 863700.0 |
| 2000-02-14 15:00:00 | SPY | ETF | 138.6875 | 139.4375 | 138.5312 | 139.125 | 450500.0 |
| 2000-02-14 15:30:00 | SPY | ETF | 139.125 | 139.4688 | 138.9375 | 139.25 | 799900.0 |
| 2000-02-14 16:00:00 | SPY | ETF | 139.25 | 139.5625 | 139.1875 | 139.5 | 597900.0 |
| 2000-02-14 09:30:00 | QQQ | ETF | 99.9844 | 100.0 | 99.0 | 99.0 | 2612200.0 |
| 2000-02-14 10:00:00 | QQQ | ETF | 99.375 | 99.6719 | 97.875 | 98.0312 | 2412800.0 |
| 2000-02-14 10:30:00 | QQQ | ETF | 98.0938 | 98.8594 | 97.75 | 98.625 | 2871200.0 |
| 2000-02-14 11:00:00 | QQQ | ETF | 98.5938 | 99.5312 | 98.5 | 99.2031 | 2656000.0 |
| 2000-02-14 11:30:00 | QQQ | ETF | 99.125 | 99.5 | 98.75 | 99.4062 | 878800.0 |
| 2000-02-14 12:00:00 | QQQ | ETF | 99.4375 | 99.4844 | 98.5781 | 98.625 | 1146000.0 |
| 2000-02-14 12:30:00 | QQQ | ETF | 98.7344 | 99.0 | 98.5156 | 98.8594 | 640800.0 |
| 2000-02-14 13:00:00 | QQQ | ETF | 98.8438 | 99.0625 | 98.0625 | 98.0938 | 941400.0 |
| 2000-02-14 13:30:00 | QQQ | ETF | 98.125 | 98.5625 | 97.75 | 98.3125 | 1756600.0 |
| 2000-02-14 14:00:00 | QQQ | ETF | 98.3125 | 98.6875 | 97.9062 | 98.6562 | 896000.0 |
| 2000-02-14 14:30:00 | QQQ | ETF | 98.6562 | 99.0 | 98.0625 | 98.125 | 1581400.0 |
| 2000-02-14 15:00:00 | QQQ | ETF | 98.0625 | 99.25 | 98.0 | 99.1875 | 1828200.0 |
| 2000-02-14 15:30:00 | QQQ | ETF | 99.25 | 99.7344 | 98.9375 | 99.5 | 2143600.0 |
| 2000-02-14 16:00:00 | QQQ | ETF | 99.5 | 99.5312 | 99.25 | 99.3594 | 302000.0 |
| 2000-02-14 17:30:00 | QQQ | ETF | 99.75 | 99.75 | 99.75 | 99.75 | 800.0 |
| 2000-02-14 09:30:00 | DIA | ETF | 105.0 | 105.0625 | 104.6562 | 104.6875 | 246900.0 |
| 2000-02-14 10:00:00 | DIA | ETF | 104.75 | 105.25 | 104.5625 | 104.75 | 101100.0 |
| 2000-02-14 10:30:00 | DIA | ETF | 104.5938 | 105.4062 | 104.5938 | 105.1562 | 103000.0 |
| 2000-02-14 11:00:00 | DIA | ETF | 105.1875 | 105.5938 | 105.0938 | 105.4688 | 91100.0 |
| 2000-02-14 11:30:00 | DIA | ETF | 105.4688 | 105.5938 | 105.1875 | 105.5625 | 113200.0 |
| 2000-02-14 12:00:00 | DIA | ETF | 105.5 | 105.5625 | 105.125 | 105.2188 | 280900.0 |
| 2000-02-14 12:30:00 | DIA | ETF | 105.0625 | 105.2812 | 105.0 | 105.1875 | 24500.0 |
| 2000-02-14 13:00:00 | DIA | ETF | 105.0312 | 105.2812 | 104.7812 | 104.8125 | 68100.0 |
| 2000-02-14 13:30:00 | DIA | ETF | 104.8125 | 105.3125 | 104.75 | 105.25 | 15000.0 |
| 2000-02-14 14:00:00 | DIA | ETF | 105.125 | 105.1562 | 104.8125 | 105.0938 | 14600.0 |
| 2000-02-14 14:30:00 | DIA | ETF | 105.0 | 105.1562 | 104.5625 | 104.8438 | 20600.0 |
| 2000-02-14 15:00:00 | DIA | ETF | 104.6875 | 105.375 | 104.6875 | 105.1875 | 58900.0 |
| 2000-02-14 15:30:00 | DIA | ETF | 105.1875 | 105.375 | 105.0938 | 105.3438 | 104400.0 |
| 2000-02-14 16:00:00 | DIA | ETF | 105.375 | 105.5625 | 105.25 | 105.5 | 24300.0 |
> showing 43 of 215 rows — these rows as CSV