2844Number of Unique Wallets
    Updated 2022-04-06
    with DEX as (
    select platform,tx_id
    from ethereum.dex_swaps
    where platform in ('sushiswap', 'uniswap-v2', 'uniswap-v3')
    and block_timestamp >= '2022-01-01'
    and direction = 'IN'
    and amount_in > '0'
    ),
    event as
    (select origin_address as N_Wallet, tx_id
    from ethereum.udm_events
    where block_timestamp >= '2022-01-01'
    )

    select Dex.platform , count(distinct (event.N_Wallet )) as N_Wallets
    from dex
    join event on dex.tx_id=event.tx_id

    group by platform
    Run a query to Download Data