Afonso_Diaz2023-11-21 10:57 PM
    Updated 2023-11-21
    with t as (
    select
    tx_hash,
    block_timestamp,
    'Ethereum' as chain,
    amount_in_usd,
    amount_out_usd,
    origin_from_address as swapper,
    symbol_in,
    symbol_out,
    token_in,
    token_out
    from ethereum.defi.ez_dex_swaps
    where platform = 'curve'
    and amount_in_usd > 0

    union all

    select
    tx_hash,
    block_timestamp,
    'Polygon' as chain,
    amount_in_usd,
    amount_out_usd,
    origin_from_address as swapper,
    symbol_in,
    symbol_out,
    token_in,
    token_out
    from polygon.defi.ez_dex_swaps
    where platform = 'curve'
    and amount_in_usd > 0

    union all

    select
    Run a query to Download Data