date_trunc('day', block_timestamp) as dt, sum(amount) as aUST_vol, 'Abracadabra' as destination, count(distinct tx_id) as tx_count, avg(amount) as avg_vol

from ethereum.udm_events

where to_address = lower('0xe6191aa754f9a881e0a73f2028edf324242f39e2') -- abracadabra

and CONTRACT_ADDRESS = lower('0xa47c8bf37f92aBed4A126BDA807A7b7498661acD') --wrapped aUST

group by 1,3