PREVIEW / etf_30min / 2000-11-24
file: by_date/etf_30min/2000/2000-11-24.parquet size: 8 KB rows: 143
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-11-24 09:30:00 | SPY | ETF | 133.625 | 134.25 | 133.625 | 134.0 | 1063000.0 |
| 2000-11-24 10:00:00 | SPY | ETF | 133.9688 | 134.625 | 133.9688 | 134.25 | 482200.0 |
| 2000-11-24 10:30:00 | SPY | ETF | 134.3438 | 134.5 | 134.0938 | 134.25 | 145100.0 |
| 2000-11-24 11:00:00 | SPY | ETF | 134.3125 | 134.5625 | 134.25 | 134.3438 | 209300.0 |
| 2000-11-24 11:30:00 | SPY | ETF | 134.3438 | 134.5938 | 134.25 | 134.25 | 184300.0 |
| 2000-11-24 12:00:00 | SPY | ETF | 134.2812 | 134.9688 | 134.2812 | 134.5625 | 423900.0 |
| 2000-11-24 12:30:00 | SPY | ETF | 134.6562 | 134.8125 | 134.2188 | 134.4375 | 683300.0 |
| 2000-11-24 13:00:00 | SPY | ETF | 134.5312 | 134.875 | 134.4062 | 134.8438 | 99500.0 |
| 2000-11-24 09:30:00 | QQQ | ETF | 68.375 | 69.1562 | 68.1562 | 68.9062 | 4595100.0 |
| 2000-11-24 10:00:00 | QQQ | ETF | 68.9375 | 69.75 | 68.75 | 69.3125 | 3605900.0 |
| 2000-11-24 10:30:00 | QQQ | ETF | 69.1875 | 69.5312 | 69.0 | 69.4688 | 1837800.0 |
| 2000-11-24 11:00:00 | QQQ | ETF | 69.4688 | 69.8125 | 69.3125 | 69.5938 | 1451500.0 |
| 2000-11-24 11:30:00 | QQQ | ETF | 69.625 | 70.125 | 69.375 | 69.625 | 2118000.0 |
| 2000-11-24 12:00:00 | QQQ | ETF | 69.6875 | 70.3125 | 69.625 | 69.875 | 2428500.0 |
| 2000-11-24 12:30:00 | QQQ | ETF | 69.875 | 70.5625 | 69.875 | 70.5 | 2866100.0 |
| 2000-11-24 13:00:00 | QQQ | ETF | 70.5625 | 70.625 | 70.3125 | 70.4375 | 324100.0 |
| 2000-11-24 09:30:00 | IWM | ETF | 46.2031 | 46.2188 | 46.1875 | 46.1875 | 22800.0 |
| 2000-11-24 10:00:00 | IWM | ETF | 46.2188 | 46.5625 | 46.2188 | 46.5625 | 24400.0 |
| 2000-11-24 10:30:00 | IWM | ETF | 46.5625 | 46.5625 | 46.5625 | 46.5625 | 9800.0 |
| 2000-11-24 11:00:00 | IWM | ETF | 46.6562 | 46.8125 | 46.5 | 46.8125 | 1400.0 |
| 2000-11-24 11:30:00 | IWM | ETF | 46.8125 | 46.8125 | 46.8125 | 46.8125 | 10200.0 |
| 2000-11-24 12:00:00 | IWM | ETF | 46.9688 | 47.0938 | 46.9688 | 47.0938 | 3000.0 |
| 2000-11-24 12:30:00 | IWM | ETF | 46.9688 | 46.9688 | 46.9375 | 46.9375 | 5200.0 |
| 2000-11-24 09:30:00 | DIA | ETF | 104.9688 | 104.9688 | 104.5625 | 104.75 | 253300.0 |
| 2000-11-24 10:00:00 | DIA | ETF | 104.75 | 105.2188 | 104.75 | 105.125 | 25700.0 |
| 2000-11-24 10:30:00 | DIA | ETF | 105.2188 | 105.25 | 104.875 | 105.0312 | 24400.0 |
| 2000-11-24 11:00:00 | DIA | ETF | 104.875 | 105.2188 | 104.875 | 105.1562 | 26700.0 |
| 2000-11-24 11:30:00 | DIA | ETF | 105.0625 | 105.2188 | 104.875 | 105.0625 | 42400.0 |
| 2000-11-24 12:00:00 | DIA | ETF | 105.0312 | 105.2188 | 104.9375 | 105.0625 | 5100.0 |
| 2000-11-24 12:30:00 | DIA | ETF | 105.1875 | 105.25 | 104.625 | 104.875 | 106200.0 |
| 2000-11-24 13:00:00 | DIA | ETF | 104.875 | 105.0625 | 104.875 | 105.0625 | 20600.0 |
> showing 31 of 143 rows — these rows as CSV