PREVIEW / etf_30min / 2000-08-29
file: by_date/etf_30min/2000/2000-08-29.parquet size: 11 KB rows: 285
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-08-29 09:30:00 | SPY | ETF | 151.4375 | 151.6875 | 151.3438 | 151.625 | 534000.0 |
| 2000-08-29 10:00:00 | SPY | ETF | 151.5625 | 151.75 | 151.4062 | 151.6875 | 198200.0 |
| 2000-08-29 10:30:00 | SPY | ETF | 151.7188 | 151.7188 | 150.9062 | 151.0 | 434100.0 |
| 2000-08-29 11:00:00 | SPY | ETF | 151.0 | 151.25 | 150.9375 | 151.1875 | 97200.0 |
| 2000-08-29 11:30:00 | SPY | ETF | 151.0938 | 151.375 | 151.0312 | 151.25 | 198900.0 |
| 2000-08-29 12:00:00 | SPY | ETF | 151.3438 | 151.6875 | 151.25 | 151.5938 | 48000.0 |
| 2000-08-29 12:30:00 | SPY | ETF | 151.5 | 151.7812 | 151.4375 | 151.7188 | 91400.0 |
| 2000-08-29 13:00:00 | SPY | ETF | 151.6562 | 151.875 | 151.5 | 151.875 | 166400.0 |
| 2000-08-29 13:30:00 | SPY | ETF | 151.6875 | 151.875 | 151.4688 | 151.5625 | 213500.0 |
| 2000-08-29 14:00:00 | SPY | ETF | 151.5 | 151.625 | 151.4375 | 151.5 | 240600.0 |
| 2000-08-29 14:30:00 | SPY | ETF | 151.5 | 151.5625 | 151.125 | 151.2812 | 206100.0 |
| 2000-08-29 15:00:00 | SPY | ETF | 151.375 | 151.6875 | 151.2812 | 151.4688 | 393700.0 |
| 2000-08-29 15:30:00 | SPY | ETF | 151.4062 | 151.625 | 151.2812 | 151.5 | 367100.0 |
| 2000-08-29 16:00:00 | SPY | ETF | 151.5625 | 151.8438 | 151.3125 | 151.7812 | 271300.0 |
| 2000-08-29 09:30:00 | QQQ | ETF | 98.625 | 98.9688 | 98.125 | 98.7188 | 1836600.0 |
| 2000-08-29 10:00:00 | QQQ | ETF | 98.75 | 98.9688 | 98.375 | 98.875 | 903600.0 |
| 2000-08-29 10:30:00 | QQQ | ETF | 98.875 | 98.9375 | 97.8438 | 97.875 | 1341400.0 |
| 2000-08-29 11:00:00 | QQQ | ETF | 97.9062 | 98.3438 | 97.875 | 98.25 | 726700.0 |
| 2000-08-29 11:30:00 | QQQ | ETF | 98.2188 | 98.625 | 98.0312 | 98.4375 | 504100.0 |
| 2000-08-29 12:00:00 | QQQ | ETF | 98.4375 | 98.8438 | 98.375 | 98.6875 | 984600.0 |
| 2000-08-29 12:30:00 | QQQ | ETF | 98.5625 | 98.9375 | 98.4375 | 98.875 | 578900.0 |
| 2000-08-29 13:00:00 | QQQ | ETF | 98.875 | 99.125 | 98.75 | 99.0 | 950200.0 |
| 2000-08-29 13:30:00 | QQQ | ETF | 99.0 | 99.125 | 98.625 | 98.75 | 644500.0 |
| 2000-08-29 14:00:00 | QQQ | ETF | 98.6875 | 98.75 | 98.5 | 98.6562 | 399400.0 |
| 2000-08-29 14:30:00 | QQQ | ETF | 98.6562 | 98.6562 | 98.3125 | 98.4688 | 416000.0 |
| 2000-08-29 15:00:00 | QQQ | ETF | 98.4375 | 99.1562 | 98.4062 | 98.8438 | 805300.0 |
| 2000-08-29 15:30:00 | QQQ | ETF | 98.8438 | 98.9375 | 98.5 | 98.625 | 851200.0 |
| 2000-08-29 16:00:00 | QQQ | ETF | 98.6562 | 99.125 | 98.5625 | 99.125 | 184500.0 |
| 2000-08-29 16:30:00 | QQQ | ETF | 98.5 | 98.5 | 98.5 | 98.5 | 1000.0 |
| 2000-08-29 17:00:00 | QQQ | ETF | 99.125 | 99.125 | 99.125 | 99.125 | 200.0 |
| 2000-08-29 17:30:00 | QQQ | ETF | 99.0 | 99.0 | 99.0 | 99.0 | 100.0 |
| 2000-08-29 09:30:00 | IWM | ETF | 52.7812 | 52.7812 | 52.7812 | 52.7812 | 1800.0 |
| 2000-08-29 10:00:00 | IWM | ETF | 52.9219 | 53.0 | 52.9219 | 52.9531 | 2400.0 |
| 2000-08-29 10:30:00 | IWM | ETF | 52.9688 | 52.9688 | 52.6562 | 52.6562 | 6800.0 |
| 2000-08-29 11:00:00 | IWM | ETF | 52.625 | 52.75 | 52.625 | 52.75 | 6800.0 |
| 2000-08-29 11:30:00 | IWM | ETF | 52.7812 | 52.8125 | 52.7812 | 52.8125 | 8400.0 |
| 2000-08-29 13:00:00 | IWM | ETF | 52.8438 | 52.8438 | 52.8438 | 52.8438 | 1000.0 |
| 2000-08-29 13:30:00 | IWM | ETF | 53.0 | 53.0938 | 53.0 | 53.0 | 20600.0 |
| 2000-08-29 14:30:00 | IWM | ETF | 52.9375 | 52.9844 | 52.8438 | 52.9844 | 34800.0 |
| 2000-08-29 15:00:00 | IWM | ETF | 53.0 | 53.1094 | 53.0 | 53.1094 | 4200.0 |
| 2000-08-29 15:30:00 | IWM | ETF | 53.1094 | 53.125 | 53.0781 | 53.125 | 3400.0 |
| 2000-08-29 16:00:00 | IWM | ETF | 53.1562 | 53.1562 | 53.1562 | 53.1562 | 50000.0 |
| 2000-08-29 09:30:00 | DIA | ETF | 112.4375 | 112.5 | 112.125 | 112.25 | 67800.0 |
| 2000-08-29 10:00:00 | DIA | ETF | 112.2812 | 112.4062 | 112.125 | 112.2812 | 55100.0 |
| 2000-08-29 10:30:00 | DIA | ETF | 112.25 | 112.2812 | 112.0 | 112.125 | 24200.0 |
| 2000-08-29 11:00:00 | DIA | ETF | 112.125 | 112.2188 | 112.0 | 112.0312 | 29000.0 |
| 2000-08-29 11:30:00 | DIA | ETF | 112.0312 | 112.2812 | 112.0312 | 112.2188 | 25900.0 |
| 2000-08-29 12:00:00 | DIA | ETF | 112.1875 | 112.4062 | 112.1875 | 112.25 | 10700.0 |
| 2000-08-29 12:30:00 | DIA | ETF | 112.25 | 112.5 | 112.25 | 112.3438 | 24100.0 |
| 2000-08-29 13:00:00 | DIA | ETF | 112.5 | 112.625 | 112.3125 | 112.5938 | 7900.0 |
> showing 50 of 285 rows — these rows as CSV