alirsopbv-06
    Updated 2022-09-02
    with base as (select block_timestamp::date as Date,tx_hash,
    -- IFF(TOKEN0_AMOUNT_USD IS NULL, TOKEN1_AMOUNT_USD,TOKEN0_AMOUNT_USD) as TOKEN0_AMOUNT_USD_n,
    -- IFF(TOKEN1_AMOUNT_USD IS NULL, TOKEN0_AMOUNT_USD, TOKEN1_AMOUNT_USD) as TOKEN1_AMOUNT_USD_n
    IFF(SYMBOL_IN IS NULL, TOKEN_ADDRESS_IN, SYMBOL_IN) as SYMBOL_IN_n,
    IFF(SYMBOL_OUT IS NULL, TOKEN_ADDRESS_OUT, SYMBOL_OUT) as SYMBOL_OUT_n,
    CONCAT(SYMBOL_IN_n, '-->', SYMBOL_OUT_n) as Swap_Pairs
    from optimism.velodrome.ez_swaps
    where date >= '2022-07-07' and date <= '2022-08-04' )





    select
    --block_timestamp::date as Date,
    SYMBOL_IN_n,
    count (distinct tx_hash) as Num_Swap
    --count (distinct ORIGIN_FROM_ADDRESS) as daily_Swapper
    from base
    where date >= '2022-07-07' and date <= '2022-08-04'
    GROUP by 1
    ORDER by 2 DESC
    limit 10
    Run a query to Download Data