with new_w as (SELECT DISTINCT CONTRACT, min(TIMESTAMP::date) as date

from external.tokenflow_starknet.decoded_transactions

where CHAIN_ID = 'mainnet'

group by 1)

SELECT count(DISTINCT CONTRACT)/count(DISTINCT date) as "avg new wallets per day" , 'Before ArgentX campaign' as period

from new_w

where date >= '2023-01-01' and date <= '2023-05-01'

group by period

union

SELECT count(DISTINCT CONTRACT)/count(DISTINCT date) as "avg new wallets per day" , 'After ArgentX campaign' as period

from new_w

where date >= '2023-05-02'

group by period