select

from_address,

min(block_timestamp) as first_tx

from ethereum.core.fact_transactions

group by from_address

),

new_users as (

select

from_address as address

from transactions

where first_tx >= '2022-04-01' -- from April

and first_tx < '2022-09-01' -- to August

),

swaps as (

select

swaps.block_timestamp::date as date,

count(swaps.tx_hash) as tx_count

from ethereum.core.ez_dex_swaps as swaps

inner join new_users on swaps.origin_from_address = new_users.address

where swaps.block_timestamp >= '2022-04-01' -- from April

and swaps.block_timestamp < '2022-09-01' -- to August

group by date

),

transfers as (

select

trans.block_timestamp::date as date,

count(trans.tx_hash) as tx_count

from ethereum.core.ez_eth_transfers as trans

inner join new_users on trans.eth_from_address = new_users.address

where trans.block_timestamp >= '2022-04-01' -- from April

and trans.block_timestamp < '2022-09-01' -- to August

group by date