Updated 2022-08-05
    with a as
    (select
    date_trunc('day', block_timestamp) AS date,
    from_address,
    count(DISTINCT TX_HASH) as transactions
    from gnosis.core.fact_transactions
    WHERE block_timestamp >= '2022-01-01'
    group by 1,2
    order by 1)
    select
    date,
    count(DISTINCT from_address) as total_addresses,
    case when transactions between 1 and 5 then '1-5'
    when transactions between 5 and 10 then '5-10'
    when transactions between 10 and 50 then '10-50'
    when transactions between 50 and 100 then '50-100'
    when transactions between 100 and 500 then '100-500'
    when transactions >500 then 'more than 500' end as number
    from a
    group by 1,3 order by 2 desc


    Run a query to Download Data