PREVIEW / etf_30min / 2000-11-01
file: by_date/etf_30min/2000/2000-11-01.parquet size: 12 KB rows: 305
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-01 09:30:00 | SPY | ETF | 142.25 | 143.125 | 142.2188 | 142.7188 | 1025700.0 |
| 2000-11-01 10:00:00 | SPY | ETF | 142.75 | 143.2188 | 142.2188 | 142.8438 | 943500.0 |
| 2000-11-01 10:30:00 | SPY | ETF | 142.75 | 143.25 | 142.5625 | 143.2188 | 602300.0 |
| 2000-11-01 11:00:00 | SPY | ETF | 143.0625 | 143.25 | 142.75 | 143.0625 | 205100.0 |
| 2000-11-01 11:30:00 | SPY | ETF | 143.0625 | 143.1875 | 142.625 | 142.75 | 490700.0 |
| 2000-11-01 12:00:00 | SPY | ETF | 142.6875 | 142.9062 | 142.5 | 142.5 | 352700.0 |
| 2000-11-01 12:30:00 | SPY | ETF | 142.5312 | 142.6875 | 142.125 | 142.1562 | 145500.0 |
| 2000-11-01 13:00:00 | SPY | ETF | 142.25 | 142.5 | 142.0312 | 142.3125 | 236200.0 |
| 2000-11-01 13:30:00 | SPY | ETF | 142.4062 | 142.4688 | 141.625 | 141.75 | 346700.0 |
| 2000-11-01 14:00:00 | SPY | ETF | 141.8438 | 142.0 | 141.5 | 141.9062 | 201400.0 |
| 2000-11-01 14:30:00 | SPY | ETF | 141.9375 | 142.0625 | 141.625 | 141.75 | 295600.0 |
| 2000-11-01 15:00:00 | SPY | ETF | 141.5625 | 142.125 | 141.2188 | 142.125 | 484700.0 |
| 2000-11-01 15:30:00 | SPY | ETF | 142.125 | 142.6875 | 141.6562 | 142.4062 | 815200.0 |
| 2000-11-01 16:00:00 | SPY | ETF | 142.4688 | 143.1562 | 142.3125 | 142.4688 | 402700.0 |
| 2000-11-01 09:30:00 | QQQ | ETF | 80.3125 | 81.1875 | 80.0 | 80.5312 | 5844700.0 |
| 2000-11-01 10:00:00 | QQQ | ETF | 80.4375 | 80.875 | 79.1875 | 80.25 | 4479800.0 |
| 2000-11-01 10:30:00 | QQQ | ETF | 80.4062 | 82.375 | 79.875 | 82.25 | 5953100.0 |
| 2000-11-01 11:00:00 | QQQ | ETF | 82.1875 | 82.8125 | 81.625 | 82.3125 | 3943000.0 |
| 2000-11-01 11:30:00 | QQQ | ETF | 82.25 | 82.5625 | 81.25 | 81.375 | 2893200.0 |
| 2000-11-01 12:00:00 | QQQ | ETF | 81.375 | 81.8125 | 81.1875 | 81.25 | 1558500.0 |
| 2000-11-01 12:30:00 | QQQ | ETF | 81.4688 | 81.5 | 80.25 | 80.5312 | 2761700.0 |
| 2000-11-01 13:00:00 | QQQ | ETF | 80.5625 | 81.2812 | 80.3125 | 81.0625 | 2941400.0 |
| 2000-11-01 13:30:00 | QQQ | ETF | 81.0938 | 81.375 | 80.0625 | 80.25 | 1462300.0 |
| 2000-11-01 14:00:00 | QQQ | ETF | 80.25 | 80.75 | 79.8438 | 80.4688 | 2273100.0 |
| 2000-11-01 14:30:00 | QQQ | ETF | 80.4375 | 80.9062 | 79.9375 | 80.0312 | 2269500.0 |
| 2000-11-01 15:00:00 | QQQ | ETF | 80.0 | 80.5625 | 79.5 | 80.5625 | 2130000.0 |
| 2000-11-01 15:30:00 | QQQ | ETF | 80.5312 | 80.875 | 79.9375 | 80.625 | 3910200.0 |
| 2000-11-01 16:00:00 | QQQ | ETF | 80.625 | 81.625 | 80.5 | 81.0 | 878400.0 |
| 2000-11-01 16:30:00 | QQQ | ETF | 81.0 | 81.0 | 80.75 | 80.875 | 4600.0 |
| 2000-11-01 17:00:00 | QQQ | ETF | 81.0 | 81.5625 | 81.0 | 81.5625 | 5100.0 |
| 2000-11-01 17:30:00 | QQQ | ETF | 81.0 | 81.5625 | 81.0 | 81.375 | 2500.0 |
| 2000-11-01 18:00:00 | QQQ | ETF | 81.3125 | 81.5625 | 80.75 | 81.5 | 3300.0 |
| 2000-11-01 09:30:00 | IWM | ETF | 49.3438 | 49.5312 | 49.3438 | 49.4375 | 32800.0 |
| 2000-11-01 10:00:00 | IWM | ETF | 49.4375 | 49.5312 | 49.2812 | 49.4375 | 48600.0 |
| 2000-11-01 10:30:00 | IWM | ETF | 49.4375 | 49.625 | 49.4375 | 49.625 | 109200.0 |
| 2000-11-01 11:00:00 | IWM | ETF | 49.6875 | 49.7188 | 49.5312 | 49.7188 | 142200.0 |
| 2000-11-01 11:30:00 | IWM | ETF | 49.5938 | 49.7188 | 49.5938 | 49.6875 | 11800.0 |
| 2000-11-01 12:00:00 | IWM | ETF | 49.6875 | 49.6875 | 49.5625 | 49.6719 | 8200.0 |
| 2000-11-01 12:30:00 | IWM | ETF | 49.5625 | 49.625 | 49.4688 | 49.5 | 58600.0 |
| 2000-11-01 13:00:00 | IWM | ETF | 49.5 | 49.5 | 49.4844 | 49.5 | 1800.0 |
| 2000-11-01 13:30:00 | IWM | ETF | 49.3438 | 49.3438 | 49.3438 | 49.3438 | 18000.0 |
| 2000-11-01 14:00:00 | IWM | ETF | 49.3438 | 49.5312 | 49.3438 | 49.4062 | 11000.0 |
| 2000-11-01 14:30:00 | IWM | ETF | 49.5312 | 49.5625 | 49.3438 | 49.3438 | 44200.0 |
| 2000-11-01 15:00:00 | IWM | ETF | 49.5312 | 49.5312 | 49.3594 | 49.5312 | 8000.0 |
| 2000-11-01 15:30:00 | IWM | ETF | 49.5312 | 49.6562 | 49.4375 | 49.5312 | 33600.0 |
| 2000-11-01 09:30:00 | DIA | ETF | 109.1562 | 109.9062 | 109.1562 | 109.4375 | 377000.0 |
| 2000-11-01 10:00:00 | DIA | ETF | 109.5 | 109.9062 | 109.1875 | 109.5938 | 394800.0 |
| 2000-11-01 10:30:00 | DIA | ETF | 109.75 | 109.75 | 109.2188 | 109.25 | 136900.0 |
| 2000-11-01 11:00:00 | DIA | ETF | 109.2188 | 109.4375 | 108.9375 | 109.0625 | 232900.0 |
| 2000-11-01 11:30:00 | DIA | ETF | 109.0625 | 109.3438 | 108.9688 | 109.2188 | 230000.0 |
> showing 50 of 305 rows — these rows as CSV