PREVIEW / etf_30min / 2000-02-08
file: by_date/etf_30min/2000/2000-02-08.parquet size: 10 KB rows: 230
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-02-08 09:30:00 | SPY | ETF | 143.9688 | 144.5 | 143.75 | 144.375 | 1266100.0 |
| 2000-02-08 10:00:00 | SPY | ETF | 144.3125 | 144.4062 | 144.0 | 144.375 | 799700.0 |
| 2000-02-08 10:30:00 | SPY | ETF | 144.2188 | 144.5312 | 143.7812 | 143.9062 | 311700.0 |
| 2000-02-08 11:00:00 | SPY | ETF | 143.9375 | 144.2188 | 143.75 | 144.0625 | 173700.0 |
| 2000-02-08 11:30:00 | SPY | ETF | 144.0625 | 144.1875 | 143.7812 | 143.9688 | 118300.0 |
| 2000-02-08 12:00:00 | SPY | ETF | 144.0 | 144.2188 | 143.8125 | 143.8125 | 87300.0 |
| 2000-02-08 12:30:00 | SPY | ETF | 144.0312 | 144.125 | 143.625 | 143.9375 | 379600.0 |
| 2000-02-08 13:00:00 | SPY | ETF | 143.9375 | 144.0938 | 143.6562 | 144.0 | 91400.0 |
| 2000-02-08 13:30:00 | SPY | ETF | 143.9688 | 144.2188 | 143.9688 | 144.0 | 94500.0 |
| 2000-02-08 14:00:00 | SPY | ETF | 144.0312 | 144.3438 | 143.875 | 144.1875 | 209700.0 |
| 2000-02-08 14:30:00 | SPY | ETF | 144.125 | 144.3125 | 143.875 | 144.25 | 350200.0 |
| 2000-02-08 15:00:00 | SPY | ETF | 144.2812 | 144.5625 | 144.0 | 144.0 | 241500.0 |
| 2000-02-08 15:30:00 | SPY | ETF | 144.0 | 144.5 | 143.7812 | 144.2812 | 395200.0 |
| 2000-02-08 16:00:00 | SPY | ETF | 144.3125 | 144.5312 | 144.1875 | 144.3125 | 379700.0 |
| 2000-02-08 09:30:00 | QQQ | ETF | 99.375 | 100.5 | 99.375 | 100.0938 | 4461200.0 |
| 2000-02-08 10:00:00 | QQQ | ETF | 100.1875 | 100.4688 | 99.8125 | 100.25 | 2389600.0 |
| 2000-02-08 10:30:00 | QQQ | ETF | 100.1875 | 100.5312 | 99.75 | 99.875 | 2130200.0 |
| 2000-02-08 11:00:00 | QQQ | ETF | 99.9688 | 100.25 | 99.6406 | 100.25 | 1093400.0 |
| 2000-02-08 11:30:00 | QQQ | ETF | 100.1875 | 100.2188 | 99.7812 | 100.0 | 606800.0 |
| 2000-02-08 12:00:00 | QQQ | ETF | 99.9688 | 100.3125 | 99.875 | 100.1875 | 718400.0 |
| 2000-02-08 12:30:00 | QQQ | ETF | 100.2812 | 100.3125 | 99.9531 | 100.0938 | 458400.0 |
| 2000-02-08 13:00:00 | QQQ | ETF | 100.1875 | 100.4688 | 100.0312 | 100.2344 | 525200.0 |
| 2000-02-08 13:30:00 | QQQ | ETF | 100.2188 | 100.7344 | 100.1719 | 100.4688 | 938000.0 |
| 2000-02-08 14:00:00 | QQQ | ETF | 100.4531 | 100.75 | 100.3125 | 100.5625 | 1740600.0 |
| 2000-02-08 14:30:00 | QQQ | ETF | 100.5625 | 100.9375 | 100.4219 | 100.9062 | 1180000.0 |
| 2000-02-08 15:00:00 | QQQ | ETF | 100.9062 | 101.3125 | 100.6406 | 100.6562 | 2056200.0 |
| 2000-02-08 15:30:00 | QQQ | ETF | 100.6875 | 101.4062 | 100.4375 | 101.4062 | 2653600.0 |
| 2000-02-08 16:00:00 | QQQ | ETF | 101.4062 | 101.8125 | 101.25 | 101.8125 | 867400.0 |
| 2000-02-08 16:30:00 | QQQ | ETF | 101.8438 | 102.0 | 101.6875 | 102.0 | 7200.0 |
| 2000-02-08 17:00:00 | QQQ | ETF | 102.0 | 102.25 | 102.0 | 102.25 | 3600.0 |
| 2000-02-08 17:30:00 | QQQ | ETF | 102.25 | 102.5938 | 101.75 | 102.5 | 5000.0 |
| 2000-02-08 18:00:00 | QQQ | ETF | 102.5 | 102.875 | 102.5 | 102.625 | 9000.0 |
| 2000-02-08 09:30:00 | DIA | ETF | 109.9062 | 110.3438 | 109.75 | 110.0312 | 180900.0 |
| 2000-02-08 10:00:00 | DIA | ETF | 110.1875 | 110.2188 | 109.75 | 110.0625 | 88700.0 |
| 2000-02-08 10:30:00 | DIA | ETF | 109.8438 | 110.125 | 109.75 | 109.75 | 193800.0 |
| 2000-02-08 11:00:00 | DIA | ETF | 109.8125 | 110.0625 | 109.5312 | 110.0625 | 66900.0 |
| 2000-02-08 11:30:00 | DIA | ETF | 109.9375 | 110.0312 | 109.7812 | 109.9688 | 8600.0 |
| 2000-02-08 12:00:00 | DIA | ETF | 109.8438 | 110.0625 | 109.75 | 109.8438 | 2000.0 |
| 2000-02-08 12:30:00 | DIA | ETF | 109.8438 | 109.875 | 109.625 | 109.8125 | 71700.0 |
| 2000-02-08 13:00:00 | DIA | ETF | 109.8125 | 109.875 | 109.625 | 109.7812 | 31100.0 |
| 2000-02-08 13:30:00 | DIA | ETF | 109.7812 | 109.875 | 109.625 | 109.7812 | 8100.0 |
| 2000-02-08 14:00:00 | DIA | ETF | 109.625 | 109.875 | 109.625 | 109.8125 | 29700.0 |
| 2000-02-08 14:30:00 | DIA | ETF | 109.5312 | 109.8438 | 109.5312 | 109.8438 | 62200.0 |
| 2000-02-08 15:00:00 | DIA | ETF | 109.75 | 109.9062 | 109.5 | 109.5312 | 130800.0 |
| 2000-02-08 15:30:00 | DIA | ETF | 109.5312 | 109.7188 | 109.125 | 109.5 | 106300.0 |
| 2000-02-08 16:00:00 | DIA | ETF | 109.4688 | 109.5938 | 109.3125 | 109.3125 | 12300.0 |
> showing 46 of 230 rows — these rows as CSV