PREVIEW / etf_30min / 2000-04-03
file: by_date/etf_30min/2000/2000-04-03.parquet size: 10 KB rows: 222
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-03 09:30:00 | SPY | ETF | 150.125 | 150.875 | 150.0 | 150.5 | 1339700.0 |
| 2000-04-03 10:00:00 | SPY | ETF | 150.6875 | 150.875 | 148.6875 | 149.375 | 1072900.0 |
| 2000-04-03 10:30:00 | SPY | ETF | 149.375 | 150.6562 | 149.3125 | 150.625 | 687000.0 |
| 2000-04-03 11:00:00 | SPY | ETF | 150.4062 | 150.8438 | 149.8438 | 149.9062 | 858700.0 |
| 2000-04-03 11:30:00 | SPY | ETF | 150.0 | 150.2812 | 149.5 | 149.625 | 317100.0 |
| 2000-04-03 12:00:00 | SPY | ETF | 149.5312 | 150.3438 | 149.4375 | 150.0312 | 263600.0 |
| 2000-04-03 12:30:00 | SPY | ETF | 150.1875 | 150.1875 | 149.5 | 149.8438 | 215400.0 |
| 2000-04-03 13:00:00 | SPY | ETF | 149.9688 | 150.0625 | 149.3438 | 149.3438 | 201400.0 |
| 2000-04-03 13:30:00 | SPY | ETF | 149.375 | 150.5 | 149.375 | 150.3438 | 317400.0 |
| 2000-04-03 14:00:00 | SPY | ETF | 150.25 | 150.875 | 150.0625 | 150.7812 | 394000.0 |
| 2000-04-03 14:30:00 | SPY | ETF | 150.5938 | 151.0 | 150.125 | 150.1562 | 349100.0 |
| 2000-04-03 15:00:00 | SPY | ETF | 150.0625 | 150.5625 | 149.6875 | 150.25 | 394500.0 |
| 2000-04-03 15:30:00 | SPY | ETF | 150.375 | 151.0312 | 149.75 | 150.75 | 570000.0 |
| 2000-04-03 16:00:00 | SPY | ETF | 150.75 | 151.25 | 150.75 | 151.25 | 647100.0 |
| 2000-04-03 09:30:00 | QQQ | ETF | 107.75 | 109.125 | 106.625 | 107.125 | 3619500.0 |
| 2000-04-03 10:00:00 | QQQ | ETF | 107.125 | 107.625 | 103.5 | 105.375 | 3100600.0 |
| 2000-04-03 10:30:00 | QQQ | ETF | 105.1875 | 106.5 | 104.625 | 106.3125 | 2438700.0 |
| 2000-04-03 11:00:00 | QQQ | ETF | 106.1875 | 106.375 | 104.0 | 104.125 | 1871600.0 |
| 2000-04-03 11:30:00 | QQQ | ETF | 104.0 | 105.0625 | 103.5 | 103.8125 | 2242200.0 |
| 2000-04-03 12:00:00 | QQQ | ETF | 103.5 | 105.25 | 103.25 | 104.5 | 1831700.0 |
| 2000-04-03 12:30:00 | QQQ | ETF | 104.4375 | 104.9062 | 103.5625 | 104.0 | 1034900.0 |
| 2000-04-03 13:00:00 | QQQ | ETF | 104.0 | 104.5625 | 103.0625 | 103.375 | 1346400.0 |
| 2000-04-03 13:30:00 | QQQ | ETF | 103.5 | 104.9375 | 103.25 | 104.625 | 1794000.0 |
| 2000-04-03 14:00:00 | QQQ | ETF | 104.625 | 105.4375 | 104.0 | 105.0625 | 1671000.0 |
| 2000-04-03 14:30:00 | QQQ | ETF | 105.25 | 105.5 | 103.625 | 103.6562 | 1980200.0 |
| 2000-04-03 15:00:00 | QQQ | ETF | 103.5 | 103.75 | 102.125 | 103.0625 | 3049700.0 |
| 2000-04-03 15:30:00 | QQQ | ETF | 102.75 | 103.375 | 100.75 | 102.1875 | 3897500.0 |
| 2000-04-03 16:00:00 | QQQ | ETF | 102.25 | 102.625 | 102.0 | 102.125 | 1373800.0 |
| 2000-04-03 16:30:00 | QQQ | ETF | 103.0 | 103.0 | 102.0 | 102.0 | 7900.0 |
| 2000-04-03 17:00:00 | QQQ | ETF | 102.0 | 103.5 | 102.0 | 103.0 | 2300.0 |
| 2000-04-03 17:30:00 | QQQ | ETF | 103.4375 | 103.625 | 102.0 | 102.5 | 3900.0 |
| 2000-04-03 18:00:00 | QQQ | ETF | 102.5 | 103.0 | 102.5 | 102.9375 | 10300.0 |
| 2000-04-03 09:30:00 | DIA | ETF | 109.3125 | 110.6562 | 109.3125 | 110.6562 | 58000.0 |
| 2000-04-03 10:00:00 | DIA | ETF | 110.6562 | 110.7188 | 109.125 | 109.8125 | 255500.0 |
| 2000-04-03 10:30:00 | DIA | ETF | 109.8125 | 110.5 | 109.6562 | 110.5 | 105500.0 |
| 2000-04-03 11:00:00 | DIA | ETF | 110.4688 | 110.9375 | 110.25 | 110.4062 | 179400.0 |
| 2000-04-03 11:30:00 | DIA | ETF | 110.625 | 110.9062 | 110.4688 | 110.4688 | 32900.0 |
| 2000-04-03 12:00:00 | DIA | ETF | 110.4688 | 111.0625 | 110.375 | 110.7188 | 60400.0 |
| 2000-04-03 12:30:00 | DIA | ETF | 110.75 | 110.875 | 110.5312 | 110.625 | 31500.0 |
| 2000-04-03 13:00:00 | DIA | ETF | 110.75 | 110.8438 | 110.2812 | 110.5938 | 29500.0 |
| 2000-04-03 13:30:00 | DIA | ETF | 110.625 | 111.2812 | 110.5 | 111.0625 | 52000.0 |
| 2000-04-03 14:00:00 | DIA | ETF | 111.2188 | 111.7188 | 111.0 | 111.5 | 124100.0 |
| 2000-04-03 14:30:00 | DIA | ETF | 111.6562 | 111.875 | 111.25 | 111.2812 | 47000.0 |
| 2000-04-03 15:00:00 | DIA | ETF | 111.3438 | 111.5625 | 111.1875 | 111.4688 | 203600.0 |
| 2000-04-03 15:30:00 | DIA | ETF | 111.3125 | 112.4688 | 111.2812 | 112.25 | 174500.0 |
| 2000-04-03 16:00:00 | DIA | ETF | 112.25 | 112.6875 | 112.2188 | 112.6875 | 55800.0 |
> showing 46 of 222 rows — these rows as CSV