PREVIEW / etf_30min / 2000-12-22
file: by_date/etf_30min/2000/2000-12-22.parquet size: 12 KB rows: 333
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-22 09:30:00 | SPY | ETF | 129.0 | 129.8438 | 128.8438 | 129.8125 | 1301800.0 |
| 2000-12-22 10:00:00 | SPY | ETF | 129.75 | 130.0938 | 129.5625 | 130.0 | 946500.0 |
| 2000-12-22 10:30:00 | SPY | ETF | 130.0 | 130.4688 | 129.75 | 130.2812 | 1228400.0 |
| 2000-12-22 11:00:00 | SPY | ETF | 130.3125 | 130.5938 | 130.0 | 130.25 | 1233400.0 |
| 2000-12-22 11:30:00 | SPY | ETF | 130.25 | 130.4375 | 129.75 | 129.75 | 475900.0 |
| 2000-12-22 12:00:00 | SPY | ETF | 129.875 | 130.1562 | 129.7188 | 130.0 | 434900.0 |
| 2000-12-22 12:30:00 | SPY | ETF | 129.9375 | 130.125 | 129.8125 | 129.9688 | 281900.0 |
| 2000-12-22 13:00:00 | SPY | ETF | 130.0 | 130.2812 | 129.8125 | 130.0625 | 298800.0 |
| 2000-12-22 13:30:00 | SPY | ETF | 130.0 | 130.0625 | 129.5 | 129.6875 | 206900.0 |
| 2000-12-22 14:00:00 | SPY | ETF | 129.625 | 129.75 | 129.0 | 129.625 | 763000.0 |
| 2000-12-22 14:30:00 | SPY | ETF | 129.625 | 130.0 | 129.4688 | 129.7188 | 171700.0 |
| 2000-12-22 15:00:00 | SPY | ETF | 129.9375 | 130.4688 | 129.8125 | 130.4062 | 585700.0 |
| 2000-12-22 15:30:00 | SPY | ETF | 130.4375 | 130.8438 | 130.0 | 130.8438 | 646500.0 |
| 2000-12-22 16:00:00 | SPY | ETF | 130.75 | 131.0938 | 130.6562 | 130.9375 | 1317300.0 |
| 2000-12-22 17:00:00 | SPY | ETF | 131.5 | 131.5 | 131.5 | 131.5 | 1000.0 |
| 2000-12-22 09:30:00 | QQQ | ETF | 57.625 | 59.3125 | 57.625 | 58.9688 | 10143600.0 |
| 2000-12-22 10:00:00 | QQQ | ETF | 58.9688 | 59.375 | 58.625 | 59.3125 | 6232900.0 |
| 2000-12-22 10:30:00 | QQQ | ETF | 59.1875 | 59.9688 | 59.0 | 59.8125 | 5148100.0 |
| 2000-12-22 11:00:00 | QQQ | ETF | 59.75 | 60.375 | 59.5 | 59.7188 | 4581300.0 |
| 2000-12-22 11:30:00 | QQQ | ETF | 59.625 | 60.0625 | 59.25 | 59.25 | 3146100.0 |
| 2000-12-22 12:00:00 | QQQ | ETF | 59.3438 | 59.875 | 59.25 | 59.625 | 2434400.0 |
| 2000-12-22 12:30:00 | QQQ | ETF | 59.625 | 59.8438 | 59.375 | 59.5625 | 1511000.0 |
| 2000-12-22 13:00:00 | QQQ | ETF | 59.5625 | 59.9375 | 59.5625 | 59.625 | 2175100.0 |
| 2000-12-22 13:30:00 | QQQ | ETF | 59.625 | 59.7188 | 58.6875 | 58.6875 | 3479500.0 |
| 2000-12-22 14:00:00 | QQQ | ETF | 58.7188 | 59.2812 | 57.75 | 58.875 | 4760500.0 |
| 2000-12-22 14:30:00 | QQQ | ETF | 58.8438 | 59.3125 | 58.5625 | 58.9062 | 1558500.0 |
| 2000-12-22 15:00:00 | QQQ | ETF | 58.8438 | 60.375 | 58.8438 | 60.125 | 4013200.0 |
| 2000-12-22 15:30:00 | QQQ | ETF | 60.1875 | 60.75 | 59.6875 | 60.625 | 4485400.0 |
| 2000-12-22 16:00:00 | QQQ | ETF | 60.5625 | 60.75 | 60.0 | 60.5625 | 992200.0 |
| 2000-12-22 16:30:00 | QQQ | ETF | 60.5 | 61.0 | 60.4688 | 60.625 | 8600.0 |
| 2000-12-22 17:00:00 | QQQ | ETF | 60.75 | 61.0 | 60.5 | 60.9375 | 6800.0 |
| 2000-12-22 17:30:00 | QQQ | ETF | 60.875 | 60.9375 | 60.5625 | 60.75 | 10700.0 |
| 2000-12-22 18:00:00 | QQQ | ETF | 60.75 | 61.3125 | 60.5 | 60.625 | 19700.0 |
| 2000-12-22 09:30:00 | IWM | ETF | 45.125 | 45.2188 | 45.0625 | 45.2188 | 137000.0 |
| 2000-12-22 10:00:00 | IWM | ETF | 45.2812 | 45.4844 | 45.25 | 45.2812 | 186200.0 |
| 2000-12-22 10:30:00 | IWM | ETF | 45.5 | 45.7812 | 45.5 | 45.625 | 208000.0 |
| 2000-12-22 11:00:00 | IWM | ETF | 45.8125 | 45.875 | 45.625 | 45.8125 | 62200.0 |
| 2000-12-22 11:30:00 | IWM | ETF | 45.9688 | 46.0 | 45.75 | 45.75 | 44200.0 |
| 2000-12-22 12:00:00 | IWM | ETF | 45.875 | 45.875 | 45.6875 | 45.8438 | 25400.0 |
| 2000-12-22 12:30:00 | IWM | ETF | 45.8438 | 45.875 | 45.6875 | 45.7188 | 20000.0 |
| 2000-12-22 13:00:00 | IWM | ETF | 45.6875 | 45.9375 | 45.6406 | 45.8438 | 26800.0 |
| 2000-12-22 13:30:00 | IWM | ETF | 45.7812 | 45.8125 | 45.625 | 45.75 | 33400.0 |
| 2000-12-22 14:00:00 | IWM | ETF | 45.5938 | 45.75 | 45.4688 | 45.4688 | 22000.0 |
| 2000-12-22 14:30:00 | IWM | ETF | 45.5938 | 45.7656 | 45.5938 | 45.7656 | 600.0 |
| 2000-12-22 15:00:00 | IWM | ETF | 45.8125 | 46.0312 | 45.7188 | 46.0 | 39000.0 |
| 2000-12-22 15:30:00 | IWM | ETF | 46.0938 | 46.2188 | 46.0312 | 46.1875 | 22200.0 |
| 2000-12-22 16:00:00 | IWM | ETF | 46.3438 | 46.3438 | 46.25 | 46.25 | 21800.0 |
| 2000-12-22 09:30:00 | DIA | ETF | 105.5 | 105.8125 | 105.2188 | 105.8125 | 404800.0 |
| 2000-12-22 10:00:00 | DIA | ETF | 105.7188 | 105.875 | 105.5 | 105.6875 | 66800.0 |
| 2000-12-22 10:30:00 | DIA | ETF | 105.8125 | 106.1875 | 105.625 | 106.125 | 222700.0 |
> showing 50 of 333 rows — these rows as CSV