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

from ethereum.udm_events

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

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

group by 1,3),

mirror as (select date_trunc('day', block_timestamp) as dt, sum(event_attributes:amount/1e6) as aUST_vol, 'Mirror' as destination, count(distinct tx_id) as tx_count, avg(event_attributes:amount/1e6) as avg_vol

from terra.msg_events

where tx_status = 'SUCCEEDED' and event_type = 'wasm' and event_attributes:"1_contract_address"::string = 'terra1hzh9vpxhsk8253se0vv5jj6etdvxu3nv8z07zu'

and event_attributes:"0_contract_address"::string = 'terra1wfz7h3aqf4cjmjcvc6s8lxdhh7k30nkczyf0mj'

and dt >= CURRENT_DATE - 80

group by 1,3)

select * from aust

select * from mirror