PREVIEW / etf_30min / 2000-12-13
file: by_date/etf_30min/2000/2000-12-13.parquet size: 12 KB rows: 307
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-13 09:30:00 | SPY | ETF | 139.25 | 139.4062 | 138.1875 | 138.1875 | 1128200.0 |
| 2000-12-13 10:00:00 | SPY | ETF | 138.1562 | 139.125 | 137.8438 | 138.25 | 910400.0 |
| 2000-12-13 10:30:00 | SPY | ETF | 138.1875 | 138.3125 | 137.1562 | 137.25 | 576200.0 |
| 2000-12-13 11:00:00 | SPY | ETF | 137.3438 | 137.6875 | 137.0 | 137.6875 | 424200.0 |
| 2000-12-13 11:30:00 | SPY | ETF | 137.5312 | 138.1875 | 137.5 | 138.1562 | 177500.0 |
| 2000-12-13 12:00:00 | SPY | ETF | 138.1562 | 138.1562 | 137.5 | 137.5625 | 258700.0 |
| 2000-12-13 12:30:00 | SPY | ETF | 137.5938 | 137.625 | 137.0625 | 137.1562 | 393300.0 |
| 2000-12-13 13:00:00 | SPY | ETF | 137.1562 | 137.6562 | 137.0625 | 137.4375 | 126100.0 |
| 2000-12-13 13:30:00 | SPY | ETF | 137.375 | 137.8438 | 137.3125 | 137.6875 | 230000.0 |
| 2000-12-13 14:00:00 | SPY | ETF | 137.6875 | 137.7812 | 137.0938 | 137.375 | 147900.0 |
| 2000-12-13 14:30:00 | SPY | ETF | 137.4375 | 137.6562 | 137.0312 | 137.4375 | 167900.0 |
| 2000-12-13 15:00:00 | SPY | ETF | 137.4062 | 137.5312 | 136.5625 | 136.5625 | 267400.0 |
| 2000-12-13 15:30:00 | SPY | ETF | 136.5312 | 136.9375 | 136.2812 | 136.5312 | 531300.0 |
| 2000-12-13 16:00:00 | SPY | ETF | 136.6562 | 136.7188 | 136.0312 | 136.125 | 528800.0 |
| 2000-12-13 17:00:00 | SPY | ETF | 136.125 | 136.125 | 136.125 | 136.125 | 7500.0 |
| 2000-12-13 09:30:00 | QQQ | ETF | 73.4375 | 73.5 | 71.125 | 71.1562 | 9119500.0 |
| 2000-12-13 10:00:00 | QQQ | ETF | 71.125 | 72.5625 | 70.625 | 71.5312 | 10127600.0 |
| 2000-12-13 10:30:00 | QQQ | ETF | 71.4688 | 71.75 | 70.0625 | 70.25 | 4512700.0 |
| 2000-12-13 11:00:00 | QQQ | ETF | 70.25 | 70.5938 | 69.6875 | 70.4688 | 5040400.0 |
| 2000-12-13 11:30:00 | QQQ | ETF | 70.4688 | 70.9688 | 70.25 | 70.9375 | 2445800.0 |
| 2000-12-13 12:00:00 | QQQ | ETF | 70.9375 | 70.9375 | 69.9062 | 70.0 | 1521800.0 |
| 2000-12-13 12:30:00 | QQQ | ETF | 70.0 | 70.1875 | 69.5312 | 69.625 | 1357600.0 |
| 2000-12-13 13:00:00 | QQQ | ETF | 69.625 | 70.3438 | 69.5625 | 70.1562 | 1543200.0 |
| 2000-12-13 13:30:00 | QQQ | ETF | 70.0312 | 70.5 | 69.875 | 70.5 | 1509700.0 |
| 2000-12-13 14:00:00 | QQQ | ETF | 70.5 | 70.5625 | 69.7188 | 70.0625 | 1406800.0 |
| 2000-12-13 14:30:00 | QQQ | ETF | 70.125 | 70.4375 | 69.625 | 70.0 | 1793200.0 |
| 2000-12-13 15:00:00 | QQQ | ETF | 69.9375 | 70.25 | 68.75 | 69.0 | 3257200.0 |
| 2000-12-13 15:30:00 | QQQ | ETF | 68.8125 | 69.3438 | 68.3125 | 68.5 | 4688700.0 |
| 2000-12-13 16:00:00 | QQQ | ETF | 68.5312 | 68.7188 | 68.375 | 68.6875 | 764000.0 |
| 2000-12-13 16:30:00 | QQQ | ETF | 68.8125 | 68.875 | 68.375 | 68.75 | 42000.0 |
| 2000-12-13 17:00:00 | QQQ | ETF | 68.75 | 69.2188 | 68.6875 | 68.6875 | 15200.0 |
| 2000-12-13 17:30:00 | QQQ | ETF | 68.6875 | 69.0 | 68.6875 | 69.0 | 4400.0 |
| 2000-12-13 18:00:00 | QQQ | ETF | 68.8125 | 68.9375 | 68.75 | 68.75 | 3800.0 |
| 2000-12-13 09:30:00 | IWM | ETF | 47.8906 | 47.8906 | 47.7188 | 47.8125 | 28000.0 |
| 2000-12-13 10:00:00 | IWM | ETF | 47.5 | 47.6562 | 47.25 | 47.4062 | 57800.0 |
| 2000-12-13 10:30:00 | IWM | ETF | 47.3906 | 47.3906 | 47.1562 | 47.1562 | 52600.0 |
| 2000-12-13 11:00:00 | IWM | ETF | 47.0625 | 47.1406 | 46.9375 | 47.1406 | 80600.0 |
| 2000-12-13 11:30:00 | IWM | ETF | 47.0312 | 47.2812 | 47.0312 | 47.25 | 16000.0 |
| 2000-12-13 12:00:00 | IWM | ETF | 47.0938 | 47.2812 | 47.0938 | 47.2188 | 17000.0 |
| 2000-12-13 12:30:00 | IWM | ETF | 47.0938 | 47.1562 | 47.0 | 47.0 | 93400.0 |
| 2000-12-13 13:00:00 | IWM | ETF | 47.125 | 47.125 | 46.9375 | 47.0625 | 19800.0 |
| 2000-12-13 13:30:00 | IWM | ETF | 47.0938 | 47.1562 | 47.0938 | 47.1562 | 7400.0 |
| 2000-12-13 14:00:00 | IWM | ETF | 47.0938 | 47.0938 | 46.8438 | 46.9375 | 15200.0 |
| 2000-12-13 14:30:00 | IWM | ETF | 46.9219 | 46.9688 | 46.8594 | 46.9375 | 25800.0 |
| 2000-12-13 15:00:00 | IWM | ETF | 46.8125 | 46.9375 | 46.75 | 46.75 | 66600.0 |
| 2000-12-13 15:30:00 | IWM | ETF | 46.5938 | 46.7969 | 46.5938 | 46.625 | 39600.0 |
| 2000-12-13 16:00:00 | IWM | ETF | 46.6094 | 46.6094 | 46.6094 | 46.6094 | 200.0 |
| 2000-12-13 09:30:00 | DIA | ETF | 108.9062 | 109.4375 | 108.5625 | 108.75 | 163200.0 |
| 2000-12-13 10:00:00 | DIA | ETF | 108.625 | 109.375 | 108.375 | 108.75 | 141900.0 |
| 2000-12-13 10:30:00 | DIA | ETF | 108.6875 | 108.8438 | 108.0312 | 108.3125 | 85100.0 |
> showing 50 of 307 rows — these rows as CSV