Amount of DEX Token Balance in Different Pools (Log Scale)

Eman-RazAmount of DEX Token Balance in Different Pools (Log Scale)

Updated 2022-12-25

with table1 as (with tab1 as (select pool_name, pool_address

from ethereum.core.dim_dex_liquidity_pools

where (TOKEN0_SYMBOL='{{DEX_Token}}' OR TOKEN1_SYMBOL='{{DEX_Token}}') and pool_name is not null

order by 1),

tab2 as (select from_address, sum(amount) as volume, count(distinct origin_from_address) as liquidity_removers,

count(distinct tx_hash) as liquidity_removing

from ethereum.core.ez_token_transfers

where (contract_address='0x1f9840a85d5af5bf1d1762f925bdaddc4201f984' --uni

or contract_address='0xc011a73ee8576fb46f5e1c5751ca3b9fe0af2a6f' --snx

or contract_address='0xd533a949740bb3306d119cc777fa900ba034cd52' --crv

or contract_address='0x111111111117dc0aa78b770fa6a738034120c302' --1inch

or contract_address='0xbbbbca6a901c926f240b89eacb641d8aec7aeafd' --lrc

or contract_address='0xba100000625a3754423978a60c9317c58a424e3d' --bal

or contract_address='0x6b3595068778dd592e39a122f4f5a5cf09c90fe2' --sushi

or contract_address='0x92d6c1e31e14520e676a687f0a93788b716beff5' --dydx

or contract_address='0xe41d2489571d322189246dafa5ebde1f4699f498' --zrx

or contract_address='0x43dfc4159d86f3a37a5a4b3d4580b888ad7d4ddd' --dodo

or contract_address='0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c') --bnt

group by 1)

select pool_name, from_address, volume as volume_sent, liquidity_removers, liquidity_removing

from tab1 left join tab2 on tab1.pool_address=tab2.from_address

where volume is not null

order by 3),

table2 as (with tab3 as (select pool_name, pool_address

from ethereum.core.dim_dex_liquidity_pools

where (TOKEN0_SYMBOL='{{DEX_Token}}' OR TOKEN1_SYMBOL='{{DEX_Token}}') and pool_name is not null

order by 1),

tab4 as (select to_address, sum(amount) as volume, count(distinct origin_from_address) as liquidity_providers,

count(distinct tx_hash) as liquidity_providing