SELECT origin_from_address,

block_timestamp::date DATE_

from ethereum.core.fact_event_logs

where origin_to_address in (

'0xa0c68c638235ee32657e8f720a23cec1bfc77c77',

'0x401f6c983ea34274ec46f84d70b31c151321188b'

)

and event_name = 'Transfer'

and block_timestamp::date >= '2022-06-07'

group by 1,2

),

AFTER_BRIDGE as (

select

origin_from_address WALLET,

tx_hash,

from polygon.core.fact_event_logs join e_to_p USING (origin_from_address)

where DATE_ >= block_timestamp

group by 1,2,3)

select

address_name,

count (distinct tx_hash) NUM_TRANSACTIONS,

count (distinct WALLET) NUM_WALLETS

from polygon.core.dim_labels join AFTER_BRIDGE

on origin_to_address = address

where address_name not ilike '%hop%'

group by 1 order by 2 DESC limit 20