PREVIEW / etf_30min / 2000-02-03
file: by_date/etf_30min/2000/2000-02-03.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-03 09:30:00 | SPY | ETF | 140.875 | 142.4062 | 140.875 | 142.0 | 791300.0 |
| 2000-02-03 10:00:00 | SPY | ETF | 142.0625 | 142.125 | 141.25 | 141.75 | 400100.0 |
| 2000-02-03 10:30:00 | SPY | ETF | 141.8438 | 142.0625 | 141.5625 | 142.0625 | 241000.0 |
| 2000-02-03 11:00:00 | SPY | ETF | 142.125 | 142.2812 | 141.5 | 141.6875 | 338500.0 |
| 2000-02-03 11:30:00 | SPY | ETF | 141.5625 | 141.875 | 141.0625 | 141.0938 | 312300.0 |
| 2000-02-03 12:00:00 | SPY | ETF | 141.0625 | 141.1875 | 140.0312 | 140.125 | 1209800.0 |
| 2000-02-03 12:30:00 | SPY | ETF | 140.125 | 141.5938 | 140.0 | 141.5625 | 1199200.0 |
| 2000-02-03 13:00:00 | SPY | ETF | 141.5625 | 142.0938 | 141.3438 | 141.9062 | 639500.0 |
| 2000-02-03 13:30:00 | SPY | ETF | 141.9375 | 142.125 | 141.5625 | 141.9688 | 113200.0 |
| 2000-02-03 14:00:00 | SPY | ETF | 141.8125 | 142.1562 | 141.4375 | 142.125 | 208800.0 |
| 2000-02-03 14:30:00 | SPY | ETF | 142.125 | 142.9688 | 141.9375 | 142.7188 | 686200.0 |
| 2000-02-03 15:00:00 | SPY | ETF | 142.7188 | 142.875 | 142.0625 | 142.2812 | 551800.0 |
| 2000-02-03 15:30:00 | SPY | ETF | 142.4688 | 142.8438 | 141.75 | 142.8438 | 594300.0 |
| 2000-02-03 16:00:00 | SPY | ETF | 142.6875 | 143.25 | 142.6875 | 143.1875 | 549100.0 |
| 2000-02-03 09:30:00 | QQQ | ETF | 94.3125 | 94.9375 | 94.0312 | 94.625 | 3117200.0 |
| 2000-02-03 10:00:00 | QQQ | ETF | 94.625 | 95.0 | 93.9219 | 94.4375 | 2443000.0 |
| 2000-02-03 10:30:00 | QQQ | ETF | 94.4375 | 94.9688 | 94.0938 | 94.9375 | 1365000.0 |
| 2000-02-03 11:00:00 | QQQ | ETF | 94.9375 | 95.3125 | 94.7656 | 94.8125 | 2130600.0 |
| 2000-02-03 11:30:00 | QQQ | ETF | 94.8438 | 94.9062 | 93.9375 | 94.0 | 1763800.0 |
| 2000-02-03 12:00:00 | QQQ | ETF | 93.9375 | 94.125 | 92.875 | 92.875 | 2719000.0 |
| 2000-02-03 12:30:00 | QQQ | ETF | 92.875 | 94.4375 | 92.2812 | 94.125 | 3832200.0 |
| 2000-02-03 13:00:00 | QQQ | ETF | 94.0469 | 94.75 | 94.0312 | 94.5156 | 1697400.0 |
| 2000-02-03 13:30:00 | QQQ | ETF | 94.5625 | 94.8594 | 94.375 | 94.7344 | 1205200.0 |
| 2000-02-03 14:00:00 | QQQ | ETF | 94.7188 | 94.8438 | 94.3125 | 94.75 | 1183800.0 |
| 2000-02-03 14:30:00 | QQQ | ETF | 94.7812 | 96.125 | 94.75 | 95.7656 | 3023600.0 |
| 2000-02-03 15:00:00 | QQQ | ETF | 95.7656 | 96.4375 | 95.5 | 96.125 | 2458200.0 |
| 2000-02-03 15:30:00 | QQQ | ETF | 96.125 | 96.25 | 95.2812 | 96.125 | 2369000.0 |
| 2000-02-03 16:00:00 | QQQ | ETF | 96.125 | 96.5938 | 96.0156 | 96.4375 | 947400.0 |
| 2000-02-03 16:30:00 | QQQ | ETF | 96.5 | 96.5 | 96.125 | 96.125 | 1200.0 |
| 2000-02-03 17:30:00 | QQQ | ETF | 96.375 | 96.375 | 96.375 | 96.375 | 200.0 |
| 2000-02-03 18:00:00 | QQQ | ETF | 96.5 | 96.5 | 96.5 | 96.5 | 1000.0 |
| 2000-02-03 09:30:00 | DIA | ETF | 110.625 | 110.6562 | 110.0312 | 110.2188 | 155100.0 |
| 2000-02-03 10:00:00 | DIA | ETF | 110.4062 | 110.4062 | 109.6562 | 109.9375 | 96200.0 |
| 2000-02-03 10:30:00 | DIA | ETF | 110.0 | 110.1562 | 109.875 | 110.0938 | 50100.0 |
| 2000-02-03 11:00:00 | DIA | ETF | 110.125 | 110.2812 | 109.5938 | 109.6875 | 28500.0 |
| 2000-02-03 11:30:00 | DIA | ETF | 109.8125 | 109.8125 | 109.1562 | 109.4062 | 84700.0 |
| 2000-02-03 12:00:00 | DIA | ETF | 109.125 | 109.4062 | 108.5 | 108.5 | 29900.0 |
| 2000-02-03 12:30:00 | DIA | ETF | 108.25 | 109.5 | 108.2188 | 109.3125 | 77500.0 |
| 2000-02-03 13:00:00 | DIA | ETF | 109.4688 | 110.0 | 109.25 | 109.7188 | 44000.0 |
| 2000-02-03 13:30:00 | DIA | ETF | 109.75 | 110.0312 | 109.4688 | 109.7188 | 10200.0 |
| 2000-02-03 14:00:00 | DIA | ETF | 109.75 | 109.8125 | 109.5 | 109.625 | 31400.0 |
| 2000-02-03 14:30:00 | DIA | ETF | 109.75 | 110.5938 | 109.75 | 110.2188 | 105500.0 |
| 2000-02-03 15:00:00 | DIA | ETF | 110.125 | 110.5312 | 109.8125 | 110.0625 | 20800.0 |
| 2000-02-03 15:30:00 | DIA | ETF | 110.125 | 110.1875 | 109.5312 | 110.0312 | 121000.0 |
| 2000-02-03 16:00:00 | DIA | ETF | 110.1875 | 110.5 | 110.1875 | 110.5 | 7200.0 |
> showing 45 of 215 rows — these rows as CSV