PREVIEW / etf_30min / 2000-04-07
file: by_date/etf_30min/2000/2000-04-07.parquet size: 9 KB rows: 188
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-04-07 09:30:00 | SPY | ETF | 151.5625 | 151.6875 | 150.5 | 150.5938 | 485700.0 |
| 2000-04-07 10:00:00 | SPY | ETF | 151.0 | 151.2812 | 150.5312 | 151.125 | 431500.0 |
| 2000-04-07 10:30:00 | SPY | ETF | 151.25 | 151.6562 | 150.9062 | 151.6562 | 378900.0 |
| 2000-04-07 11:00:00 | SPY | ETF | 151.5625 | 152.0625 | 151.4688 | 151.5625 | 212000.0 |
| 2000-04-07 11:30:00 | SPY | ETF | 151.5625 | 151.8438 | 151.375 | 151.6875 | 103700.0 |
| 2000-04-07 12:00:00 | SPY | ETF | 151.6562 | 152.125 | 151.4688 | 152.0 | 382300.0 |
| 2000-04-07 12:30:00 | SPY | ETF | 152.0625 | 152.125 | 151.6875 | 151.75 | 258100.0 |
| 2000-04-07 13:00:00 | SPY | ETF | 151.8125 | 152.0938 | 151.625 | 151.625 | 36400.0 |
| 2000-04-07 13:30:00 | SPY | ETF | 151.4688 | 151.7188 | 151.25 | 151.25 | 487800.0 |
| 2000-04-07 14:00:00 | SPY | ETF | 151.125 | 151.4375 | 150.7812 | 151.0 | 1042800.0 |
| 2000-04-07 14:30:00 | SPY | ETF | 150.9375 | 151.3125 | 150.6562 | 151.0625 | 669200.0 |
| 2000-04-07 15:00:00 | SPY | ETF | 151.0625 | 151.875 | 151.0 | 151.6875 | 329100.0 |
| 2000-04-07 15:30:00 | SPY | ETF | 151.5312 | 151.9688 | 151.375 | 151.375 | 529800.0 |
| 2000-04-07 09:30:00 | QQQ | ETF | 104.125 | 104.5 | 102.875 | 103.1875 | 4605200.0 |
| 2000-04-07 10:00:00 | QQQ | ETF | 103.1875 | 104.25 | 102.9375 | 104.25 | 1627400.0 |
| 2000-04-07 10:30:00 | QQQ | ETF | 104.375 | 104.9688 | 104.0625 | 104.8125 | 1352900.0 |
| 2000-04-07 11:00:00 | QQQ | ETF | 105.0 | 105.75 | 104.875 | 105.0312 | 2234900.0 |
| 2000-04-07 11:30:00 | QQQ | ETF | 105.125 | 105.375 | 104.8125 | 105.0625 | 865300.0 |
| 2000-04-07 12:00:00 | QQQ | ETF | 105.0 | 105.75 | 104.75 | 105.625 | 726300.0 |
| 2000-04-07 12:30:00 | QQQ | ETF | 105.625 | 105.75 | 104.9375 | 105.0625 | 1334000.0 |
| 2000-04-07 13:00:00 | QQQ | ETF | 105.0625 | 105.7188 | 105.0 | 105.0625 | 706100.0 |
| 2000-04-07 13:30:00 | QQQ | ETF | 105.125 | 105.4688 | 104.875 | 104.875 | 729000.0 |
| 2000-04-07 14:00:00 | QQQ | ETF | 104.9375 | 105.25 | 104.2188 | 104.625 | 1176800.0 |
| 2000-04-07 14:30:00 | QQQ | ETF | 104.625 | 105.125 | 104.25 | 104.8125 | 1196200.0 |
| 2000-04-07 15:00:00 | QQQ | ETF | 104.875 | 105.875 | 104.875 | 105.8125 | 1148700.0 |
| 2000-04-07 15:30:00 | QQQ | ETF | 105.8125 | 107.0 | 105.6875 | 107.0 | 2192300.0 |
| 2000-04-07 16:00:00 | QQQ | ETF | 106.9375 | 107.375 | 106.75 | 106.875 | 466700.0 |
| 2000-04-07 09:30:00 | DIA | ETF | 111.9688 | 111.9688 | 110.8125 | 111.0625 | 329100.0 |
| 2000-04-07 10:00:00 | DIA | ETF | 111.0625 | 111.4062 | 110.9062 | 111.4062 | 65400.0 |
| 2000-04-07 10:30:00 | DIA | ETF | 111.4375 | 111.5625 | 110.9062 | 111.1562 | 31200.0 |
| 2000-04-07 11:00:00 | DIA | ETF | 111.4375 | 111.75 | 111.3125 | 111.3125 | 53700.0 |
| 2000-04-07 11:30:00 | DIA | ETF | 111.2812 | 111.5 | 111.125 | 111.25 | 10900.0 |
| 2000-04-07 12:00:00 | DIA | ETF | 111.4375 | 111.7188 | 111.25 | 111.5938 | 17300.0 |
| 2000-04-07 12:30:00 | DIA | ETF | 111.6875 | 111.7188 | 111.4375 | 111.4375 | 72200.0 |
| 2000-04-07 13:00:00 | DIA | ETF | 111.5 | 111.7188 | 111.5 | 111.5 | 28300.0 |
| 2000-04-07 13:30:00 | DIA | ETF | 111.5312 | 111.5312 | 111.25 | 111.25 | 19700.0 |
| 2000-04-07 14:00:00 | DIA | ETF | 111.1875 | 111.3438 | 110.7812 | 110.8125 | 52000.0 |
| 2000-04-07 14:30:00 | DIA | ETF | 110.75 | 111.1562 | 110.5625 | 111.0 | 38600.0 |
| 2000-04-07 15:00:00 | DIA | ETF | 110.9688 | 111.3438 | 110.7812 | 110.875 | 75000.0 |
| 2000-04-07 15:30:00 | DIA | ETF | 111.1875 | 111.25 | 110.6875 | 110.9375 | 155800.0 |
| 2000-04-07 16:00:00 | DIA | ETF | 111.0 | 111.1562 | 110.875 | 110.875 | 527100.0 |
> showing 41 of 188 rows — these rows as CSV