PREVIEW / etf_30min / 2000-08-08
file: by_date/etf_30min/2000/2000-08-08.parquet size: 10 KB rows: 264
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-08-08 09:30:00 | SPY | ETF | 147.5 | 147.9375 | 147.5 | 147.9375 | 717200.0 |
| 2000-08-08 10:00:00 | SPY | ETF | 147.9688 | 148.4062 | 147.7188 | 148.125 | 457800.0 |
| 2000-08-08 10:30:00 | SPY | ETF | 148.1875 | 148.3125 | 147.9375 | 148.0 | 325400.0 |
| 2000-08-08 11:00:00 | SPY | ETF | 148.0625 | 148.125 | 147.75 | 147.9375 | 108600.0 |
| 2000-08-08 11:30:00 | SPY | ETF | 147.875 | 148.4688 | 147.875 | 148.3125 | 163900.0 |
| 2000-08-08 12:00:00 | SPY | ETF | 148.3125 | 148.4688 | 148.1875 | 148.375 | 70700.0 |
| 2000-08-08 12:30:00 | SPY | ETF | 148.3125 | 148.4062 | 148.1562 | 148.3438 | 124400.0 |
| 2000-08-08 13:00:00 | SPY | ETF | 148.3125 | 148.375 | 148.0 | 148.0 | 62000.0 |
| 2000-08-08 13:30:00 | SPY | ETF | 148.0625 | 148.375 | 147.9375 | 148.375 | 153800.0 |
| 2000-08-08 14:00:00 | SPY | ETF | 148.375 | 148.5938 | 148.2188 | 148.2812 | 246900.0 |
| 2000-08-08 14:30:00 | SPY | ETF | 148.3125 | 148.6562 | 148.1875 | 148.5 | 283600.0 |
| 2000-08-08 15:00:00 | SPY | ETF | 148.5625 | 148.8125 | 148.4375 | 148.5625 | 179900.0 |
| 2000-08-08 15:30:00 | SPY | ETF | 148.4375 | 148.75 | 148.375 | 148.5625 | 252800.0 |
| 2000-08-08 16:00:00 | SPY | ETF | 148.5625 | 148.7188 | 148.5312 | 148.6875 | 506500.0 |
| 2000-08-08 09:30:00 | QQQ | ETF | 92.0625 | 92.8125 | 91.8125 | 92.6562 | 2478900.0 |
| 2000-08-08 10:00:00 | QQQ | ETF | 92.6875 | 93.4375 | 92.5 | 93.0938 | 1576300.0 |
| 2000-08-08 10:30:00 | QQQ | ETF | 93.0625 | 93.25 | 92.25 | 92.25 | 1174100.0 |
| 2000-08-08 11:00:00 | QQQ | ETF | 92.2812 | 92.5938 | 91.75 | 92.2812 | 1413100.0 |
| 2000-08-08 11:30:00 | QQQ | ETF | 92.2812 | 92.6875 | 92.0625 | 92.4375 | 655800.0 |
| 2000-08-08 12:00:00 | QQQ | ETF | 92.4375 | 92.7812 | 92.25 | 92.5625 | 356700.0 |
| 2000-08-08 12:30:00 | QQQ | ETF | 92.5 | 92.6562 | 92.0 | 92.125 | 657600.0 |
| 2000-08-08 13:00:00 | QQQ | ETF | 92.125 | 92.2812 | 91.625 | 91.75 | 854400.0 |
| 2000-08-08 13:30:00 | QQQ | ETF | 91.625 | 92.125 | 91.5 | 92.0312 | 892500.0 |
| 2000-08-08 14:00:00 | QQQ | ETF | 92.0312 | 92.25 | 91.6875 | 91.75 | 547700.0 |
| 2000-08-08 14:30:00 | QQQ | ETF | 91.75 | 92.25 | 91.625 | 92.1875 | 769800.0 |
| 2000-08-08 15:00:00 | QQQ | ETF | 92.1562 | 92.6562 | 91.6875 | 91.75 | 1240200.0 |
| 2000-08-08 15:30:00 | QQQ | ETF | 91.7812 | 92.2188 | 91.5 | 92.0625 | 1183400.0 |
| 2000-08-08 16:00:00 | QQQ | ETF | 92.0938 | 93.0 | 91.9062 | 92.625 | 711600.0 |
| 2000-08-08 16:30:00 | QQQ | ETF | 93.0 | 93.375 | 92.625 | 93.0 | 115300.0 |
| 2000-08-08 17:00:00 | QQQ | ETF | 93.0625 | 93.1875 | 92.875 | 93.125 | 17300.0 |
| 2000-08-08 17:30:00 | QQQ | ETF | 93.0625 | 93.625 | 93.0625 | 93.625 | 22300.0 |
| 2000-08-08 18:00:00 | QQQ | ETF | 93.75 | 94.125 | 93.5625 | 94.125 | 22900.0 |
| 2000-08-08 09:30:00 | IWM | ETF | 51.0 | 51.0 | 50.9062 | 50.9062 | 5000.0 |
| 2000-08-08 10:00:00 | IWM | ETF | 51.0312 | 51.1562 | 51.0312 | 51.1562 | 15000.0 |
| 2000-08-08 10:30:00 | IWM | ETF | 51.0938 | 51.0938 | 51.0938 | 51.0938 | 400.0 |
| 2000-08-08 11:00:00 | IWM | ETF | 51.125 | 51.125 | 51.125 | 51.125 | 20000.0 |
| 2000-08-08 12:00:00 | IWM | ETF | 51.0 | 51.1094 | 51.0 | 51.1094 | 1800.0 |
| 2000-08-08 13:30:00 | IWM | ETF | 51.0312 | 51.0938 | 51.0312 | 51.0938 | 1800.0 |
| 2000-08-08 14:00:00 | IWM | ETF | 51.1094 | 51.1094 | 51.1094 | 51.1094 | 1000.0 |
| 2000-08-08 14:30:00 | IWM | ETF | 51.0 | 51.0 | 51.0 | 51.0 | 800.0 |
| 2000-08-08 15:30:00 | IWM | ETF | 51.1094 | 51.1094 | 50.9375 | 50.9375 | 3200.0 |
| 2000-08-08 16:00:00 | IWM | ETF | 50.9062 | 50.9062 | 50.9062 | 50.9062 | 600.0 |
| 2000-08-08 09:30:00 | DIA | ETF | 108.5625 | 108.9375 | 108.3438 | 108.9062 | 154700.0 |
| 2000-08-08 10:00:00 | DIA | ETF | 109.0 | 109.1562 | 108.8125 | 109.0625 | 52900.0 |
| 2000-08-08 10:30:00 | DIA | ETF | 109.0625 | 109.0938 | 108.8125 | 108.8438 | 17000.0 |
| 2000-08-08 11:00:00 | DIA | ETF | 108.9375 | 109.0 | 108.8125 | 108.9375 | 38900.0 |
| 2000-08-08 11:30:00 | DIA | ETF | 108.9375 | 109.3125 | 108.8125 | 109.3125 | 44400.0 |
| 2000-08-08 12:00:00 | DIA | ETF | 109.1875 | 109.3438 | 108.9688 | 109.2812 | 10800.0 |
| 2000-08-08 12:30:00 | DIA | ETF | 109.25 | 109.2812 | 108.9688 | 109.0938 | 4200.0 |
| 2000-08-08 13:00:00 | DIA | ETF | 109.0625 | 109.25 | 108.9375 | 109.0938 | 43000.0 |
> showing 50 of 264 rows — these rows as CSV