Eman-RazDistribution of Swaps between Traders
    Updated 2024-01-16
    with tab1 as (select ORIGIN_FROM_ADDRESS, count(distinct tx_hash) as "Swap Count"
    from gnosis.defi.ez_dex_swaps
    where block_timestamp::date>='{{Start_Date}}' and block_timestamp::date<='{{End_Date}}' and platform='honeyswap'
    and amount_in_usd>0
    group by 1
    order by 1)

    select "Swap Count", count(distinct ORIGIN_FROM_ADDRESS) as "Trader Count"
    from tab1
    group by 1
    order by 1
    QueryRunArchived: QueryRun has been archived