flipside

    Untitled Query
    rajsUntitled Query
    Updated 2022-11-02
    with bounty_solvers as
    (
    SELECT
    to_address as bounty_solver,
    sum(amount) as amount
    -- ,*
    from ethereum.core.ez_token_transfers
    -- where tx_hash = '0xb8d5f57d25a04f2e1cc497e2afa3e5b4e2d5f4593b1dc362264eca0cca748e8a'
    where from_address = '0xd152f549545093347a162dce210e7293f1452150'
    and origin_from_address = '0xc2f41b3a1ff28fd2a6eee76ee12e51482fcfd11f'
    and origin_to_address = '0xd152f549545093347a162dce210e7293f1452150'
    and symbol = 'USDC'
    group by 1
    order by 2 desc
    )
    ,

    reqd_table as
    (
    SELECT
    from_address,
    to_address,
    count(distinct tx_hash)
    from ethereum.core.ez_token_transfers
    where from_address IN
    (
    SELECT
    bounty_solver
    from bounty_solvers
    )
    and symbol in ('USDC')
    -- and amount <= 1000
    and origin_function_signature = '0xa9059cbb'
    group by 1,2
    order by 1,2
    )
    Run a query to Download Data