SELECT
a.TX_HASH,
b.MATIC_VALUE
FROM
polygon.core.fact_event_logs a
JOIN polygon.core.fact_transactions b ON b.TX_HASH = a.TX_HASH
WHERE
--a.TX_HASH = lower('0x7b9644215f16efb8d0c11bc834333dda98fe8ece257d80d8f7b5643c24afb486')
--AND
a.CONTRACT_ADDRESS = lower('0xb609996e8f1754e63ef08300406c6d7529bb4007')
AND
a.TX_STATUS = 'SUCCESS'
LIMIT 10