PREVIEW / etf_30min / 2000-08-21
file: by_date/etf_30min/2000/2000-08-21.parquet size: 11 KB rows: 268
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-21 09:30:00 | SPY | ETF | 150.0312 | 150.25 | 149.875 | 150.125 | 308600.0 |
| 2000-08-21 10:00:00 | SPY | ETF | 150.125 | 150.3438 | 150.0 | 150.1875 | 96800.0 |
| 2000-08-21 10:30:00 | SPY | ETF | 150.25 | 150.6875 | 150.0312 | 150.4688 | 102400.0 |
| 2000-08-21 11:00:00 | SPY | ETF | 150.5625 | 150.6875 | 150.4375 | 150.4688 | 108500.0 |
| 2000-08-21 11:30:00 | SPY | ETF | 150.5938 | 150.7188 | 150.375 | 150.5 | 144000.0 |
| 2000-08-21 12:00:00 | SPY | ETF | 150.375 | 150.5625 | 150.3438 | 150.4375 | 60400.0 |
| 2000-08-21 12:30:00 | SPY | ETF | 150.4688 | 150.5625 | 150.1875 | 150.25 | 53900.0 |
| 2000-08-21 13:00:00 | SPY | ETF | 150.3438 | 150.3438 | 150.0625 | 150.1875 | 84700.0 |
| 2000-08-21 13:30:00 | SPY | ETF | 150.125 | 150.25 | 149.7812 | 149.875 | 130700.0 |
| 2000-08-21 14:00:00 | SPY | ETF | 149.7812 | 150.0938 | 149.625 | 149.625 | 255400.0 |
| 2000-08-21 14:30:00 | SPY | ETF | 149.625 | 149.8125 | 149.4062 | 149.5625 | 139500.0 |
| 2000-08-21 15:00:00 | SPY | ETF | 149.625 | 149.9688 | 149.4375 | 149.8438 | 177200.0 |
| 2000-08-21 15:30:00 | SPY | ETF | 149.875 | 150.4375 | 149.7812 | 150.3438 | 350100.0 |
| 2000-08-21 16:00:00 | SPY | ETF | 150.375 | 150.5625 | 150.25 | 150.5625 | 322000.0 |
| 2000-08-21 17:00:00 | SPY | ETF | 150.5 | 150.5 | 150.5 | 150.5 | 400.0 |
| 2000-08-21 09:30:00 | QQQ | ETF | 96.0 | 96.0938 | 95.25 | 95.875 | 1516100.0 |
| 2000-08-21 10:00:00 | QQQ | ETF | 95.9375 | 96.4375 | 95.7812 | 96.1875 | 1192700.0 |
| 2000-08-21 10:30:00 | QQQ | ETF | 96.1562 | 96.6875 | 95.9375 | 96.4062 | 1182800.0 |
| 2000-08-21 11:00:00 | QQQ | ETF | 96.5 | 96.6875 | 96.3125 | 96.5 | 435400.0 |
| 2000-08-21 11:30:00 | QQQ | ETF | 96.5 | 96.6562 | 96.375 | 96.4062 | 790100.0 |
| 2000-08-21 12:00:00 | QQQ | ETF | 96.5 | 96.7188 | 96.3125 | 96.625 | 370200.0 |
| 2000-08-21 12:30:00 | QQQ | ETF | 96.625 | 96.8438 | 96.0312 | 96.125 | 562100.0 |
| 2000-08-21 13:00:00 | QQQ | ETF | 96.125 | 96.1875 | 95.8125 | 96.0938 | 694800.0 |
| 2000-08-21 13:30:00 | QQQ | ETF | 96.125 | 96.1562 | 94.7812 | 95.0 | 1361400.0 |
| 2000-08-21 14:00:00 | QQQ | ETF | 94.875 | 95.4375 | 94.6875 | 94.6875 | 862500.0 |
| 2000-08-21 14:30:00 | QQQ | ETF | 94.625 | 94.9062 | 94.375 | 94.625 | 1193500.0 |
| 2000-08-21 15:00:00 | QQQ | ETF | 94.5625 | 95.1875 | 94.375 | 94.9375 | 1476500.0 |
| 2000-08-21 15:30:00 | QQQ | ETF | 94.9688 | 95.5625 | 94.875 | 95.5 | 1343700.0 |
| 2000-08-21 16:00:00 | QQQ | ETF | 95.5312 | 95.75 | 95.0625 | 95.6875 | 546400.0 |
| 2000-08-21 16:30:00 | QQQ | ETF | 95.5625 | 95.5625 | 95.5 | 95.5 | 3900.0 |
| 2000-08-21 17:00:00 | QQQ | ETF | 95.875 | 95.875 | 95.625 | 95.625 | 1800.0 |
| 2000-08-21 17:30:00 | QQQ | ETF | 95.5 | 95.5 | 95.5 | 95.5 | 1000.0 |
| 2000-08-21 18:00:00 | QQQ | ETF | 95.5 | 95.5 | 95.5 | 95.5 | 5000.0 |
| 2000-08-21 09:30:00 | IWM | ETF | 51.875 | 51.875 | 51.875 | 51.875 | 2800.0 |
| 2000-08-21 10:00:00 | IWM | ETF | 51.8438 | 51.8906 | 51.8438 | 51.8906 | 1200.0 |
| 2000-08-21 10:30:00 | IWM | ETF | 51.8594 | 51.9219 | 51.8594 | 51.9219 | 1600.0 |
| 2000-08-21 11:30:00 | IWM | ETF | 51.875 | 51.8906 | 51.875 | 51.8906 | 5600.0 |
| 2000-08-21 12:30:00 | IWM | ETF | 51.9062 | 51.9062 | 51.9062 | 51.9062 | 37800.0 |
| 2000-08-21 13:00:00 | IWM | ETF | 51.8906 | 51.8906 | 51.6875 | 51.8281 | 600.0 |
| 2000-08-21 13:30:00 | IWM | ETF | 51.7188 | 51.75 | 51.6094 | 51.6094 | 2800.0 |
| 2000-08-21 14:00:00 | IWM | ETF | 51.625 | 51.8125 | 51.625 | 51.7656 | 3800.0 |
| 2000-08-21 14:30:00 | IWM | ETF | 51.4375 | 51.5312 | 51.4062 | 51.5312 | 20400.0 |
| 2000-08-21 15:00:00 | IWM | ETF | 51.5938 | 51.5938 | 51.5938 | 51.5938 | 2000.0 |
| 2000-08-21 15:30:00 | IWM | ETF | 51.5 | 51.7344 | 51.5 | 51.7344 | 50600.0 |
| 2000-08-21 09:30:00 | DIA | ETF | 110.9375 | 111.0625 | 110.6562 | 110.7812 | 215600.0 |
| 2000-08-21 10:00:00 | DIA | ETF | 110.9375 | 110.9375 | 110.6875 | 110.7812 | 122600.0 |
| 2000-08-21 10:30:00 | DIA | ETF | 110.75 | 111.0312 | 110.6875 | 110.875 | 15100.0 |
| 2000-08-21 11:00:00 | DIA | ETF | 111.0312 | 111.0938 | 110.8125 | 111.0312 | 34200.0 |
| 2000-08-21 11:30:00 | DIA | ETF | 111.0625 | 111.125 | 110.875 | 110.9062 | 36600.0 |
| 2000-08-21 12:00:00 | DIA | ETF | 110.9062 | 111.0 | 110.7812 | 110.9375 | 29900.0 |
> showing 50 of 268 rows — these rows as CSV