PREVIEW / etf_30min / 2000-02-25
file: by_date/etf_30min/2000/2000-02-25.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-02-25 09:30:00 | SPY | ETF | 135.1875 | 136.125 | 135.0 | 135.9375 | 2020700.0 |
| 2000-02-25 10:00:00 | SPY | ETF | 136.0 | 136.7188 | 135.75 | 136.0625 | 654500.0 |
| 2000-02-25 10:30:00 | SPY | ETF | 136.0 | 136.1875 | 135.3125 | 135.375 | 1775500.0 |
| 2000-02-25 11:00:00 | SPY | ETF | 135.2812 | 135.9062 | 135.2812 | 135.375 | 290800.0 |
| 2000-02-25 11:30:00 | SPY | ETF | 135.4375 | 135.4688 | 134.6875 | 134.9688 | 389400.0 |
| 2000-02-25 12:00:00 | SPY | ETF | 134.875 | 135.375 | 134.875 | 135.3125 | 135500.0 |
| 2000-02-25 12:30:00 | SPY | ETF | 135.3438 | 135.875 | 135.0625 | 135.0625 | 209900.0 |
| 2000-02-25 13:00:00 | SPY | ETF | 135.0625 | 135.25 | 134.5625 | 134.5938 | 850200.0 |
| 2000-02-25 13:30:00 | SPY | ETF | 134.5938 | 134.8438 | 133.7812 | 133.875 | 506100.0 |
| 2000-02-25 14:00:00 | SPY | ETF | 133.875 | 134.5 | 133.5312 | 134.125 | 509100.0 |
| 2000-02-25 14:30:00 | SPY | ETF | 134.1562 | 134.4688 | 133.625 | 134.125 | 735100.0 |
| 2000-02-25 15:00:00 | SPY | ETF | 134.0312 | 134.7812 | 133.5312 | 133.9062 | 513100.0 |
| 2000-02-25 15:30:00 | SPY | ETF | 133.8438 | 134.2188 | 133.125 | 133.75 | 1020900.0 |
| 2000-02-25 16:00:00 | SPY | ETF | 133.625 | 134.0 | 133.3125 | 133.3125 | 721600.0 |
| 2000-02-25 09:30:00 | QQQ | ETF | 106.1875 | 106.25 | 105.25 | 106.25 | 4658800.0 |
| 2000-02-25 10:00:00 | QQQ | ETF | 105.9375 | 107.5 | 105.9375 | 106.4062 | 4052400.0 |
| 2000-02-25 10:30:00 | QQQ | ETF | 106.375 | 106.6875 | 105.75 | 106.0938 | 2871400.0 |
| 2000-02-25 11:00:00 | QQQ | ETF | 106.375 | 106.625 | 105.75 | 106.1875 | 2313800.0 |
| 2000-02-25 11:30:00 | QQQ | ETF | 106.3125 | 106.375 | 105.5625 | 106.0 | 2184600.0 |
| 2000-02-25 12:00:00 | QQQ | ETF | 106.125 | 106.625 | 105.9062 | 106.4688 | 843600.0 |
| 2000-02-25 12:30:00 | QQQ | ETF | 106.25 | 107.1875 | 106.2188 | 106.3125 | 1860000.0 |
| 2000-02-25 13:00:00 | QQQ | ETF | 106.25 | 106.6875 | 105.75 | 105.75 | 1105800.0 |
| 2000-02-25 13:30:00 | QQQ | ETF | 105.75 | 106.0156 | 104.8438 | 105.25 | 2271800.0 |
| 2000-02-25 14:00:00 | QQQ | ETF | 105.1562 | 105.5625 | 104.5625 | 105.2344 | 1638600.0 |
| 2000-02-25 14:30:00 | QQQ | ETF | 105.3438 | 105.875 | 104.6562 | 105.4688 | 1482600.0 |
| 2000-02-25 15:00:00 | QQQ | ETF | 105.625 | 106.375 | 104.8125 | 105.375 | 1849400.0 |
| 2000-02-25 15:30:00 | QQQ | ETF | 105.4062 | 105.9375 | 103.875 | 104.375 | 4395200.0 |
| 2000-02-25 16:00:00 | QQQ | ETF | 104.375 | 104.5 | 104.0 | 104.375 | 708400.0 |
| 2000-02-25 16:30:00 | QQQ | ETF | 104.25 | 104.25 | 104.0 | 104.1875 | 2200.0 |
| 2000-02-25 17:00:00 | QQQ | ETF | 104.1875 | 104.1875 | 104.1875 | 104.1875 | 800.0 |
| 2000-02-25 17:30:00 | QQQ | ETF | 104.1875 | 104.1875 | 104.1875 | 104.1875 | 1400.0 |
| 2000-02-25 09:30:00 | DIA | ETF | 100.5938 | 101.3125 | 100.5 | 101.2188 | 280400.0 |
| 2000-02-25 10:00:00 | DIA | ETF | 101.2188 | 101.4688 | 100.625 | 100.6562 | 260500.0 |
| 2000-02-25 10:30:00 | DIA | ETF | 100.625 | 100.8438 | 100.125 | 100.375 | 124300.0 |
| 2000-02-25 11:00:00 | DIA | ETF | 100.3125 | 100.75 | 100.1875 | 100.3438 | 70600.0 |
| 2000-02-25 11:30:00 | DIA | ETF | 100.1875 | 100.2812 | 99.75 | 99.9375 | 300000.0 |
| 2000-02-25 12:00:00 | DIA | ETF | 100.0 | 100.375 | 99.875 | 100.125 | 133700.0 |
| 2000-02-25 12:30:00 | DIA | ETF | 100.2188 | 100.5625 | 100.0 | 100.0312 | 72400.0 |
| 2000-02-25 13:00:00 | DIA | ETF | 100.0312 | 100.1562 | 99.5 | 99.5 | 140600.0 |
| 2000-02-25 13:30:00 | DIA | ETF | 99.625 | 99.75 | 98.9688 | 99.3125 | 405800.0 |
| 2000-02-25 14:00:00 | DIA | ETF | 99.3125 | 99.6562 | 99.0312 | 99.625 | 180100.0 |
| 2000-02-25 14:30:00 | DIA | ETF | 99.7188 | 99.9062 | 99.0 | 99.5 | 145100.0 |
| 2000-02-25 15:00:00 | DIA | ETF | 99.5625 | 99.9688 | 99.0312 | 99.2812 | 336200.0 |
| 2000-02-25 15:30:00 | DIA | ETF | 99.1875 | 99.3438 | 98.1875 | 98.75 | 725700.0 |
| 2000-02-25 16:00:00 | DIA | ETF | 98.7812 | 98.9688 | 98.5312 | 98.5625 | 105800.0 |
> showing 45 of 223 rows — these rows as CSV