select POOL_NAME,

POOL_ADDRESS,

from ethereum.core.dim_dex_liquidity_pools

where (TOKEN0 = '0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce'

or TOKEN1 = '0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce')

select

date_trunc(week, BLOCK_TIMESTAMP) as date,

POOL_NAME,

PLATFORM,

sum(AMOUNT_USD) as "OUTflow Volume",

row_number() over(partition by date order by "OUTflow Volume" desc) as rank

from ethereum.core.ez_token_transfers a join SHIB_POOLs b

on a.from_address = b.POOL_ADDRESS

where 1=1

and AMOUNT_USD is not null

and POOL_NAME is not null

group by 1,2,3

qualify rank < 4