PREVIEW / etf_30min / 2000-11-17
file: by_date/etf_30min/2000/2000-11-17.parquet size: 12 KB rows: 292
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-17 09:30:00 | SPY | ETF | 137.3125 | 137.6875 | 136.6875 | 137.1562 | 728500.0 |
| 2000-11-17 10:00:00 | SPY | ETF | 137.0 | 139.0 | 137.0 | 138.5938 | 1105000.0 |
| 2000-11-17 10:30:00 | SPY | ETF | 138.5 | 138.6875 | 137.0625 | 137.0625 | 596100.0 |
| 2000-11-17 11:00:00 | SPY | ETF | 137.25 | 137.5625 | 136.2188 | 136.3125 | 368500.0 |
| 2000-11-17 11:30:00 | SPY | ETF | 136.3125 | 136.5625 | 135.75 | 136.25 | 707900.0 |
| 2000-11-17 12:00:00 | SPY | ETF | 136.1562 | 136.7188 | 136.0312 | 136.4688 | 318100.0 |
| 2000-11-17 12:30:00 | SPY | ETF | 136.4375 | 136.625 | 136.125 | 136.2812 | 319400.0 |
| 2000-11-17 13:00:00 | SPY | ETF | 136.3125 | 136.625 | 136.0 | 136.375 | 247200.0 |
| 2000-11-17 13:30:00 | SPY | ETF | 136.4688 | 137.0 | 136.25 | 136.8438 | 99800.0 |
| 2000-11-17 14:00:00 | SPY | ETF | 136.8438 | 137.375 | 136.4375 | 136.5625 | 240500.0 |
| 2000-11-17 14:30:00 | SPY | ETF | 136.5625 | 137.4688 | 136.4375 | 137.4375 | 218900.0 |
| 2000-11-17 15:00:00 | SPY | ETF | 137.5 | 137.5312 | 136.6562 | 136.875 | 300500.0 |
| 2000-11-17 15:30:00 | SPY | ETF | 136.8438 | 137.4688 | 136.3125 | 137.4688 | 423100.0 |
| 2000-11-17 16:00:00 | SPY | ETF | 137.4062 | 137.4688 | 136.625 | 136.625 | 501300.0 |
| 2000-11-17 09:30:00 | QQQ | ETF | 73.1875 | 73.7188 | 72.0 | 72.8125 | 5283900.0 |
| 2000-11-17 10:00:00 | QQQ | ETF | 72.75 | 75.1875 | 72.625 | 74.5 | 10404400.0 |
| 2000-11-17 10:30:00 | QQQ | ETF | 74.5 | 74.5938 | 72.625 | 72.75 | 4684100.0 |
| 2000-11-17 11:00:00 | QQQ | ETF | 72.75 | 73.125 | 71.25 | 71.3438 | 3547200.0 |
| 2000-11-17 11:30:00 | QQQ | ETF | 71.6562 | 72.25 | 71.0 | 71.9375 | 3981800.0 |
| 2000-11-17 12:00:00 | QQQ | ETF | 72.0 | 72.4375 | 71.625 | 72.4062 | 1637700.0 |
| 2000-11-17 12:30:00 | QQQ | ETF | 72.375 | 72.625 | 71.875 | 71.9375 | 1523100.0 |
| 2000-11-17 13:00:00 | QQQ | ETF | 71.9375 | 72.4688 | 71.5 | 72.125 | 1764200.0 |
| 2000-11-17 13:30:00 | QQQ | ETF | 72.1875 | 73.3125 | 72.0 | 73.0625 | 2064100.0 |
| 2000-11-17 14:00:00 | QQQ | ETF | 73.0625 | 73.625 | 72.625 | 72.625 | 2781100.0 |
| 2000-11-17 14:30:00 | QQQ | ETF | 72.625 | 73.9375 | 72.4375 | 73.9375 | 2490500.0 |
| 2000-11-17 15:00:00 | QQQ | ETF | 73.875 | 74.0 | 72.875 | 73.25 | 2506900.0 |
| 2000-11-17 15:30:00 | QQQ | ETF | 73.3125 | 73.7188 | 72.375 | 73.7188 | 3344300.0 |
| 2000-11-17 16:00:00 | QQQ | ETF | 73.6875 | 73.75 | 72.625 | 72.9375 | 1768800.0 |
| 2000-11-17 16:30:00 | QQQ | ETF | 72.9375 | 74.0625 | 72.8125 | 73.0625 | 76700.0 |
| 2000-11-17 17:00:00 | QQQ | ETF | 72.9375 | 74.0625 | 72.875 | 72.9375 | 10300.0 |
| 2000-11-17 17:30:00 | QQQ | ETF | 72.875 | 73.0 | 72.8125 | 72.8125 | 5700.0 |
| 2000-11-17 18:00:00 | QQQ | ETF | 72.75 | 72.9375 | 72.75 | 72.875 | 2700.0 |
| 2000-11-17 09:30:00 | IWM | ETF | 48.5 | 48.5 | 48.2188 | 48.2188 | 10400.0 |
| 2000-11-17 10:00:00 | IWM | ETF | 48.25 | 48.8906 | 48.25 | 48.75 | 133200.0 |
| 2000-11-17 10:30:00 | IWM | ETF | 48.625 | 48.625 | 48.5625 | 48.5625 | 3000.0 |
| 2000-11-17 11:00:00 | IWM | ETF | 48.5 | 48.5938 | 48.2812 | 48.2812 | 11200.0 |
| 2000-11-17 11:30:00 | IWM | ETF | 48.2812 | 48.2812 | 48.0625 | 48.0625 | 16600.0 |
| 2000-11-17 12:00:00 | IWM | ETF | 48.0312 | 48.0312 | 48.0312 | 48.0312 | 18200.0 |
| 2000-11-17 12:30:00 | IWM | ETF | 48.3125 | 48.3125 | 48.3125 | 48.3125 | 3800.0 |
| 2000-11-17 13:00:00 | IWM | ETF | 48.1875 | 48.1875 | 48.1875 | 48.1875 | 3800.0 |
| 2000-11-17 13:30:00 | IWM | ETF | 48.2188 | 48.3438 | 48.1875 | 48.3438 | 2800.0 |
| 2000-11-17 14:00:00 | IWM | ETF | 48.4219 | 48.4219 | 48.4219 | 48.4219 | 200.0 |
| 2000-11-17 14:30:00 | IWM | ETF | 48.3438 | 48.3438 | 48.3438 | 48.3438 | 800.0 |
| 2000-11-17 15:00:00 | IWM | ETF | 48.4219 | 48.4219 | 48.4219 | 48.4219 | 1200.0 |
| 2000-11-17 15:30:00 | IWM | ETF | 48.1562 | 48.1562 | 48.1562 | 48.1562 | 200.0 |
| 2000-11-17 09:30:00 | DIA | ETF | 106.4375 | 106.6562 | 106.1875 | 106.5625 | 85900.0 |
| 2000-11-17 10:00:00 | DIA | ETF | 106.5625 | 108.0625 | 106.4375 | 107.5 | 323900.0 |
| 2000-11-17 10:30:00 | DIA | ETF | 107.4688 | 107.4688 | 106.25 | 106.5625 | 152000.0 |
| 2000-11-17 11:00:00 | DIA | ETF | 106.5625 | 106.8125 | 106.0312 | 106.0312 | 177000.0 |
| 2000-11-17 11:30:00 | DIA | ETF | 106.0 | 106.1875 | 105.5312 | 105.8125 | 168200.0 |
> showing 50 of 292 rows — these rows as CSV