SELECT count(DISTINCT tx_hash)/ count(DISTINCT TIMESTAMP::date) as "avg daily txs", count(DISTINCT tx_hash)/count(DISTINCT CONTRACT) as "Avg activity rate",

count(DISTINCT CONTRACT)/ count(DISTINCT TIMESTAMP::date) as "avg daily users", 'Before ArgentX campaign' as period

from external.tokenflow_starknet.decoded_transactions

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

and CHAIN_ID = 'mainnet'

group by period

union

SELECT count(DISTINCT tx_hash)/ count(DISTINCT TIMESTAMP::date) as "avg daily txs", count(DISTINCT tx_hash)/count(DISTINCT CONTRACT) as "Avg activity rate",

count(DISTINCT CONTRACT)/ count(DISTINCT TIMESTAMP::date) as "avg daily users", 'After ArgentX campaign' as period

from external.tokenflow_starknet.decoded_transactions

where TIMESTAMP::date >= '2023-05-02'

and CHAIN_ID = 'mainnet'

group by period