count (distinct tx_hash) as number_of_txn,

sum (amount_usd) as volume_in_USD, volume_in_USD/number_of_txn as avg_amount_per_txn,

number_of_txn/number_of_users as avg_txn_per_user

from ethereum.core.ez_token_transfers

where symbol in ('USDC', 'USDT', 'LUSD') and to_address ilike '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'

and block_timestamp >= CURRENT_DATE - {{num_days}} and block_timestamp <=current_date - 1

group by 1)

select * from ETH_to_OP