date_trunc('day', block_timestamp) as dt,

count (distinct msg_value:from_address::string) as terrabridge_users,

count(distinct tx_id) as terrabridge_tx

from terra.msgs

where msg_value:to_address::string in ('terra13yxhrk08qvdf5zdc9ss5mwsg5sf7zva9xrgwgc', 'terra1rtn03a9l3qsc0a9verxwj00afs93mlm0yr7chk') and

tx_status = 'SUCCEEDED'

group by 1),

wormhole as (select date_trunc('day', block_timestamp) as dat,

count(distinct msg_value:sender::string) as wormhole_users,

count (distinct tx_id) as wormhole_tx

from terra.msgs

where msg_value:contract::string = 'terra10nmmwe8r3g99a9newtqa7a75xfgs2e8z87r2sf'

and msg_value:execute_msg:initiate_transfer:asset:info:token:contract_addr::string is not null and tx_status = 'SUCCEEDED'

group by 1)

select a.dt, a.terrabridge_users, a.terrabridge_tx, b.wormhole_users, b.wormhole_tx

from terra_bridge a

left outer join wormhole b on a.dt = b.dat