SELECT DISTINCT tx_hash

FROM polygon.core.ez_decoded_event_logs

WHERE contract_address LIKE LOWER('0xce16f69375520ab01377ce7b88f5ba8c48f8d666')

SELECT

date_trunc('day', block_timestamp) AS date,

CASE

WHEN to_address LIKE LOWER('0x99a58482BD75cbab83b27EC03CA68fF489b5788f') THEN 'Curve.fi'

ELSE PROJECT_NAME

END AS dex,

COUNT(DISTINCT tx_hash) AS bridges,

count(distinct origin_from_address) as bridgors

FROM polygon.core.fact_token_transfers

LEFT OUTER JOIN crosschain.core.address_labels

ON to_address = address

WHERE contract_address LIKE LOWER('0x750e4C4984a9e0f12978eA6742Bc1c5D248f40ed')

AND from_address LIKE LOWER('0x4fd39C9E151e50580779bd04B1f7eCc310079fd3')

AND tx_hash IN (SELECT * FROM tx)

AND blockchain = 'polygon'

GROUP BY 1, 2