PREVIEW / etf_30min / 2000-12-21
file: by_date/etf_30min/2000/2000-12-21.parquet size: 13 KB rows: 330
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-12-21 09:30:00 | SPY | ETF | 126.0 | 127.3125 | 126.0 | 126.3125 | 2384900.0 |
| 2000-12-21 10:00:00 | SPY | ETF | 126.375 | 126.6875 | 125.5312 | 126.625 | 1477400.0 |
| 2000-12-21 10:30:00 | SPY | ETF | 126.6562 | 127.0 | 126.0 | 127.0 | 915700.0 |
| 2000-12-21 11:00:00 | SPY | ETF | 126.8438 | 127.7188 | 126.5625 | 127.6875 | 1063800.0 |
| 2000-12-21 11:30:00 | SPY | ETF | 127.7188 | 128.8438 | 127.5938 | 128.8438 | 964300.0 |
| 2000-12-21 12:00:00 | SPY | ETF | 128.8125 | 128.8438 | 127.6875 | 128.0312 | 803400.0 |
| 2000-12-21 12:30:00 | SPY | ETF | 128.1875 | 128.75 | 128.0938 | 128.375 | 788400.0 |
| 2000-12-21 13:00:00 | SPY | ETF | 128.3438 | 128.6875 | 128.0312 | 128.2188 | 514000.0 |
| 2000-12-21 13:30:00 | SPY | ETF | 128.2188 | 128.7188 | 127.75 | 127.75 | 577500.0 |
| 2000-12-21 14:00:00 | SPY | ETF | 127.9062 | 128.0625 | 127.0312 | 127.7188 | 687000.0 |
| 2000-12-21 14:30:00 | SPY | ETF | 127.75 | 127.8438 | 126.6875 | 127.0 | 821500.0 |
| 2000-12-21 15:00:00 | SPY | ETF | 126.9375 | 128.0938 | 126.7812 | 127.8125 | 762300.0 |
| 2000-12-21 15:30:00 | SPY | ETF | 127.75 | 127.9688 | 127.0625 | 127.6875 | 1044700.0 |
| 2000-12-21 16:00:00 | SPY | ETF | 127.75 | 127.875 | 126.7812 | 127.875 | 485000.0 |
| 2000-12-21 09:30:00 | QQQ | ETF | 55.0312 | 56.7188 | 54.9375 | 55.25 | 9491000.0 |
| 2000-12-21 10:00:00 | QQQ | ETF | 55.125 | 56.125 | 54.25 | 55.25 | 8398700.0 |
| 2000-12-21 10:30:00 | QQQ | ETF | 55.25 | 56.3125 | 54.75 | 56.2188 | 6202000.0 |
| 2000-12-21 11:00:00 | QQQ | ETF | 56.1875 | 57.6875 | 55.8125 | 57.5 | 8407800.0 |
| 2000-12-21 11:30:00 | QQQ | ETF | 57.5 | 58.7188 | 57.375 | 58.4375 | 9197500.0 |
| 2000-12-21 12:00:00 | QQQ | ETF | 58.4375 | 58.5 | 57.0 | 57.3125 | 5135700.0 |
| 2000-12-21 12:30:00 | QQQ | ETF | 57.4062 | 58.2188 | 57.3125 | 57.5 | 3163300.0 |
| 2000-12-21 13:00:00 | QQQ | ETF | 57.625 | 58.1875 | 57.1875 | 57.625 | 1876700.0 |
| 2000-12-21 13:30:00 | QQQ | ETF | 57.5625 | 57.9375 | 56.5 | 56.5938 | 2406000.0 |
| 2000-12-21 14:00:00 | QQQ | ETF | 56.5 | 56.8125 | 55.0625 | 55.8125 | 6472900.0 |
| 2000-12-21 14:30:00 | QQQ | ETF | 55.8438 | 56.125 | 54.5 | 54.8125 | 5922800.0 |
| 2000-12-21 15:00:00 | QQQ | ETF | 54.8125 | 56.3125 | 54.75 | 56.0 | 7307800.0 |
| 2000-12-21 15:30:00 | QQQ | ETF | 56.0312 | 56.3125 | 54.875 | 55.8125 | 5100100.0 |
| 2000-12-21 16:00:00 | QQQ | ETF | 55.7188 | 57.5 | 55.5 | 56.25 | 886500.0 |
| 2000-12-21 16:30:00 | QQQ | ETF | 56.1875 | 56.875 | 56.0 | 56.8125 | 227800.0 |
| 2000-12-21 17:00:00 | QQQ | ETF | 56.8125 | 56.9375 | 56.6875 | 56.75 | 211900.0 |
| 2000-12-21 17:30:00 | QQQ | ETF | 56.75 | 56.875 | 56.5 | 56.625 | 118300.0 |
| 2000-12-21 18:00:00 | QQQ | ETF | 56.625 | 56.875 | 56.625 | 56.75 | 8500.0 |
| 2000-12-21 09:30:00 | IWM | ETF | 44.0625 | 44.2812 | 43.9062 | 43.9062 | 18000.0 |
| 2000-12-21 10:00:00 | IWM | ETF | 44.0312 | 44.0312 | 43.75 | 44.0 | 3600.0 |
| 2000-12-21 10:30:00 | IWM | ETF | 44.0 | 44.0938 | 43.9688 | 44.0156 | 33800.0 |
| 2000-12-21 11:00:00 | IWM | ETF | 44.125 | 44.3125 | 44.0312 | 44.1875 | 18400.0 |
| 2000-12-21 11:30:00 | IWM | ETF | 44.3594 | 44.6875 | 44.3438 | 44.6875 | 65800.0 |
| 2000-12-21 12:00:00 | IWM | ETF | 44.6875 | 44.6875 | 44.4688 | 44.4688 | 7200.0 |
| 2000-12-21 12:30:00 | IWM | ETF | 44.5625 | 44.8125 | 44.5 | 44.8125 | 32200.0 |
| 2000-12-21 13:00:00 | IWM | ETF | 44.8125 | 44.9219 | 44.6875 | 44.6875 | 4000.0 |
| 2000-12-21 13:30:00 | IWM | ETF | 44.9219 | 44.9531 | 44.7969 | 44.7969 | 28400.0 |
| 2000-12-21 14:00:00 | IWM | ETF | 44.9062 | 44.9062 | 44.7188 | 44.7188 | 29000.0 |
| 2000-12-21 14:30:00 | IWM | ETF | 44.6562 | 44.6562 | 44.4219 | 44.4688 | 16000.0 |
| 2000-12-21 15:00:00 | IWM | ETF | 44.3281 | 44.5781 | 44.3281 | 44.5781 | 5600.0 |
| 2000-12-21 15:30:00 | IWM | ETF | 44.625 | 44.6875 | 44.4062 | 44.6875 | 25000.0 |
| 2000-12-21 16:00:00 | IWM | ETF | 44.4062 | 44.4062 | 44.4062 | 44.4062 | 94800.0 |
| 2000-12-21 09:30:00 | DIA | ETF | 102.8438 | 103.9062 | 102.8438 | 103.375 | 305200.0 |
| 2000-12-21 10:00:00 | DIA | ETF | 103.4688 | 103.75 | 102.7812 | 103.375 | 359500.0 |
| 2000-12-21 10:30:00 | DIA | ETF | 103.5938 | 104.0312 | 103.3438 | 103.75 | 196200.0 |
| 2000-12-21 11:00:00 | DIA | ETF | 103.75 | 104.1875 | 103.4688 | 104.0938 | 174100.0 |
> showing 50 of 330 rows — these rows as CSV