with all_arb as

(SELECT BLOCK_TIMESTAMP::date as date, --SYMBOL as token, AMOUNT, AMOUNT_USD,

tx_hash, CONTRACT_ADDRESS, ORIGIN_FROM_ADDRESS

from arbitrum.core.ez_token_transfers

where BLOCK_TIMESTAMP::date >= '2024-01-01 00:00:00.000' and

ORIGIN_FUNCTION_SIGNATURE = '0x47e7ef24' and

ORIGIN_TO_ADDRESS = '0xc6ade8a68026d582ab37b879d188caf7e405dd09'

and FROM_ADDRESS != '0x0000000000000000000000000000000000000000'

union

SELECT BLOCK_TIMESTAMP::date as date, --SYMBOL as token, AMOUNT, AMOUNT_USD,

tx_hash, CONTRACT_ADDRESS, ORIGIN_FROM_ADDRESS

from arbitrum.core.ez_token_transfers

where BLOCK_TIMESTAMP::date >= '2024-01-01 00:00:00.000' and

ORIGIN_FUNCTION_SIGNATURE = '0xf3fef3a3' and

FROM_ADDRESS = '0xc6ade8a68026d582ab37b879d188caf7e405dd09'

and To_ADDRESS != '0x0000000000000000000000000000000000000000')

SELECT count(DISTINCT ORIGIN_FROM_ADDRESS ) as "Total users" ,

round(count(DISTINCT ORIGIN_FROM_ADDRESS )/count(DISTINCT date)) as avgu

from all_arb