binhachonUntitled Query
    Updated 2022-01-24
    with tSUSHI_contract_addresses as (
    select
    '0x8798249c2e607446efb7ad49ec89dd1865ff4272' as address, --0xf49764c9c5d644ece6ae2d18ffd9f1e902629777
    'tSUSHI' as name
    ),
    remove_list as (
    select
    '0xf256cc7847e919fac9b808cc216cac87ccf2f47a' as address,
    'axSUSHI' as name
    ),
    tSUSHI_raw_transactions as ( --tSUSHI
    select
    from_address as address,
    contract_address,
    -amount as amount
    from ethereum.udm_events
    where contract_address in (select address from tSUSHI_contract_addresses)
    and amount is not null
    and from_address != '0x0000000000000000000000000000000000000000'
    union all
    select
    to_address as address,
    contract_address,
    amount as amount
    from ethereum.udm_events
    where contract_address in (select address from tSUSHI_contract_addresses)
    and amount is not null
    and to_address != '0x0000000000000000000000000000000000000000'
    )
    select
    address,
    sum(amount)
    from tSUSHI_raw_transactions
    where address = '0xf5bce5077908a1b7370b9ae04adc565ebd643966'
    group by address
    Run a query to Download Data