PREVIEW / etf_30min / 2000-10-23
file: by_date/etf_30min/2000/2000-10-23.parquet size: 11 KB rows: 277
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-10-23 09:30:00 | SPY | ETF | 139.9375 | 140.3438 | 139.5625 | 140.1562 | 611000.0 |
| 2000-10-23 10:00:00 | SPY | ETF | 140.2188 | 140.5625 | 139.75 | 140.4375 | 457200.0 |
| 2000-10-23 10:30:00 | SPY | ETF | 140.5625 | 141.0312 | 140.5312 | 140.6875 | 518600.0 |
| 2000-10-23 11:00:00 | SPY | ETF | 140.8125 | 140.875 | 140.25 | 140.375 | 284500.0 |
| 2000-10-23 11:30:00 | SPY | ETF | 140.3438 | 140.4375 | 140.0625 | 140.25 | 297500.0 |
| 2000-10-23 12:00:00 | SPY | ETF | 140.1875 | 140.3438 | 139.625 | 139.875 | 200500.0 |
| 2000-10-23 12:30:00 | SPY | ETF | 140.0 | 140.0625 | 139.6562 | 139.9062 | 190500.0 |
| 2000-10-23 13:00:00 | SPY | ETF | 139.9375 | 140.0625 | 139.5 | 139.6875 | 371400.0 |
| 2000-10-23 13:30:00 | SPY | ETF | 139.75 | 140.1875 | 139.5625 | 140.1875 | 292500.0 |
| 2000-10-23 14:00:00 | SPY | ETF | 140.2188 | 140.3125 | 139.8125 | 140.0 | 440100.0 |
| 2000-10-23 14:30:00 | SPY | ETF | 140.0 | 140.0 | 139.0938 | 139.25 | 394200.0 |
| 2000-10-23 15:00:00 | SPY | ETF | 139.125 | 139.4688 | 138.9375 | 139.1875 | 432300.0 |
| 2000-10-23 15:30:00 | SPY | ETF | 139.1875 | 140.0 | 139.1875 | 140.0 | 378300.0 |
| 2000-10-23 16:00:00 | SPY | ETF | 140.0938 | 140.625 | 139.9688 | 140.5312 | 252200.0 |
| 2000-10-23 17:00:00 | SPY | ETF | 140.0312 | 140.0312 | 140.0312 | 140.0312 | 300.0 |
| 2000-10-23 09:30:00 | QQQ | ETF | 86.1875 | 86.8125 | 85.5625 | 86.5 | 5298400.0 |
| 2000-10-23 10:00:00 | QQQ | ETF | 86.5 | 86.75 | 85.875 | 86.7188 | 2455100.0 |
| 2000-10-23 10:30:00 | QQQ | ETF | 86.75 | 87.5 | 86.625 | 86.875 | 2828800.0 |
| 2000-10-23 11:00:00 | QQQ | ETF | 86.9375 | 86.9688 | 86.1875 | 86.1875 | 1496400.0 |
| 2000-10-23 11:30:00 | QQQ | ETF | 86.2812 | 86.4688 | 85.875 | 86.25 | 1631200.0 |
| 2000-10-23 12:00:00 | QQQ | ETF | 86.1875 | 86.3125 | 85.25 | 85.6875 | 2027100.0 |
| 2000-10-23 12:30:00 | QQQ | ETF | 85.6875 | 85.7812 | 85.1875 | 85.5 | 1334900.0 |
| 2000-10-23 13:00:00 | QQQ | ETF | 85.5 | 85.625 | 84.6875 | 84.75 | 1605600.0 |
| 2000-10-23 13:30:00 | QQQ | ETF | 84.7812 | 85.625 | 84.6875 | 85.5 | 1227900.0 |
| 2000-10-23 14:00:00 | QQQ | ETF | 85.75 | 86.0 | 85.0 | 85.3438 | 1362000.0 |
| 2000-10-23 14:30:00 | QQQ | ETF | 85.3438 | 85.375 | 84.375 | 84.5938 | 2031900.0 |
| 2000-10-23 15:00:00 | QQQ | ETF | 84.5 | 85.125 | 84.125 | 84.75 | 2213700.0 |
| 2000-10-23 15:30:00 | QQQ | ETF | 84.75 | 85.8438 | 84.6562 | 85.5 | 2078400.0 |
| 2000-10-23 16:00:00 | QQQ | ETF | 85.5 | 86.375 | 85.5 | 85.75 | 617500.0 |
| 2000-10-23 16:30:00 | QQQ | ETF | 85.875 | 85.875 | 85.625 | 85.625 | 86600.0 |
| 2000-10-23 17:00:00 | QQQ | ETF | 85.875 | 85.875 | 85.6875 | 85.875 | 11300.0 |
| 2000-10-23 17:30:00 | QQQ | ETF | 85.75 | 85.875 | 85.5 | 85.75 | 15400.0 |
| 2000-10-23 18:00:00 | QQQ | ETF | 85.625 | 85.625 | 85.5312 | 85.5312 | 1000.0 |
| 2000-10-23 09:30:00 | IWM | ETF | 48.8438 | 48.875 | 48.6875 | 48.6875 | 14400.0 |
| 2000-10-23 10:00:00 | IWM | ETF | 48.9375 | 48.9375 | 48.8125 | 48.8125 | 3200.0 |
| 2000-10-23 10:30:00 | IWM | ETF | 48.9375 | 49.1094 | 48.9375 | 49.1094 | 600.0 |
| 2000-10-23 11:00:00 | IWM | ETF | 48.9375 | 48.9375 | 48.9375 | 48.9375 | 1400.0 |
| 2000-10-23 12:00:00 | IWM | ETF | 48.8281 | 48.8281 | 48.6875 | 48.6875 | 5200.0 |
| 2000-10-23 12:30:00 | IWM | ETF | 48.8438 | 48.8438 | 48.8438 | 48.8438 | 1000.0 |
| 2000-10-23 13:00:00 | IWM | ETF | 48.8438 | 48.8438 | 48.8438 | 48.8438 | 200.0 |
| 2000-10-23 13:30:00 | IWM | ETF | 48.6562 | 48.6562 | 48.6562 | 48.6562 | 200.0 |
| 2000-10-23 14:00:00 | IWM | ETF | 48.8906 | 48.9062 | 48.8906 | 48.9062 | 100200.0 |
| 2000-10-23 14:30:00 | IWM | ETF | 49.0938 | 49.0938 | 48.8125 | 48.8125 | 4200.0 |
| 2000-10-23 15:00:00 | IWM | ETF | 48.9688 | 49.0625 | 48.9688 | 49.0625 | 1200.0 |
| 2000-10-23 15:30:00 | IWM | ETF | 49.0469 | 49.125 | 49.0469 | 49.1094 | 5400.0 |
| 2000-10-23 16:00:00 | IWM | ETF | 49.0 | 49.125 | 49.0 | 49.0625 | 1400.0 |
| 2000-10-23 09:30:00 | DIA | ETF | 102.625 | 102.875 | 102.2812 | 102.6875 | 74700.0 |
| 2000-10-23 10:00:00 | DIA | ETF | 102.6875 | 103.3125 | 102.6562 | 103.2812 | 171500.0 |
| 2000-10-23 10:30:00 | DIA | ETF | 103.25 | 103.5938 | 103.25 | 103.375 | 119700.0 |
| 2000-10-23 11:00:00 | DIA | ETF | 103.4375 | 103.4688 | 102.9375 | 103.0312 | 39800.0 |
> showing 50 of 277 rows — these rows as CSV