PREVIEW / etf_30min / 2000-06-01
file: by_date/etf_30min/2000/2000-06-01.parquet size: 10 KB rows: 220
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-06-01 09:30:00 | SPY | ETF | 143.6875 | 144.125 | 143.0 | 143.6875 | 1231500.0 |
| 2000-06-01 10:00:00 | SPY | ETF | 143.8125 | 144.875 | 143.6562 | 144.7812 | 959500.0 |
| 2000-06-01 10:30:00 | SPY | ETF | 144.7812 | 145.3438 | 144.5938 | 144.875 | 433200.0 |
| 2000-06-01 11:00:00 | SPY | ETF | 145.0625 | 145.0938 | 144.6562 | 144.8125 | 421500.0 |
| 2000-06-01 11:30:00 | SPY | ETF | 144.875 | 145.25 | 144.7188 | 145.1875 | 529600.0 |
| 2000-06-01 12:00:00 | SPY | ETF | 145.2188 | 145.375 | 144.9062 | 145.0625 | 666500.0 |
| 2000-06-01 12:30:00 | SPY | ETF | 145.0 | 145.0938 | 144.75 | 144.9062 | 408500.0 |
| 2000-06-01 13:00:00 | SPY | ETF | 144.875 | 145.0 | 144.5 | 144.5 | 345900.0 |
| 2000-06-01 13:30:00 | SPY | ETF | 144.5 | 144.9375 | 144.3125 | 144.375 | 389800.0 |
| 2000-06-01 14:00:00 | SPY | ETF | 144.3438 | 144.6875 | 144.25 | 144.6875 | 432600.0 |
| 2000-06-01 14:30:00 | SPY | ETF | 144.5938 | 144.7188 | 143.75 | 144.0 | 466500.0 |
| 2000-06-01 15:00:00 | SPY | ETF | 143.9688 | 144.7188 | 143.9062 | 144.4062 | 545700.0 |
| 2000-06-01 15:30:00 | SPY | ETF | 144.5312 | 145.3438 | 144.5312 | 145.1562 | 928400.0 |
| 2000-06-01 16:00:00 | SPY | ETF | 145.0625 | 145.4375 | 145.0312 | 145.3125 | 661300.0 |
| 2000-06-01 09:30:00 | QQQ | ETF | 85.1875 | 86.1562 | 84.5312 | 85.75 | 3945200.0 |
| 2000-06-01 10:00:00 | QQQ | ETF | 85.5625 | 86.9375 | 85.5 | 86.6875 | 3781800.0 |
| 2000-06-01 10:30:00 | QQQ | ETF | 86.625 | 87.25 | 86.5 | 86.8125 | 2756500.0 |
| 2000-06-01 11:00:00 | QQQ | ETF | 86.8125 | 87.0 | 86.4375 | 86.6875 | 1591100.0 |
| 2000-06-01 11:30:00 | QQQ | ETF | 86.625 | 87.125 | 86.5625 | 87.125 | 1425400.0 |
| 2000-06-01 12:00:00 | QQQ | ETF | 87.125 | 87.7188 | 86.875 | 87.25 | 1853800.0 |
| 2000-06-01 12:30:00 | QQQ | ETF | 87.25 | 87.5 | 86.875 | 87.3125 | 1303000.0 |
| 2000-06-01 13:00:00 | QQQ | ETF | 87.25 | 87.375 | 86.9375 | 87.1875 | 961800.0 |
| 2000-06-01 13:30:00 | QQQ | ETF | 87.0938 | 87.4062 | 86.5 | 86.625 | 1699900.0 |
| 2000-06-01 14:00:00 | QQQ | ETF | 86.5625 | 87.125 | 86.3125 | 87.0625 | 1464800.0 |
| 2000-06-01 14:30:00 | QQQ | ETF | 87.0312 | 87.0938 | 85.7188 | 86.3125 | 1855000.0 |
| 2000-06-01 15:00:00 | QQQ | ETF | 86.3125 | 87.5 | 85.8438 | 87.0 | 2032600.0 |
| 2000-06-01 15:30:00 | QQQ | ETF | 87.0 | 88.375 | 86.9375 | 87.625 | 3593000.0 |
| 2000-06-01 16:00:00 | QQQ | ETF | 87.75 | 87.8125 | 87.375 | 87.4688 | 610700.0 |
| 2000-06-01 16:30:00 | QQQ | ETF | 85.75 | 87.5 | 85.75 | 87.5 | 16400.0 |
| 2000-06-01 17:00:00 | QQQ | ETF | 87.5 | 87.5 | 87.5 | 87.5 | 1400.0 |
| 2000-06-01 17:30:00 | QQQ | ETF | 87.5 | 87.5625 | 87.375 | 87.375 | 4700.0 |
| 2000-06-01 10:00:00 | IWM | ETF | 48.5469 | 48.5469 | 48.5469 | 48.5469 | 600.0 |
| 2000-06-01 11:00:00 | IWM | ETF | 48.5938 | 48.625 | 48.5938 | 48.625 | 1400.0 |
| 2000-06-01 13:30:00 | IWM | ETF | 48.6562 | 48.6562 | 48.6562 | 48.6562 | 5000.0 |
| 2000-06-01 09:30:00 | DIA | ETF | 105.9688 | 106.0 | 105.3438 | 105.8438 | 40800.0 |
| 2000-06-01 10:00:00 | DIA | ETF | 105.6875 | 106.375 | 105.5938 | 106.25 | 279100.0 |
| 2000-06-01 10:30:00 | DIA | ETF | 106.4062 | 106.625 | 106.3125 | 106.4688 | 165300.0 |
| 2000-06-01 11:00:00 | DIA | ETF | 106.625 | 106.625 | 106.25 | 106.5 | 34000.0 |
| 2000-06-01 11:30:00 | DIA | ETF | 106.625 | 106.8125 | 106.4062 | 106.8125 | 40100.0 |
| 2000-06-01 12:00:00 | DIA | ETF | 106.75 | 107.0 | 106.625 | 106.6875 | 33700.0 |
| 2000-06-01 12:30:00 | DIA | ETF | 106.75 | 106.75 | 106.375 | 106.5 | 30200.0 |
| 2000-06-01 13:00:00 | DIA | ETF | 106.5312 | 106.5312 | 106.125 | 106.1562 | 22500.0 |
| 2000-06-01 13:30:00 | DIA | ETF | 106.1562 | 106.4688 | 106.125 | 106.125 | 19900.0 |
| 2000-06-01 14:00:00 | DIA | ETF | 106.125 | 106.5 | 106.125 | 106.5 | 10700.0 |
| 2000-06-01 14:30:00 | DIA | ETF | 106.3438 | 106.375 | 105.6875 | 105.8125 | 22900.0 |
| 2000-06-01 15:00:00 | DIA | ETF | 106.0 | 106.3125 | 105.75 | 106.0625 | 18000.0 |
| 2000-06-01 15:30:00 | DIA | ETF | 106.25 | 106.5625 | 106.1562 | 106.5625 | 57800.0 |
| 2000-06-01 16:00:00 | DIA | ETF | 106.5 | 106.6875 | 106.4375 | 106.5 | 16400.0 |
> showing 48 of 220 rows — these rows as CSV