Eman-RazDistribution of Traders Based on the Number of Days of Activity
    Updated 2024-01-15
    with tab1 as (select ORIGIN_FROM_ADDRESS as "Trader", count(distinct block_timestamp::date) as "Number of Days of Activity"
    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)

    select "Number of Days of Activity", count(distinct "Trader") as "Trader Count"
    from tab1
    group by 1
    order by 1

    QueryRunArchived: QueryRun has been archived