PREVIEW / etf_30min / 2000-02-15
file: by_date/etf_30min/2000/2000-02-15.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-15 09:30:00 | SPY | ETF | 139.25 | 139.5 | 138.6562 | 139.125 | 536100.0 |
| 2000-02-15 10:00:00 | SPY | ETF | 139.125 | 139.1562 | 138.375 | 138.625 | 1022700.0 |
| 2000-02-15 10:30:00 | SPY | ETF | 138.5625 | 139.1875 | 138.2188 | 139.0625 | 1090400.0 |
| 2000-02-15 11:00:00 | SPY | ETF | 138.9375 | 139.0938 | 137.7812 | 137.7812 | 659200.0 |
| 2000-02-15 11:30:00 | SPY | ETF | 138.0 | 138.6562 | 137.875 | 138.5 | 670900.0 |
| 2000-02-15 12:00:00 | SPY | ETF | 138.5 | 138.75 | 138.3125 | 138.625 | 274500.0 |
| 2000-02-15 12:30:00 | SPY | ETF | 138.5625 | 139.25 | 138.4062 | 138.9062 | 291500.0 |
| 2000-02-15 13:00:00 | SPY | ETF | 139.0 | 139.375 | 138.875 | 139.375 | 410400.0 |
| 2000-02-15 13:30:00 | SPY | ETF | 139.25 | 139.375 | 138.9062 | 139.0 | 114900.0 |
| 2000-02-15 14:00:00 | SPY | ETF | 139.0 | 139.75 | 138.9062 | 139.5625 | 653300.0 |
| 2000-02-15 14:30:00 | SPY | ETF | 139.5938 | 140.6562 | 139.4375 | 140.4688 | 1749200.0 |
| 2000-02-15 15:00:00 | SPY | ETF | 140.4375 | 141.1875 | 140.1562 | 140.8438 | 872900.0 |
| 2000-02-15 15:30:00 | SPY | ETF | 140.8125 | 141.2188 | 140.4062 | 140.75 | 1318200.0 |
| 2000-02-15 16:00:00 | SPY | ETF | 140.75 | 141.0938 | 140.4375 | 141.0938 | 1270800.0 |
| 2000-02-15 09:30:00 | QQQ | ETF | 98.9375 | 99.375 | 98.1562 | 98.375 | 2072000.0 |
| 2000-02-15 10:00:00 | QQQ | ETF | 98.4062 | 98.5625 | 97.25 | 97.6875 | 3197000.0 |
| 2000-02-15 10:30:00 | QQQ | ETF | 97.6094 | 97.8125 | 96.75 | 97.5625 | 2925200.0 |
| 2000-02-15 11:00:00 | QQQ | ETF | 97.5312 | 97.5312 | 96.0 | 96.0156 | 2842200.0 |
| 2000-02-15 11:30:00 | QQQ | ETF | 96.0625 | 97.125 | 95.875 | 96.6562 | 1649400.0 |
| 2000-02-15 12:00:00 | QQQ | ETF | 96.6875 | 97.0625 | 96.375 | 96.7188 | 1314600.0 |
| 2000-02-15 12:30:00 | QQQ | ETF | 96.7188 | 97.5625 | 96.5625 | 97.2812 | 2093600.0 |
| 2000-02-15 13:00:00 | QQQ | ETF | 97.1875 | 97.6875 | 97.0312 | 97.4062 | 904600.0 |
| 2000-02-15 13:30:00 | QQQ | ETF | 97.4531 | 97.5 | 96.7656 | 96.8125 | 937200.0 |
| 2000-02-15 14:00:00 | QQQ | ETF | 96.8125 | 98.0625 | 96.8125 | 97.9375 | 1402200.0 |
| 2000-02-15 14:30:00 | QQQ | ETF | 97.9375 | 99.75 | 97.8125 | 99.5 | 4177600.0 |
| 2000-02-15 15:00:00 | QQQ | ETF | 99.5625 | 100.5 | 99.0625 | 100.3125 | 3508400.0 |
| 2000-02-15 15:30:00 | QQQ | ETF | 100.3125 | 100.625 | 99.3125 | 99.875 | 2705000.0 |
| 2000-02-15 16:00:00 | QQQ | ETF | 99.8438 | 100.3438 | 99.6562 | 100.25 | 686800.0 |
| 2000-02-15 16:30:00 | QQQ | ETF | 100.0625 | 100.25 | 100.0625 | 100.25 | 1400.0 |
| 2000-02-15 17:30:00 | QQQ | ETF | 100.4688 | 100.4688 | 100.4688 | 100.4688 | 200.0 |
| 2000-02-15 09:30:00 | DIA | ETF | 105.5938 | 105.75 | 105.25 | 105.75 | 129800.0 |
| 2000-02-15 10:00:00 | DIA | ETF | 105.7812 | 105.875 | 105.25 | 105.5938 | 113800.0 |
| 2000-02-15 10:30:00 | DIA | ETF | 105.625 | 106.0 | 105.25 | 106.0 | 82900.0 |
| 2000-02-15 11:00:00 | DIA | ETF | 105.9062 | 105.9688 | 105.0312 | 105.0312 | 31200.0 |
| 2000-02-15 11:30:00 | DIA | ETF | 105.0312 | 105.6562 | 105.0312 | 105.6562 | 142700.0 |
| 2000-02-15 12:00:00 | DIA | ETF | 105.75 | 105.8125 | 105.5 | 105.75 | 34600.0 |
| 2000-02-15 12:30:00 | DIA | ETF | 105.625 | 106.25 | 105.625 | 105.875 | 46000.0 |
| 2000-02-15 13:00:00 | DIA | ETF | 106.0 | 106.4688 | 105.875 | 106.4062 | 74500.0 |
| 2000-02-15 13:30:00 | DIA | ETF | 106.4375 | 106.5 | 106.25 | 106.25 | 48000.0 |
| 2000-02-15 14:00:00 | DIA | ETF | 106.25 | 107.0 | 106.25 | 106.875 | 163700.0 |
| 2000-02-15 14:30:00 | DIA | ETF | 106.875 | 107.3125 | 106.5312 | 107.0938 | 146500.0 |
| 2000-02-15 15:00:00 | DIA | ETF | 107.25 | 107.875 | 107.125 | 107.5 | 227800.0 |
| 2000-02-15 15:30:00 | DIA | ETF | 107.5625 | 107.6875 | 107.2188 | 107.4688 | 110000.0 |
| 2000-02-15 16:00:00 | DIA | ETF | 107.4688 | 107.4688 | 107.375 | 107.4375 | 8000.0 |
> showing 44 of 215 rows — these rows as CSV