djebril2023-11-13 10:20 AM
    Updated 2023-11-13
    with

    main as (
    select
    tx_hash,
    block_timestamp,
    'Ethereum' as blockchain,
    origin_from_address as user,
    amount_in_usd,
    amount_out_usd,
    iff(amount_in_usd is not null, amount_in_usd, amount_out_usd) as amount_usd,
    symbol_in,
    symbol_out
    from ethereum.defi.ez_dex_swaps
    where platform = 'curve'
    and amount_usd > 0

    union all

    select
    tx_hash,
    block_timestamp,
    'Arbitrum',
    origin_from_address,
    amount_in_usd,
    amount_out_usd,
    iff(amount_in_usd is not null, amount_in_usd, amount_out_usd) as amount_usd,
    symbol_in,
    symbol_out
    from arbitrum.defi.ez_dex_swaps
    where platform = 'curve'
    and amount_usd > 0

    union all

    select
    Run a query to Download Data