PREVIEW / etf_30min / 2000-10-06
file: by_date/etf_30min/2000/2000-10-06.parquet size: 11 KB rows: 275
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-06 09:30:00 | SPY | ETF | 143.875 | 144.625 | 143.875 | 144.125 | 694600.0 |
| 2000-10-06 10:00:00 | SPY | ETF | 144.1562 | 144.3125 | 142.875 | 143.0 | 233200.0 |
| 2000-10-06 10:30:00 | SPY | ETF | 142.9062 | 143.125 | 141.375 | 141.875 | 1230000.0 |
| 2000-10-06 11:00:00 | SPY | ETF | 141.8438 | 142.25 | 141.5 | 141.7188 | 536600.0 |
| 2000-10-06 11:30:00 | SPY | ETF | 141.875 | 142.4375 | 141.75 | 141.9375 | 589700.0 |
| 2000-10-06 12:00:00 | SPY | ETF | 141.8438 | 142.2812 | 141.625 | 142.2188 | 592000.0 |
| 2000-10-06 12:30:00 | SPY | ETF | 142.25 | 142.25 | 141.5312 | 141.8125 | 862700.0 |
| 2000-10-06 13:00:00 | SPY | ETF | 141.875 | 141.9062 | 140.875 | 141.1562 | 546300.0 |
| 2000-10-06 13:30:00 | SPY | ETF | 141.125 | 141.625 | 140.9688 | 141.4062 | 577600.0 |
| 2000-10-06 14:00:00 | SPY | ETF | 141.375 | 141.7188 | 141.1875 | 141.4688 | 392300.0 |
| 2000-10-06 14:30:00 | SPY | ETF | 141.375 | 141.4062 | 140.5 | 140.8438 | 802300.0 |
| 2000-10-06 15:00:00 | SPY | ETF | 140.6875 | 141.0938 | 139.75 | 140.0312 | 978500.0 |
| 2000-10-06 15:30:00 | SPY | ETF | 140.0938 | 141.2188 | 140.0 | 141.0 | 1429000.0 |
| 2000-10-06 16:00:00 | SPY | ETF | 141.0938 | 141.25 | 141.0 | 141.0625 | 335300.0 |
| 2000-10-06 16:30:00 | SPY | ETF | 141.0625 | 141.0625 | 141.0625 | 141.0625 | 400.0 |
| 2000-10-06 09:30:00 | QQQ | ETF | 85.5625 | 86.5625 | 85.125 | 85.3125 | 2523300.0 |
| 2000-10-06 10:00:00 | QQQ | ETF | 85.375 | 85.875 | 84.375 | 84.4688 | 2392000.0 |
| 2000-10-06 10:30:00 | QQQ | ETF | 84.5 | 84.5 | 82.8125 | 83.4375 | 5200600.0 |
| 2000-10-06 11:00:00 | QQQ | ETF | 83.0625 | 84.125 | 82.625 | 83.2812 | 3527300.0 |
| 2000-10-06 11:30:00 | QQQ | ETF | 83.375 | 84.125 | 83.25 | 83.4375 | 1261200.0 |
| 2000-10-06 12:00:00 | QQQ | ETF | 83.375 | 83.8125 | 83.1875 | 83.6875 | 1041700.0 |
| 2000-10-06 12:30:00 | QQQ | ETF | 83.6562 | 83.9375 | 83.0 | 83.125 | 1126900.0 |
| 2000-10-06 13:00:00 | QQQ | ETF | 83.125 | 83.3438 | 82.375 | 82.8438 | 2191400.0 |
| 2000-10-06 13:30:00 | QQQ | ETF | 82.8438 | 83.6875 | 82.3438 | 83.375 | 3543400.0 |
| 2000-10-06 14:00:00 | QQQ | ETF | 83.3438 | 83.5 | 82.8125 | 83.1875 | 1195100.0 |
| 2000-10-06 14:30:00 | QQQ | ETF | 83.2188 | 83.25 | 81.8125 | 82.0938 | 3137600.0 |
| 2000-10-06 15:00:00 | QQQ | ETF | 82.1875 | 82.4375 | 81.25 | 81.7188 | 3441100.0 |
| 2000-10-06 15:30:00 | QQQ | ETF | 81.7188 | 83.0 | 81.625 | 82.7188 | 4327500.0 |
| 2000-10-06 16:00:00 | QQQ | ETF | 82.625 | 83.0 | 82.25 | 83.0 | 1189900.0 |
| 2000-10-06 16:30:00 | QQQ | ETF | 82.875 | 83.0 | 82.75 | 82.75 | 5800.0 |
| 2000-10-06 17:00:00 | QQQ | ETF | 83.0 | 83.0625 | 82.75 | 82.75 | 4700.0 |
| 2000-10-06 17:30:00 | QQQ | ETF | 83.0 | 83.0 | 83.0 | 83.0 | 1400.0 |
| 2000-10-06 18:00:00 | QQQ | ETF | 82.5625 | 83.0 | 82.5625 | 83.0 | 400.0 |
| 2000-10-06 09:30:00 | IWM | ETF | 50.1562 | 50.1562 | 50.125 | 50.125 | 8000.0 |
| 2000-10-06 10:00:00 | IWM | ETF | 50.0 | 50.0 | 49.9375 | 49.9375 | 1200.0 |
| 2000-10-06 10:30:00 | IWM | ETF | 49.7188 | 49.7188 | 49.4375 | 49.4375 | 2800.0 |
| 2000-10-06 11:00:00 | IWM | ETF | 49.4375 | 49.4375 | 49.2812 | 49.2812 | 600.0 |
| 2000-10-06 11:30:00 | IWM | ETF | 49.4688 | 49.4688 | 49.3125 | 49.3125 | 1200.0 |
| 2000-10-06 12:00:00 | IWM | ETF | 49.2812 | 49.2812 | 49.2812 | 49.2812 | 400.0 |
| 2000-10-06 12:30:00 | IWM | ETF | 49.4062 | 49.4062 | 49.2812 | 49.3125 | 3800.0 |
| 2000-10-06 13:00:00 | IWM | ETF | 49.1875 | 49.2188 | 49.0 | 49.0 | 23200.0 |
| 2000-10-06 13:30:00 | IWM | ETF | 49.0 | 49.125 | 49.0 | 49.0156 | 5600.0 |
| 2000-10-06 14:00:00 | IWM | ETF | 49.25 | 49.25 | 49.1875 | 49.1875 | 3200.0 |
| 2000-10-06 14:30:00 | IWM | ETF | 49.1875 | 49.1875 | 48.9375 | 48.9375 | 2000.0 |
| 2000-10-06 15:00:00 | IWM | ETF | 48.9062 | 48.9219 | 48.7812 | 48.8125 | 24600.0 |
| 2000-10-06 15:30:00 | IWM | ETF | 48.9375 | 49.0781 | 48.7812 | 49.0781 | 108800.0 |
| 2000-10-06 16:00:00 | IWM | ETF | 48.8438 | 48.8438 | 48.8438 | 48.8438 | 200.0 |
| 2000-10-06 09:30:00 | DIA | ETF | 107.25 | 107.875 | 107.25 | 107.625 | 154700.0 |
| 2000-10-06 10:00:00 | DIA | ETF | 107.75 | 107.9688 | 107.125 | 107.125 | 54800.0 |
| 2000-10-06 10:30:00 | DIA | ETF | 107.1875 | 107.1875 | 106.0938 | 106.375 | 100600.0 |
> showing 50 of 275 rows — these rows as CSV