mhmRemove Liq - Total (after)
Updated 2022-10-04Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with pools as (
select pool_address from ethereum.core.dim_dex_liquidity_pools
where platform = 'sushiswap'
)
select
count(distinct tx_hash) as after_total_txs,
count(distinct origin_from_address) as after_total_addresses,
sum(amount_usd) as after_total_volume_usd_removed
from ethereum.core.ez_token_transfers t
join pools on t.from_address = pool_address
where origin_function_signature in ('0xbaa2abde','0x02751cec','0x02751cec','0xded9382a','0x5b0d5984')
and block_timestamp::date >= '2022-09-15' and block_timestamp::date < '2022-09-30'
Run a query to Download Data