PREVIEW / etf_30min / 2000-11-08
file: by_date/etf_30min/2000/2000-11-08.parquet size: 12 KB rows: 295
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-08 09:30:00 | SPY | ETF | 144.0625 | 144.0625 | 143.1562 | 143.1875 | 658200.0 |
| 2000-11-08 10:00:00 | SPY | ETF | 143.125 | 143.1562 | 142.625 | 142.7812 | 720800.0 |
| 2000-11-08 10:30:00 | SPY | ETF | 142.9688 | 143.0 | 142.3125 | 142.75 | 364600.0 |
| 2000-11-08 11:00:00 | SPY | ETF | 142.8438 | 142.9688 | 142.3438 | 142.625 | 177700.0 |
| 2000-11-08 11:30:00 | SPY | ETF | 142.625 | 143.2188 | 142.625 | 142.8125 | 445700.0 |
| 2000-11-08 12:00:00 | SPY | ETF | 142.9688 | 143.0938 | 142.6875 | 142.75 | 628200.0 |
| 2000-11-08 12:30:00 | SPY | ETF | 142.625 | 142.8438 | 142.4375 | 142.6875 | 74700.0 |
| 2000-11-08 13:00:00 | SPY | ETF | 142.625 | 142.7812 | 142.0625 | 142.125 | 128800.0 |
| 2000-11-08 13:30:00 | SPY | ETF | 142.0625 | 142.4375 | 141.7188 | 142.375 | 446600.0 |
| 2000-11-08 14:00:00 | SPY | ETF | 142.2188 | 142.5 | 142.0 | 142.4062 | 193200.0 |
| 2000-11-08 14:30:00 | SPY | ETF | 142.3438 | 142.4688 | 141.75 | 142.1875 | 90900.0 |
| 2000-11-08 15:00:00 | SPY | ETF | 142.1875 | 142.4062 | 141.6875 | 141.8438 | 342300.0 |
| 2000-11-08 15:30:00 | SPY | ETF | 141.6562 | 142.0 | 141.0312 | 141.25 | 1080900.0 |
| 2000-11-08 16:00:00 | SPY | ETF | 141.1875 | 141.1875 | 140.5625 | 140.5625 | 523300.0 |
| 2000-11-08 16:30:00 | SPY | ETF | 140.5625 | 140.5625 | 140.0 | 140.0 | 900.0 |
| 2000-11-08 17:00:00 | SPY | ETF | 140.625 | 140.625 | 140.625 | 140.625 | 50000.0 |
| 2000-11-08 09:30:00 | QQQ | ETF | 82.125 | 82.25 | 80.8125 | 80.9375 | 2608600.0 |
| 2000-11-08 10:00:00 | QQQ | ETF | 80.75 | 80.9375 | 79.6875 | 79.6875 | 3957300.0 |
| 2000-11-08 10:30:00 | QQQ | ETF | 79.75 | 80.0 | 79.3125 | 79.5938 | 3073800.0 |
| 2000-11-08 11:00:00 | QQQ | ETF | 79.5625 | 79.75 | 78.875 | 79.3125 | 2457700.0 |
| 2000-11-08 11:30:00 | QQQ | ETF | 79.3125 | 79.9688 | 79.1875 | 79.375 | 2052900.0 |
| 2000-11-08 12:00:00 | QQQ | ETF | 79.375 | 79.7812 | 78.8125 | 78.8125 | 1213500.0 |
| 2000-11-08 12:30:00 | QQQ | ETF | 78.875 | 79.0312 | 78.5 | 78.875 | 1524600.0 |
| 2000-11-08 13:00:00 | QQQ | ETF | 78.8438 | 78.875 | 78.0 | 78.0938 | 1775700.0 |
| 2000-11-08 13:30:00 | QQQ | ETF | 78.0625 | 78.4375 | 77.25 | 78.2812 | 4286700.0 |
| 2000-11-08 14:00:00 | QQQ | ETF | 78.2812 | 78.2812 | 77.375 | 78.0 | 2624800.0 |
| 2000-11-08 14:30:00 | QQQ | ETF | 77.875 | 78.3125 | 77.3125 | 78.125 | 2310400.0 |
| 2000-11-08 15:00:00 | QQQ | ETF | 78.0938 | 78.2812 | 77.125 | 77.25 | 2570000.0 |
| 2000-11-08 15:30:00 | QQQ | ETF | 77.3125 | 77.4375 | 76.3125 | 76.3125 | 5165700.0 |
| 2000-11-08 16:00:00 | QQQ | ETF | 76.3125 | 76.6875 | 75.625 | 75.875 | 3163400.0 |
| 2000-11-08 16:30:00 | QQQ | ETF | 76.0 | 77.0 | 75.875 | 77.0 | 22200.0 |
| 2000-11-08 17:00:00 | QQQ | ETF | 76.0 | 76.25 | 75.625 | 76.0 | 36000.0 |
| 2000-11-08 17:30:00 | QQQ | ETF | 75.875 | 76.0 | 75.75 | 75.75 | 22500.0 |
| 2000-11-08 18:00:00 | QQQ | ETF | 75.9375 | 76.25 | 75.8125 | 75.9375 | 13800.0 |
| 2000-11-08 09:30:00 | IWM | ETF | 50.7188 | 50.7188 | 50.6562 | 50.6562 | 1600.0 |
| 2000-11-08 10:00:00 | IWM | ETF | 50.5312 | 50.6562 | 50.5312 | 50.6562 | 1200.0 |
| 2000-11-08 10:30:00 | IWM | ETF | 50.5938 | 50.5938 | 50.5938 | 50.5938 | 22000.0 |
| 2000-11-08 11:00:00 | IWM | ETF | 50.5938 | 50.5938 | 50.375 | 50.5 | 50400.0 |
| 2000-11-08 11:30:00 | IWM | ETF | 50.5938 | 50.625 | 50.5938 | 50.625 | 32200.0 |
| 2000-11-08 12:00:00 | IWM | ETF | 50.625 | 50.6406 | 50.625 | 50.6406 | 10400.0 |
| 2000-11-08 12:30:00 | IWM | ETF | 50.625 | 50.625 | 50.625 | 50.625 | 10000.0 |
| 2000-11-08 13:00:00 | IWM | ETF | 50.75 | 50.75 | 50.5312 | 50.75 | 4000.0 |
| 2000-11-08 13:30:00 | IWM | ETF | 50.4062 | 50.5 | 50.4062 | 50.5 | 4200.0 |
| 2000-11-08 14:00:00 | IWM | ETF | 50.5156 | 50.5312 | 50.5156 | 50.5312 | 2600.0 |
| 2000-11-08 14:30:00 | IWM | ETF | 50.3438 | 50.5312 | 50.3438 | 50.3438 | 8800.0 |
| 2000-11-08 15:00:00 | IWM | ETF | 50.375 | 50.5156 | 50.3125 | 50.375 | 8400.0 |
| 2000-11-08 15:30:00 | IWM | ETF | 50.2812 | 50.2812 | 50.0 | 50.0 | 16000.0 |
| 2000-11-08 16:00:00 | IWM | ETF | 49.8438 | 50.0 | 49.7812 | 49.7812 | 20400.0 |
| 2000-11-08 09:30:00 | DIA | ETF | 110.0938 | 110.2188 | 109.4375 | 109.5 | 177900.0 |
| 2000-11-08 10:00:00 | DIA | ETF | 109.5938 | 109.5938 | 109.0625 | 109.5 | 136200.0 |
> showing 50 of 295 rows — these rows as CSV