Delamir-601406-1-transactions
    Updated 2023-01-25
    with New_User as (
    select
    '1.September 2021' as timespan,
    block_timestamp::date as date,
    count(distinct from_address) as users,
    count(distinct tx_hash)as TXs
    from ethereum.core.fact_transactions
    where date >= '2021-09-01' and date < '2021-10-01'
    and to_address = '0x92d6c1e31e14520e676a687f0a93788b716beff5'
    group by 1,2
    UNION
    select
    '2.November 2022' as timespan,
    block_timestamp::date as date,
    count(distinct from_address) as users,
    count(distinct tx_hash)as TXs
    from ethereum.core.fact_transactions
    where date >= '2022-11-01' and date < '2022-12-01'
    and to_address = '0x92d6c1e31e14520e676a687f0a93788b716beff5'
    group by 1,2
    UNION
    select
    '3.December 2022' as timespan,
    block_timestamp::date as date,
    count(distinct from_address) as users,
    count(distinct tx_hash)as TXs
    from ethereum.core.fact_transactions
    where date >= '2022-12-01' and date < '2023-01-01'
    and to_address = '0x92d6c1e31e14520e676a687f0a93788b716beff5'
    group by 1,2
    union
    select
    '4.January 2023' as timespan,
    block_timestamp::date as date,
    count(distinct from_address) as users,
    count(distinct tx_hash) as TXs
    Run a query to Download Data