with token_price as (

SELECT

RECORDED_hour,

currency,

price

FROM osmosis.price.ez_prices

qualify row_number()over (partition by currency order by recorded_hour DESC) = 1

SELECT CASE

when pool_ids = '833' then 'stOSMO/OSMO'

when pool_ids = '1136' then 'stATOM/ATOM'

when pool_ids = '817' then 'JUNO/stJUNO'

when pool_ids = '803' then 'ATOM/stATOM'

when pool_ids = '810' then 'STARS/stSTARS'

when pool_ids = '1120' then 'stSOMM/SOMM'

when pool_ids = '1035' then 'stUMEEE/UMEE'

when pool_ids = '1098' then 'STRD/OSMO'

when pool_ids = '806' then 'STRD/OSMO'

when pool_ids = '1243' then 'STRD/USDC'

end as pool_name,

pool_ids,

round(sum(amount_usd),2) as "Pool liquidity",

count(DISTINCT LIQUIDITY_PROVIDER_ADDRESS) as n_LPers

FROM (

SELECT pool_id[0] as pool_ids,

(amount/pow(10,decimal))*b.price as amount_usd,