query_params AS (

SELECT '2022-06-06 00:00:00.000' AS start_time

),

polygon_hop_bridge_transactions AS (

SELECT

ev.tx_hash

, ev.block_timestamp

-- , ev.event_inputs['amount']::integer AS amount_raw

, (CASE ev.event_inputs['chainId']::integer

WHEN 137 THEN 'Polygon'

WHEN 42161 THEN 'Arbitrum'

WHEN 10 THEN 'Optimism'

WHEN 100 THEN 'Gnosis'

ELSE ev.event_inputs['chainId']::varchar END) AS l2_chain

, ev.event_inputs['recipient'] AS wallet_address

, 'ETH' AS symbol

, tr.amount AS amount_tokens

, tr.amount_usd

FROM ethereum.core.fact_event_logs AS ev

LEFT JOIN ethereum.core.ez_eth_transfers AS tr

ON tr.tx_hash = ev.tx_hash

WHERE ev.contract_address = '0xb8901acb165ed027e32754e0ffe830802919727f' -- ETH

AND ev.event_name = 'TransferSentToL2'

AND ev.tx_status = 'SUCCESS'

AND l2_chain = 'Polygon'

UNION ALL

SELECT