SELECT

date_trunc('week', BLOCK_TIMESTAMP)::date as date,

CASE

WHEN CURRENCY = 'gamm/pool/1' THEN '1, (ATOM/OSMO)'

WHEN CURRENCY = 'gamm/pool/678' THEN '678, (USDC/OSMO)'

WHEN CURRENCY = 'gamm/pool/704' THEN '704, (WETH/OSMO)'

WHEN CURRENCY = 'gamm/pool/712' THEN '712, (WBTC/OSMO)'

WHEN CURRENCY = 'gamm/pool/674' THEN '674, (DAI/OSMO)'

WHEN CURRENCY = 'gamm/pool/722' THEN '722, (EVMOS/OSMO)'

WHEN CURRENCY = 'gamm/pool/9' THEN '9, (CRO/OSMO)'

WHEN CURRENCY = 'gamm/pool/604' THEN '604, (STARS/OSMO)'

WHEN CURRENCY = 'gamm/pool/497' THEN '497, (JUNO/OSMO)'

WHEN CURRENCY = 'gamm/pool/812' THEN '812, (AXL/OSMO)'

WHEN CURRENCY = 'gamm/pool/584' THEN '584, (SCRT/OSMO)'

WHEN CURRENCY = 'gamm/pool/3' THEN '3, (AKT/OSMO)'

WHEN CURRENCY = 'gamm/pool/481' THEN '481, (EEUR/OSMO)'

WHEN CURRENCY = 'gamm/pool/42' THEN '42, (REGEN/OSMO)'

WHEN CURRENCY = 'gamm/pool/463' THEN '463, (NGM/OSMO)'

WHEN CURRENCY = 'gamm/pool/15' THEN '15, (XPRT/OSMO)'

ELSE 'OTHER' END AS POOLS,

count(distinct TX_ID) as tx_cnt,

count(distinct DELEGATOR_ADDRESS) as delegator_cnt,

count(distinct VALIDATOR_ADDRESS) as validator_vnt,

sum(amount/pow(10,decimal)) as pair_volume,

sum(tx_cnt) over (partition by pools order by date) as cum_tx_cnt,

sum(pair_volume) over (partition by pools order by date) as cum_pair_volume

FROM osmosis.core.fact_superfluid_staking

WHERE TX_SUCCEEDED = TRUE

and replace(CURRENCY,'gamm/pool/') in (1, 678, 704, 712, 674, 722, 9, 604, 497, 812, 584, 3, 481, 42, 463, 15)

and ACTION = 'delegate'

group by 1,2

order by 1