mhmRemove Liq - Total (after)
    Updated 2022-10-04
    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