siavashjNew Swapper on Uniswap c copy copy copy
    Updated 2023-05-15
    with base as (
    select
    'Ethereum' as chain,
    origin_from_address as swapper,
    min(block_timestamp) as s_time,
    tx_hash,
    amount_in_usd
    from ethereum.core.ez_dex_swaps
    where platform ilike '%uniswap%'
    and block_timestamp >= current_date - interval '12 month'
    group by 1,2,4,5

    union all

    select
    'Polygon' as chain,
    origin_from_address as swapper,
    min(block_timestamp) as s_time,
    tx_hash,
    amount_in_usd
    from polygon.core.ez_dex_swaps
    where platform ilike '%uniswap%'
    and block_timestamp >= current_date - interval '12 month'
    group by 1,2,4,5

    union all

    select
    'Osmosis' as Chain,
    origin_from_address as swapper,
    min(block_timestamp) as s_time,
    tx_hash,
    amount_in_usd
    from optimism.core.ez_dex_swaps
    where platform ilike '%uniswap%'
    and block_timestamp >= current_date - interval '12 month'
    Run a query to Download Data