mboveiriDays Wallets used Suhiswap - Year to date
    Updated 2022-05-09
    SELECT TX_TO as Wallet , count(DISTINCT(BLOCK_TIMESTAMP::date)) as Total_Used_days
    from ethereum_sushi.ez_swaps
    where (block_timestamp between '2022-1-1' and GETDATE() ) and platform = 'sushiswap' and tx_to not in (select address from ethereum_core.dim_labels )
    and tx_to not in (select address from ethereum_core.dim_contracts) -- Filters Contract address
    GROUP by 1

    order by 2 DESC



    Run a query to Download Data