PREVIEW / etf_30min / 2000-08-24
file: by_date/etf_30min/2000/2000-08-24.parquet size: 11 KB rows: 266
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-24 09:30:00 | SPY | ETF | 151.1562 | 151.1875 | 150.6875 | 151.125 | 1003200.0 |
| 2000-08-24 10:00:00 | SPY | ETF | 151.1875 | 151.4062 | 150.875 | 150.9688 | 546900.0 |
| 2000-08-24 10:30:00 | SPY | ETF | 150.8125 | 150.9062 | 150.5 | 150.8125 | 858300.0 |
| 2000-08-24 11:00:00 | SPY | ETF | 150.8438 | 151.0 | 150.5625 | 150.8438 | 120700.0 |
| 2000-08-24 11:30:00 | SPY | ETF | 150.875 | 150.9375 | 150.6562 | 150.8438 | 177200.0 |
| 2000-08-24 12:00:00 | SPY | ETF | 150.8438 | 151.1562 | 150.75 | 151.0312 | 265600.0 |
| 2000-08-24 12:30:00 | SPY | ETF | 151.0938 | 151.1562 | 151.0 | 151.0 | 46300.0 |
| 2000-08-24 13:00:00 | SPY | ETF | 151.0625 | 151.3125 | 151.0 | 151.25 | 200800.0 |
| 2000-08-24 13:30:00 | SPY | ETF | 151.1562 | 151.25 | 150.875 | 150.9688 | 51900.0 |
| 2000-08-24 14:00:00 | SPY | ETF | 150.9062 | 151.125 | 150.75 | 151.0 | 99500.0 |
| 2000-08-24 14:30:00 | SPY | ETF | 150.875 | 151.2812 | 150.875 | 151.1875 | 137700.0 |
| 2000-08-24 15:00:00 | SPY | ETF | 151.1875 | 151.5312 | 151.125 | 151.5 | 116000.0 |
| 2000-08-24 15:30:00 | SPY | ETF | 151.4688 | 151.5 | 151.125 | 151.4375 | 667100.0 |
| 2000-08-24 16:00:00 | SPY | ETF | 151.375 | 151.4062 | 151.0938 | 151.4062 | 212400.0 |
| 2000-08-24 16:30:00 | SPY | ETF | 151.3125 | 151.3125 | 151.3125 | 151.3125 | 500.0 |
| 2000-08-24 09:30:00 | QQQ | ETF | 97.4375 | 97.8125 | 96.8125 | 97.6875 | 2957200.0 |
| 2000-08-24 10:00:00 | QQQ | ETF | 97.6875 | 98.2812 | 97.5625 | 97.625 | 1581300.0 |
| 2000-08-24 10:30:00 | QQQ | ETF | 97.625 | 97.75 | 97.0 | 97.5312 | 1576400.0 |
| 2000-08-24 11:00:00 | QQQ | ETF | 97.5 | 97.875 | 97.3125 | 97.6562 | 558700.0 |
| 2000-08-24 11:30:00 | QQQ | ETF | 97.625 | 97.7812 | 97.4375 | 97.5625 | 266700.0 |
| 2000-08-24 12:00:00 | QQQ | ETF | 97.5625 | 98.125 | 97.5312 | 98.0 | 575200.0 |
| 2000-08-24 12:30:00 | QQQ | ETF | 98.0625 | 98.0938 | 97.75 | 97.75 | 233200.0 |
| 2000-08-24 13:00:00 | QQQ | ETF | 97.75 | 98.1875 | 97.75 | 98.0312 | 510600.0 |
| 2000-08-24 13:30:00 | QQQ | ETF | 98.0312 | 98.0938 | 97.5 | 97.5625 | 500500.0 |
| 2000-08-24 14:00:00 | QQQ | ETF | 97.625 | 97.8125 | 97.2812 | 97.5625 | 591400.0 |
| 2000-08-24 14:30:00 | QQQ | ETF | 97.6562 | 98.0938 | 97.5625 | 97.9375 | 530100.0 |
| 2000-08-24 15:00:00 | QQQ | ETF | 97.9375 | 98.625 | 97.875 | 98.375 | 1360800.0 |
| 2000-08-24 15:30:00 | QQQ | ETF | 98.4375 | 98.6875 | 98.125 | 98.5938 | 1959300.0 |
| 2000-08-24 16:00:00 | QQQ | ETF | 98.5938 | 98.6875 | 98.375 | 98.5625 | 329500.0 |
| 2000-08-24 16:30:00 | QQQ | ETF | 98.5625 | 98.5625 | 98.5 | 98.5 | 1600.0 |
| 2000-08-24 17:00:00 | QQQ | ETF | 98.625 | 98.625 | 98.5625 | 98.5625 | 400.0 |
| 2000-08-24 17:30:00 | QQQ | ETF | 98.5625 | 98.5625 | 98.5625 | 98.5625 | 500.0 |
| 2000-08-24 09:30:00 | IWM | ETF | 51.8594 | 51.8594 | 51.8594 | 51.8594 | 600.0 |
| 2000-08-24 10:00:00 | IWM | ETF | 52.1094 | 52.1875 | 52.1094 | 52.1875 | 1800.0 |
| 2000-08-24 10:30:00 | IWM | ETF | 52.1875 | 52.1875 | 52.0 | 52.0 | 5200.0 |
| 2000-08-24 11:00:00 | IWM | ETF | 52.1562 | 52.25 | 52.1562 | 52.25 | 1200.0 |
| 2000-08-24 11:30:00 | IWM | ETF | 52.2188 | 52.25 | 52.1875 | 52.1875 | 2400.0 |
| 2000-08-24 12:00:00 | IWM | ETF | 52.1875 | 52.3125 | 52.1875 | 52.3125 | 1200.0 |
| 2000-08-24 12:30:00 | IWM | ETF | 52.3281 | 52.375 | 52.1875 | 52.1875 | 2800.0 |
| 2000-08-24 13:30:00 | IWM | ETF | 52.4062 | 52.4375 | 52.3906 | 52.4375 | 2200.0 |
| 2000-08-24 14:00:00 | IWM | ETF | 52.3438 | 52.3438 | 52.1562 | 52.1562 | 600.0 |
| 2000-08-24 15:00:00 | IWM | ETF | 52.4688 | 52.5625 | 52.4688 | 52.5625 | 8000.0 |
| 2000-08-24 15:30:00 | IWM | ETF | 52.625 | 52.625 | 52.4219 | 52.4688 | 800.0 |
| 2000-08-24 16:00:00 | IWM | ETF | 52.5938 | 52.5938 | 52.3438 | 52.3438 | 249400.0 |
| 2000-08-24 09:30:00 | DIA | ETF | 111.4062 | 111.5938 | 111.1562 | 111.5938 | 21000.0 |
| 2000-08-24 10:00:00 | DIA | ETF | 111.5 | 111.7188 | 111.4375 | 111.4688 | 26200.0 |
| 2000-08-24 10:30:00 | DIA | ETF | 111.5 | 111.6562 | 111.3125 | 111.5938 | 20900.0 |
| 2000-08-24 11:00:00 | DIA | ETF | 111.375 | 111.7188 | 111.375 | 111.6562 | 20600.0 |
| 2000-08-24 11:30:00 | DIA | ETF | 111.4688 | 111.5938 | 111.4062 | 111.5 | 8300.0 |
| 2000-08-24 12:00:00 | DIA | ETF | 111.5 | 111.8125 | 111.5 | 111.7812 | 8600.0 |
> showing 50 of 266 rows — these rows as CSV