sum (ETH_VALUE) as "HOP Total ETH deposited",

count (distinct FROM_ADDRESS) as "HOP Unique Wallets"

from ethereum.core.fact_event_logs E

right join ethereum.core.fact_transactions T on T.TX_HASH=E.TX_HASH

where CONTRACT_ADDRESS =lower ('0xb8901acB165ed027E32754E0FFe830802919727f')

and EVENT_NAME= 'TransferSentToL2'

and event_inputs:chainId='42161'

and E.BLOCK_TIMESTAMP::date > '2022-06-21'