Flipside Community01.A) creation stats monthly - ETH
    Updated 2024-11-04
    with acquired_transaction as
    (
    select
    from_address,
    (block_timestamp) as acquired_time
    from ethereum.core.fact_transactions
    where block_timestamp between '2023-01-01' and '2024-01-01'
    and nonce=1

    )
    select date_trunc('month',acquired_time) as month, count(distinct from_address) as acquired_users
    from acquired_transaction
    group by month
    order by month asc