PREVIEW / etf_30min / 2000-02-29
file: by_date/etf_30min/2000/2000-02-29.parquet size: 9 KB rows: 209
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-29 09:30:00 | SPY | ETF | 136.0625 | 136.7812 | 135.9375 | 136.625 | 1202600.0 |
| 2000-02-29 10:00:00 | SPY | ETF | 136.625 | 136.9375 | 136.0 | 136.0625 | 1057500.0 |
| 2000-02-29 10:30:00 | SPY | ETF | 136.2812 | 136.7812 | 136.125 | 136.1875 | 225000.0 |
| 2000-02-29 11:00:00 | SPY | ETF | 136.3438 | 136.6562 | 136.0 | 136.0 | 764200.0 |
| 2000-02-29 11:30:00 | SPY | ETF | 136.0625 | 136.375 | 135.75 | 136.0312 | 627300.0 |
| 2000-02-29 12:00:00 | SPY | ETF | 136.0312 | 136.5938 | 135.9062 | 136.4375 | 657800.0 |
| 2000-02-29 12:30:00 | SPY | ETF | 136.375 | 136.5625 | 136.2812 | 136.5 | 58100.0 |
| 2000-02-29 13:00:00 | SPY | ETF | 136.5 | 136.7812 | 136.4375 | 136.75 | 310300.0 |
| 2000-02-29 13:30:00 | SPY | ETF | 136.625 | 136.8438 | 136.4375 | 136.7812 | 723200.0 |
| 2000-02-29 14:00:00 | SPY | ETF | 136.8125 | 136.8438 | 136.1562 | 136.1562 | 71000.0 |
| 2000-02-29 14:30:00 | SPY | ETF | 136.1562 | 136.9688 | 136.125 | 136.9375 | 272600.0 |
| 2000-02-29 15:00:00 | SPY | ETF | 136.75 | 137.3125 | 136.5625 | 137.0312 | 945800.0 |
| 2000-02-29 15:30:00 | SPY | ETF | 137.2188 | 137.4375 | 136.5938 | 136.9062 | 576100.0 |
| 2000-02-29 16:00:00 | SPY | ETF | 137.0 | 137.4375 | 136.875 | 137.4375 | 742900.0 |
| 2000-02-29 09:30:00 | QQQ | ETF | 105.75 | 106.0625 | 105.1562 | 105.8125 | 2823000.0 |
| 2000-02-29 10:00:00 | QQQ | ETF | 105.75 | 105.9844 | 105.0312 | 105.1875 | 2594200.0 |
| 2000-02-29 10:30:00 | QQQ | ETF | 105.1875 | 105.9844 | 105.1875 | 105.8125 | 2677800.0 |
| 2000-02-29 11:00:00 | QQQ | ETF | 105.7812 | 106.4688 | 105.5312 | 105.5312 | 2442000.0 |
| 2000-02-29 11:30:00 | QQQ | ETF | 105.5625 | 105.9375 | 105.3125 | 105.7188 | 1209600.0 |
| 2000-02-29 12:00:00 | QQQ | ETF | 105.7812 | 105.9375 | 105.3438 | 105.8438 | 949200.0 |
| 2000-02-29 12:30:00 | QQQ | ETF | 105.8125 | 105.9844 | 105.625 | 105.8125 | 934000.0 |
| 2000-02-29 13:00:00 | QQQ | ETF | 105.8281 | 106.1562 | 105.6875 | 106.0 | 956200.0 |
| 2000-02-29 13:30:00 | QQQ | ETF | 106.0156 | 106.0625 | 105.3906 | 105.7812 | 1091400.0 |
| 2000-02-29 14:00:00 | QQQ | ETF | 105.75 | 105.8594 | 105.0 | 105.0 | 1096600.0 |
| 2000-02-29 14:30:00 | QQQ | ETF | 105.0 | 106.0781 | 104.9375 | 106.0625 | 1563200.0 |
| 2000-02-29 15:00:00 | QQQ | ETF | 105.75 | 106.4375 | 105.5 | 106.0625 | 1714600.0 |
| 2000-02-29 15:30:00 | QQQ | ETF | 106.0156 | 106.75 | 105.7812 | 106.5938 | 2672200.0 |
| 2000-02-29 16:00:00 | QQQ | ETF | 106.5938 | 107.0938 | 106.3125 | 107.0938 | 1093400.0 |
| 2000-02-29 16:30:00 | QQQ | ETF | 107.0 | 107.0938 | 107.0 | 107.0625 | 2000.0 |
| 2000-02-29 17:00:00 | QQQ | ETF | 107.0 | 107.0 | 107.0 | 107.0 | 20000.0 |
| 2000-02-29 17:30:00 | QQQ | ETF | 106.875 | 106.875 | 106.75 | 106.75 | 3600.0 |
| 2000-02-29 09:30:00 | DIA | ETF | 101.1875 | 101.2812 | 100.875 | 101.0312 | 252500.0 |
| 2000-02-29 10:00:00 | DIA | ETF | 101.0312 | 101.3125 | 100.4375 | 100.5938 | 133400.0 |
| 2000-02-29 10:30:00 | DIA | ETF | 100.5938 | 101.1562 | 100.5 | 100.75 | 80000.0 |
| 2000-02-29 11:00:00 | DIA | ETF | 100.875 | 101.0938 | 100.6875 | 100.6875 | 75400.0 |
| 2000-02-29 11:30:00 | DIA | ETF | 100.75 | 101.0312 | 100.5312 | 100.875 | 21700.0 |
| 2000-02-29 12:00:00 | DIA | ETF | 100.8125 | 101.25 | 100.5312 | 101.2188 | 31300.0 |
| 2000-02-29 12:30:00 | DIA | ETF | 101.2188 | 101.25 | 101.0 | 101.2188 | 25200.0 |
| 2000-02-29 13:00:00 | DIA | ETF | 101.2188 | 101.4062 | 101.0312 | 101.375 | 113300.0 |
| 2000-02-29 13:30:00 | DIA | ETF | 101.25 | 101.5 | 101.125 | 101.3438 | 152200.0 |
| 2000-02-29 14:00:00 | DIA | ETF | 101.3438 | 101.5 | 101.1875 | 101.25 | 23500.0 |
| 2000-02-29 14:30:00 | DIA | ETF | 101.4062 | 101.8438 | 101.4062 | 101.75 | 59200.0 |
| 2000-02-29 15:00:00 | DIA | ETF | 101.6875 | 102.0938 | 101.625 | 102.0 | 123900.0 |
| 2000-02-29 15:30:00 | DIA | ETF | 102.0312 | 102.125 | 101.375 | 101.6875 | 88800.0 |
| 2000-02-29 16:00:00 | DIA | ETF | 101.5625 | 101.75 | 101.4688 | 101.5625 | 19300.0 |
> showing 45 of 209 rows — these rows as CSV