popni-amico-An1plFtx and users
    Updated 2022-10-17
    WITH a as (
    SELECT
    date_trunc('hour',block_timestamp) as date,
    count(distinct tx_hash) as num_tx ,
    count(distinct from_address) as users,
    num_tx/users as transactions_per_user
    from gnosis.core.fact_transactions
    where date >= '2022-10-01'
    group by 1
    ),
    b as (
    SELECT
    distinct from_address,min(block_timestamp) as first_transaction
    from gnosis.core.fact_transactions group by from_address
    ),
    c as (
    SELECT
    date_trunc('hour',first_transaction) as date,
    count(distinct from_address) as new_users
    from b
    where date >= '2022-10-01'
    group by 1
    )
    SELECT
    a.date,
    num_tx ,
    users,
    transactions_per_user,
    new_users
    from a,c
    where a.date=c.date
    Run a query to Download Data