PREVIEW / etf_30min / 2000-12-28
file: by_date/etf_30min/2000/2000-12-28.parquet size: 13 KB rows: 351
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-28 09:30:00 | SPY | ETF | 132.8125 | 133.7188 | 132.75 | 133.3125 | 1302100.0 |
| 2000-12-28 10:00:00 | SPY | ETF | 133.3438 | 133.6875 | 133.0312 | 133.5625 | 571100.0 |
| 2000-12-28 10:30:00 | SPY | ETF | 133.4375 | 133.6875 | 133.125 | 133.5312 | 423500.0 |
| 2000-12-28 11:00:00 | SPY | ETF | 133.5312 | 133.7188 | 133.1875 | 133.6562 | 353400.0 |
| 2000-12-28 11:30:00 | SPY | ETF | 133.625 | 133.6562 | 132.9062 | 133.0938 | 607900.0 |
| 2000-12-28 12:00:00 | SPY | ETF | 132.9688 | 133.2188 | 132.5938 | 132.875 | 276800.0 |
| 2000-12-28 12:30:00 | SPY | ETF | 132.8125 | 133.2812 | 132.8125 | 133.2188 | 283000.0 |
| 2000-12-28 13:00:00 | SPY | ETF | 133.2188 | 133.4375 | 133.0938 | 133.3438 | 365200.0 |
| 2000-12-28 13:30:00 | SPY | ETF | 133.25 | 133.3125 | 132.9062 | 133.1875 | 322200.0 |
| 2000-12-28 14:00:00 | SPY | ETF | 133.2188 | 133.4688 | 133.125 | 133.375 | 349300.0 |
| 2000-12-28 14:30:00 | SPY | ETF | 133.375 | 133.6562 | 133.1875 | 133.5938 | 566600.0 |
| 2000-12-28 15:00:00 | SPY | ETF | 133.625 | 133.8125 | 133.125 | 133.4375 | 519000.0 |
| 2000-12-28 15:30:00 | SPY | ETF | 133.2812 | 133.7188 | 133.0938 | 133.5938 | 1075300.0 |
| 2000-12-28 16:00:00 | SPY | ETF | 133.5938 | 133.875 | 133.4062 | 133.7188 | 520700.0 |
| 2000-12-28 16:30:00 | SPY | ETF | 133.7188 | 133.7188 | 133.7188 | 133.7188 | 700.0 |
| 2000-12-28 09:30:00 | QQQ | ETF | 60.7812 | 62.4688 | 60.625 | 61.9375 | 5996300.0 |
| 2000-12-28 10:00:00 | QQQ | ETF | 61.875 | 62.3125 | 61.5 | 62.0 | 2090500.0 |
| 2000-12-28 10:30:00 | QQQ | ETF | 61.9375 | 62.125 | 61.4688 | 61.8125 | 1870100.0 |
| 2000-12-28 11:00:00 | QQQ | ETF | 61.8438 | 61.875 | 61.3125 | 61.75 | 2001100.0 |
| 2000-12-28 11:30:00 | QQQ | ETF | 61.75 | 61.8438 | 60.5 | 60.875 | 2316700.0 |
| 2000-12-28 12:00:00 | QQQ | ETF | 60.875 | 61.0 | 60.5 | 60.7812 | 1587000.0 |
| 2000-12-28 12:30:00 | QQQ | ETF | 60.6875 | 61.0312 | 60.625 | 61.0 | 1633200.0 |
| 2000-12-28 13:00:00 | QQQ | ETF | 61.0 | 61.125 | 60.5625 | 60.7188 | 1354100.0 |
| 2000-12-28 13:30:00 | QQQ | ETF | 60.6875 | 60.8438 | 60.25 | 60.375 | 1754200.0 |
| 2000-12-28 14:00:00 | QQQ | ETF | 60.4375 | 61.0625 | 60.3438 | 60.8438 | 1514100.0 |
| 2000-12-28 14:30:00 | QQQ | ETF | 60.875 | 61.5 | 60.625 | 61.4688 | 1848800.0 |
| 2000-12-28 15:00:00 | QQQ | ETF | 61.5 | 61.7812 | 60.9375 | 61.1875 | 3072500.0 |
| 2000-12-28 15:30:00 | QQQ | ETF | 61.1875 | 61.625 | 61.0 | 61.2812 | 2839900.0 |
| 2000-12-28 16:00:00 | QQQ | ETF | 61.3438 | 61.5625 | 61.125 | 61.5312 | 951300.0 |
| 2000-12-28 16:30:00 | QQQ | ETF | 61.25 | 61.625 | 61.25 | 61.375 | 22800.0 |
| 2000-12-28 17:00:00 | QQQ | ETF | 61.375 | 61.5 | 61.3125 | 61.5 | 4600.0 |
| 2000-12-28 17:30:00 | QQQ | ETF | 61.4375 | 61.5 | 61.25 | 61.5 | 12700.0 |
| 2000-12-28 18:00:00 | QQQ | ETF | 61.4375 | 61.625 | 61.4375 | 61.625 | 3600.0 |
| 2000-12-28 09:30:00 | IWM | ETF | 47.7188 | 48.1875 | 47.7188 | 47.8594 | 88400.0 |
| 2000-12-28 10:00:00 | IWM | ETF | 47.875 | 48.1875 | 47.875 | 48.1875 | 135000.0 |
| 2000-12-28 10:30:00 | IWM | ETF | 48.1875 | 48.4375 | 48.125 | 48.4375 | 166000.0 |
| 2000-12-28 11:00:00 | IWM | ETF | 48.3438 | 48.5156 | 48.3438 | 48.5156 | 3200.0 |
| 2000-12-28 11:30:00 | IWM | ETF | 48.6562 | 48.6875 | 48.6562 | 48.6875 | 43600.0 |
| 2000-12-28 12:00:00 | IWM | ETF | 48.4375 | 48.5781 | 48.4375 | 48.5781 | 9800.0 |
| 2000-12-28 12:30:00 | IWM | ETF | 48.5625 | 48.625 | 48.5625 | 48.625 | 50400.0 |
| 2000-12-28 13:00:00 | IWM | ETF | 48.75 | 48.75 | 48.625 | 48.625 | 186400.0 |
| 2000-12-28 13:30:00 | IWM | ETF | 48.8125 | 48.8125 | 48.7188 | 48.7812 | 50800.0 |
| 2000-12-28 14:00:00 | IWM | ETF | 48.7656 | 48.9688 | 48.7656 | 48.9688 | 70600.0 |
| 2000-12-28 14:30:00 | IWM | ETF | 49.0156 | 49.125 | 48.9375 | 49.125 | 118200.0 |
| 2000-12-28 15:00:00 | IWM | ETF | 49.1562 | 49.2188 | 48.9375 | 48.9375 | 86400.0 |
| 2000-12-28 15:30:00 | IWM | ETF | 49.0 | 49.3594 | 48.8438 | 49.1875 | 133800.0 |
| 2000-12-28 16:00:00 | IWM | ETF | 49.1875 | 49.375 | 49.1875 | 49.2812 | 40600.0 |
| 2000-12-28 09:30:00 | DIA | ETF | 107.9375 | 108.25 | 107.7188 | 107.9375 | 109500.0 |
| 2000-12-28 10:00:00 | DIA | ETF | 107.7812 | 108.1875 | 107.75 | 108.0 | 166200.0 |
| 2000-12-28 10:30:00 | DIA | ETF | 108.125 | 108.3438 | 107.7188 | 108.25 | 273300.0 |
> showing 50 of 351 rows — these rows as CSV