PREVIEW / etf_30min / 2000-01-26
file: by_date/etf_30min/2000/2000-01-26.parquet size: 10 KB rows: 223
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-01-26 09:30:00 | SPY | ETF | 141.0 | 141.375 | 140.4688 | 141.375 | 384800.0 |
| 2000-01-26 10:00:00 | SPY | ETF | 141.375 | 141.5312 | 141.0625 | 141.25 | 220600.0 |
| 2000-01-26 10:30:00 | SPY | ETF | 141.25 | 141.3438 | 140.75 | 140.875 | 202300.0 |
| 2000-01-26 11:00:00 | SPY | ETF | 140.75 | 140.75 | 140.0938 | 140.7188 | 720000.0 |
| 2000-01-26 11:30:00 | SPY | ETF | 140.75 | 140.875 | 140.4375 | 140.6875 | 197400.0 |
| 2000-01-26 12:00:00 | SPY | ETF | 140.6875 | 140.7812 | 140.5 | 140.625 | 152000.0 |
| 2000-01-26 12:30:00 | SPY | ETF | 140.6875 | 140.7812 | 140.5 | 140.75 | 393700.0 |
| 2000-01-26 13:00:00 | SPY | ETF | 140.6562 | 141.1875 | 140.5938 | 141.0625 | 275700.0 |
| 2000-01-26 13:30:00 | SPY | ETF | 141.0625 | 141.2188 | 140.9062 | 140.9062 | 363100.0 |
| 2000-01-26 14:00:00 | SPY | ETF | 141.0938 | 141.5 | 140.8125 | 141.25 | 562600.0 |
| 2000-01-26 14:30:00 | SPY | ETF | 141.25 | 141.3438 | 140.5312 | 140.875 | 577300.0 |
| 2000-01-26 15:00:00 | SPY | ETF | 140.8438 | 141.125 | 140.2812 | 140.4062 | 185600.0 |
| 2000-01-26 15:30:00 | SPY | ETF | 140.375 | 140.9688 | 140.375 | 140.6562 | 497600.0 |
| 2000-01-26 16:00:00 | SPY | ETF | 140.5938 | 141.0 | 140.5312 | 140.8125 | 421600.0 |
| 2000-01-26 09:30:00 | QQQ | ETF | 93.25 | 93.3125 | 92.25 | 93.0781 | 2555800.0 |
| 2000-01-26 10:00:00 | QQQ | ETF | 93.1875 | 93.2656 | 92.5312 | 92.75 | 1371000.0 |
| 2000-01-26 10:30:00 | QQQ | ETF | 92.75 | 92.75 | 92.0625 | 92.0938 | 1957600.0 |
| 2000-01-26 11:00:00 | QQQ | ETF | 92.25 | 92.3594 | 91.0 | 92.3594 | 1825600.0 |
| 2000-01-26 11:30:00 | QQQ | ETF | 92.3438 | 92.625 | 92.0625 | 92.5156 | 805000.0 |
| 2000-01-26 12:00:00 | QQQ | ETF | 92.5156 | 92.5625 | 92.0 | 92.2188 | 586600.0 |
| 2000-01-26 12:30:00 | QQQ | ETF | 92.1875 | 92.2656 | 91.8125 | 92.0938 | 1367600.0 |
| 2000-01-26 13:00:00 | QQQ | ETF | 92.0 | 92.6094 | 91.9375 | 92.3438 | 1636000.0 |
| 2000-01-26 13:30:00 | QQQ | ETF | 92.2969 | 92.7344 | 92.125 | 92.2812 | 1969400.0 |
| 2000-01-26 14:00:00 | QQQ | ETF | 92.2812 | 93.25 | 92.2188 | 92.9844 | 1580400.0 |
| 2000-01-26 14:30:00 | QQQ | ETF | 92.9844 | 93.0 | 91.625 | 91.9219 | 1894600.0 |
| 2000-01-26 15:00:00 | QQQ | ETF | 91.9219 | 92.0625 | 91.1875 | 91.25 | 1820200.0 |
| 2000-01-26 15:30:00 | QQQ | ETF | 91.25 | 91.5469 | 90.25 | 90.5312 | 2596000.0 |
| 2000-01-26 16:00:00 | QQQ | ETF | 90.5 | 90.7969 | 90.0 | 90.0 | 565400.0 |
| 2000-01-26 16:30:00 | QQQ | ETF | 89.75 | 90.25 | 89.0 | 89.0 | 18200.0 |
| 2000-01-26 17:00:00 | QQQ | ETF | 89.5312 | 89.75 | 89.3125 | 89.3125 | 41400.0 |
| 2000-01-26 17:30:00 | QQQ | ETF | 89.3125 | 89.5 | 89.3125 | 89.5 | 1200.0 |
| 2000-01-26 18:00:00 | QQQ | ETF | 89.5 | 89.5 | 89.25 | 89.25 | 2800.0 |
| 2000-01-26 09:30:00 | DIA | ETF | 110.2188 | 111.1562 | 110.1875 | 111.1562 | 114400.0 |
| 2000-01-26 10:00:00 | DIA | ETF | 111.1562 | 111.3438 | 110.875 | 111.3125 | 71700.0 |
| 2000-01-26 10:30:00 | DIA | ETF | 111.25 | 111.375 | 110.8438 | 110.8438 | 37200.0 |
| 2000-01-26 11:00:00 | DIA | ETF | 110.9375 | 110.9375 | 110.4062 | 110.5 | 114400.0 |
| 2000-01-26 11:30:00 | DIA | ETF | 110.875 | 110.9062 | 110.4688 | 110.8438 | 88400.0 |
| 2000-01-26 12:00:00 | DIA | ETF | 110.8125 | 110.8125 | 110.5312 | 110.6562 | 2600.0 |
| 2000-01-26 12:30:00 | DIA | ETF | 110.6875 | 110.6875 | 110.4688 | 110.5938 | 15800.0 |
| 2000-01-26 13:00:00 | DIA | ETF | 110.625 | 110.9062 | 110.5938 | 110.6562 | 27200.0 |
| 2000-01-26 13:30:00 | DIA | ETF | 110.8125 | 110.9375 | 110.625 | 110.7812 | 12400.0 |
| 2000-01-26 14:00:00 | DIA | ETF | 110.5938 | 111.0 | 110.5312 | 110.8125 | 40400.0 |
| 2000-01-26 14:30:00 | DIA | ETF | 110.6562 | 110.9375 | 110.2188 | 110.6562 | 48900.0 |
| 2000-01-26 15:00:00 | DIA | ETF | 110.5 | 110.7812 | 110.25 | 110.25 | 46800.0 |
| 2000-01-26 15:30:00 | DIA | ETF | 110.4062 | 110.75 | 110.3125 | 110.5 | 148600.0 |
| 2000-01-26 16:00:00 | DIA | ETF | 110.375 | 110.4688 | 110.125 | 110.4688 | 232500.0 |
> showing 46 of 223 rows — these rows as CSV