BLUB Balance of DEX Liquidity Pools in Avalanche

Ali3NBLUB Balance of DEX Liquidity Pools in Avalanche

Updated 14 hours ago

with pricet as (

select date_trunc (day,block_timestamp) as date2,

avg (amount_in_usd/amount_out) as USDPrice

from avalanche.defi.ez_dex_swaps

where symbol_in in ('WAVAX','USDC')

and (symbol_out = 'WINK' or token_out = '0x0f669808d88b2b0b3d23214dcd2a1cc6a8b1b5cd')

and block_timestamp >= '2025-02-05'

group by 1),

poolst as (

select *

from avalanche.defi.dim_dex_liquidity_pools

where tokens:token0 = '0x0f669808d88b2b0b3d23214dcd2a1cc6a8b1b5cd'

or tokens:token1 = '0x0f669808d88b2b0b3d23214dcd2a1cc6a8b1b5cd'),

depositst as (

select initcap(platform) || ' | ' || Pool_name as LP_Name,

sum (amount) as Deposited_Volume,

sum (amount*usdprice) as Deposited_Volume_USD

from avalanche.core.ez_token_transfers t1 join poolst t2 on t1.to_address = t2.pool_address

left outer join pricet t3 on t1.block_timestamp::Date = t3.date2

where contract_address = '0x0f669808d88b2b0b3d23214dcd2a1cc6a8b1b5cd'

group by 1

order by 2 desc),

withdrawst as (

select initcap(platform) || ' | ' || Pool_name as LP_Name,

sum (amount) as Withdrawn_Volume,

sum (amount*usdprice) as Withdrawn_Volume_USD

from avalanche.core.ez_token_transfers t1 join poolst t2 on t1.from_address = t2.pool_address

left outer join pricet t3 on t1.block_timestamp::date = t3.date2

where contract_address = '0x0f669808d88b2b0b3d23214dcd2a1cc6a8b1b5cd'

group by 1

order by 2 desc)

select coalesce (t1.lp_name,t2.lp_name) as Liquidity_Pool_Name,

Last run: about 14 hours agoAuto-refreshes every 24 hours

1KB

flipside