WITH topoly_bridge AS (

SELECT

date(block_timestamp) AS date,

event_inputs:amount/pow(10,18) AS amount -- Amount of tokens

FROM ethereum.core.fact_event_logs

WHERE tx_status = 'SUCCESS'

AND origin_to_address = '0xa0c68c638235ee32657e8f720a23cec1bfc77c77' -- Filter for Polygon Bridge activity

AND (event_name = 'LockedEther' OR event_name = 'LockedERC20') -- Filter for inflow into Polygon via locked ETH & ERC20 tokens

topoly_hop AS (

SELECT

date(block_timestamp) AS date,

event_inputs:value/pow(10,18) AS amount -- Amount of tokens

FROM flipside_prod_db.polygon.events_emitted

WHERE tx_to_address = '0xb98454270065a31d71bf635f6f7ee6a518dfb849' -- For ETH

OR tx_to_address = '0x25d8039bb044dc227f741a9e381ca4ceae2e6ae8' -- For USDC

OR tx_to_address = '0x6c9a1acf73bd85463a46b0afc076fbdf602b690b' -- For USDT

OR tx_to_address = '0x553bc791d746767166fa3888432038193ceed5e2' -- For MATIC

OR tx_to_address = '0xecf268be00308980b5b3fcd0975d47c4c8e1382a' -- For DAI

OR tx_to_address = '0x91bd9ccec64fc22475323a0e55d58f7786587905' -- For WBTC