PREVIEW / etf_30min / 2000-08-25
file: by_date/etf_30min/2000/2000-08-25.parquet size: 10 KB rows: 252
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-25 09:30:00 | SPY | ETF | 151.1562 | 151.625 | 151.1562 | 151.375 | 773600.0 |
| 2000-08-25 10:00:00 | SPY | ETF | 151.375 | 151.625 | 151.2188 | 151.3125 | 104700.0 |
| 2000-08-25 10:30:00 | SPY | ETF | 151.375 | 151.4375 | 150.9375 | 151.125 | 307900.0 |
| 2000-08-25 11:00:00 | SPY | ETF | 151.0312 | 151.3125 | 151.0312 | 151.25 | 410900.0 |
| 2000-08-25 11:30:00 | SPY | ETF | 151.25 | 151.4375 | 151.0312 | 151.4375 | 147300.0 |
| 2000-08-25 12:00:00 | SPY | ETF | 151.375 | 151.4062 | 151.25 | 151.375 | 161600.0 |
| 2000-08-25 12:30:00 | SPY | ETF | 151.375 | 151.5938 | 151.3438 | 151.4688 | 65800.0 |
| 2000-08-25 13:00:00 | SPY | ETF | 151.5625 | 151.5938 | 151.375 | 151.5312 | 102800.0 |
| 2000-08-25 13:30:00 | SPY | ETF | 151.5938 | 151.5938 | 151.125 | 151.2188 | 145000.0 |
| 2000-08-25 14:00:00 | SPY | ETF | 151.125 | 151.4375 | 151.125 | 151.1875 | 123200.0 |
| 2000-08-25 14:30:00 | SPY | ETF | 151.25 | 151.5 | 151.1562 | 151.3125 | 104200.0 |
| 2000-08-25 15:00:00 | SPY | ETF | 151.25 | 151.375 | 151.0 | 151.0938 | 106400.0 |
| 2000-08-25 15:30:00 | SPY | ETF | 151.0938 | 151.2812 | 151.0312 | 151.0938 | 140900.0 |
| 2000-08-25 16:00:00 | SPY | ETF | 151.1562 | 151.3125 | 151.0938 | 151.25 | 125300.0 |
| 2000-08-25 09:30:00 | QQQ | ETF | 98.4688 | 99.4688 | 98.1875 | 99.0312 | 2877800.0 |
| 2000-08-25 10:00:00 | QQQ | ETF | 99.0312 | 99.375 | 98.5625 | 98.75 | 1361100.0 |
| 2000-08-25 10:30:00 | QQQ | ETF | 98.75 | 98.875 | 97.625 | 98.0625 | 1591100.0 |
| 2000-08-25 11:00:00 | QQQ | ETF | 98.0938 | 98.5 | 98.0 | 98.4062 | 1055500.0 |
| 2000-08-25 11:30:00 | QQQ | ETF | 98.375 | 98.5938 | 97.875 | 98.5938 | 552200.0 |
| 2000-08-25 12:00:00 | QQQ | ETF | 98.5 | 98.5938 | 98.2812 | 98.5 | 669600.0 |
| 2000-08-25 12:30:00 | QQQ | ETF | 98.5 | 98.8438 | 98.375 | 98.625 | 386600.0 |
| 2000-08-25 13:00:00 | QQQ | ETF | 98.6562 | 98.9062 | 98.0 | 98.5312 | 258100.0 |
| 2000-08-25 13:30:00 | QQQ | ETF | 98.5 | 98.6875 | 97.875 | 98.0312 | 796000.0 |
| 2000-08-25 14:00:00 | QQQ | ETF | 98.0 | 98.3125 | 97.9375 | 98.1875 | 295300.0 |
| 2000-08-25 14:30:00 | QQQ | ETF | 98.2188 | 98.5 | 98.125 | 98.2812 | 286300.0 |
| 2000-08-25 15:00:00 | QQQ | ETF | 98.25 | 98.3438 | 97.8125 | 98.0625 | 564600.0 |
| 2000-08-25 15:30:00 | QQQ | ETF | 98.0625 | 98.2188 | 97.8125 | 98.125 | 740000.0 |
| 2000-08-25 16:00:00 | QQQ | ETF | 98.0625 | 98.4375 | 98.0625 | 98.375 | 280800.0 |
| 2000-08-25 16:30:00 | QQQ | ETF | 98.3125 | 98.3125 | 98.3125 | 98.3125 | 1500.0 |
| 2000-08-25 17:30:00 | QQQ | ETF | 98.1875 | 98.1875 | 98.0312 | 98.0312 | 500.0 |
| 2000-08-25 09:30:00 | IWM | ETF | 52.375 | 52.6875 | 52.375 | 52.6875 | 76400.0 |
| 2000-08-25 10:30:00 | IWM | ETF | 52.375 | 52.3906 | 52.2188 | 52.2656 | 57000.0 |
| 2000-08-25 11:00:00 | IWM | ETF | 52.5 | 52.5 | 52.3125 | 52.3125 | 52400.0 |
| 2000-08-25 11:30:00 | IWM | ETF | 52.5156 | 52.5156 | 52.3281 | 52.3281 | 1600.0 |
| 2000-08-25 12:00:00 | IWM | ETF | 52.375 | 52.375 | 52.375 | 52.375 | 1200.0 |
| 2000-08-25 12:30:00 | IWM | ETF | 52.5938 | 52.5938 | 52.5 | 52.5 | 6200.0 |
| 2000-08-25 13:00:00 | IWM | ETF | 52.5781 | 52.5938 | 52.5312 | 52.5938 | 600.0 |
| 2000-08-25 13:30:00 | IWM | ETF | 52.5 | 52.5469 | 52.4375 | 52.4844 | 3200.0 |
| 2000-08-25 14:00:00 | IWM | ETF | 52.4844 | 52.4844 | 52.4844 | 52.4844 | 400.0 |
| 2000-08-25 16:00:00 | IWM | ETF | 52.5625 | 52.5625 | 52.5625 | 52.5625 | 9600.0 |
| 2000-08-25 09:30:00 | DIA | ETF | 111.875 | 112.1875 | 111.6875 | 111.75 | 40200.0 |
| 2000-08-25 10:00:00 | DIA | ETF | 111.7188 | 111.9375 | 111.5938 | 111.75 | 17500.0 |
| 2000-08-25 10:30:00 | DIA | ETF | 111.9062 | 111.9062 | 111.5312 | 111.625 | 8500.0 |
| 2000-08-25 11:00:00 | DIA | ETF | 111.625 | 111.9688 | 111.625 | 111.8125 | 10500.0 |
| 2000-08-25 11:30:00 | DIA | ETF | 111.7812 | 111.9062 | 111.6875 | 111.9062 | 7700.0 |
| 2000-08-25 12:00:00 | DIA | ETF | 111.9688 | 111.9688 | 111.8125 | 111.9688 | 500.0 |
| 2000-08-25 12:30:00 | DIA | ETF | 111.9375 | 112.25 | 111.9375 | 112.25 | 19200.0 |
| 2000-08-25 13:00:00 | DIA | ETF | 112.2188 | 112.2188 | 112.0312 | 112.1562 | 2900.0 |
| 2000-08-25 13:30:00 | DIA | ETF | 112.2188 | 112.2188 | 111.8438 | 112.0 | 6100.0 |
| 2000-08-25 14:00:00 | DIA | ETF | 111.875 | 111.9688 | 111.8438 | 111.875 | 1900.0 |
> showing 50 of 252 rows — these rows as CSV