count(distinct tx_hash) as frequency,

count(distinct origin_from_address) as Hop_Users,

date_trunc('week', block_timestamp) as TIME,

case when event_inputs:chainId = '10' then 'Optimism'

when event_inputs:chainId = '100' then 'xDAI'

when event_inputs:chainId = '137' then 'Polygon'

when event_inputs:chainId = '42161' then 'Arbitrum'

end as chain

from ethereum.core.fact_event_logs

where origin_to_address in (

lower('0x3666f603Cc164936C1b87e207F36BEBa4AC5f18a'),

lower('0x3E4a3a4796d16c0Cd582C382691998f7c06420B6'),

lower('0x3d4Cc8A61c7528Fd86C55cfe061a78dCBA48EDd1'),

lower('0xb8901acB165ed027E32754E0FFe830802919727f'),

lower('0xb98454270065A31D71Bf635F6F7Ee6A518dFb849'),

lower('0x22B1Cbb8D98a01a3B71D034BB899775A76Eb1cc2'))

and event_name = 'TransferSentToL2'

group by chain, TIME