Updated 2023-07-07
    -- forked from @ https://flipsidecrypto.xyz/edit/queries/8423953b-3a07-46a9-af5a-0fb90849ae43
    with
    a as (
    select
    ORIGIN_FROM_ADDRESS as claimer ,
    RAW_AMOUNT/pow(10,DECIMALS) as volume ,
    AMOUNT_USD as USD ,
    BLOCK_TIMESTAMP ,
    TX_HASH ,
    'Galexy' as Title

    from ethereum.core.ez_token_transfers
    where
    ORIGIN_TO_ADDRESS ='0x92e130d5ed0f14199edfa050071116ca60e99aa5' and
    CONTRACT_ADDRESS = '0x5faa989af96af85384b8a938c2ede4a7378d9875' and
    ORIGIN_FUNCTION_SIGNATURE ='0x2e7ba6ef'

    union

    select
    ORIGIN_FROM_ADDRESS as claimer ,
    RAW_AMOUNT/pow(10,DECIMALS) as volume ,
    AMOUNT_USD as USD ,
    BLOCK_TIMESTAMP ,
    TX_HASH ,
    'Paraswap' as Title
    from ethereum.core.ez_token_transfers
    where
    ORIGIN_TO_ADDRESS ='0x090e53c44e8a9b6b1bca800e881455b921aec420' and
    CONTRACT_ADDRESS = '0xcafe001067cdef266afb7eb5a286dcfd277f3de5' and
    ORIGIN_FUNCTION_SIGNATURE ='0x2e7ba6ef'

    union

    Run a query to Download Data