when trxs > 1 and trxs < 10 then '2 to 10 trxs'

when trxs >= 10 and trxs < 100 then '10 to 100 trxs'

when trxs >= 100 and trxs < 1000 then '100 to 1 K trxs'

else 'More than 1 K trxs' end as trx_size,

count (distinct origin_from_address) as transferers

from (select date_trunc('week', block_timestamp) as week,

origin_from_address,

count (distinct tx_hash) as trxs,

count (distinct origin_from_address) as wallets,

sum (event_inputs:value/1e6) as volume,

avg (event_inputs:value/1e6) as Avg_Volume

from avalanche.core.fact_event_logs

where tx_status = 'SUCCESS'

and event_name = 'Transfer'

and contract_address = '0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e'

and tx_hash not in (select tx_hash

from (select distinct tx_hash

from avalanche.core.fact_event_logs

where event_name = 'Swap'

)

)

and block_timestamp >= '2022-07-01'

and event_inputs:value/1e6 < 1e9

group by 1,2

)

group by 1, 2