0xaimanUntitled Query
    Updated 2022-09-12
    with a as (select tx_hash from ethereum.core.fact_event_logs
    where tx_hash = '0xb5b1cc3484045000fbb1aeb508082642a013b0b684bd7c3f30ce20ff1a97df98' and
    origin_to_address = '0x8731d54e9d02c286767d56ac03e8037c07e01e98'
    group by 1)


    select b.* , case when to_address = '0xdf0770df86a8034b3efef0a1bb3c889b8332ff56' then 'usdc' end as symbol, raw_amount/10e17 as vol_usdc
    from ethereum.core.fact_token_transfers b
    inner join a on b.tx_hash=a.tx_hash

    limit 10
    Run a query to Download Data