revolutionary-olive

datavortexrevolutionary-olive

Updated 2025-02-13

SELECT

input_data, r, s, v, nonce

FROM

ronin.core.fact_transactions

WHERE

LOWER(to_address) = '0xb4b0d985ce412a428676b22b858ad973a8c0bede'

LIMIT 200;

-- Extract gaming-related transaction details from Ronin blockchain

SELECT * from ronin.core.ez_decoded_event_logs

WHERE contract_address = '0xb4b0d985ce412a428676b22b858ad973a8c0bede'

--where contract_name ilike '%tama meme%'

--and event_name = 'Transfer'

LIMIT 100

--Transfer

--Approval

SELECT * from ronin.core.fact_event_logs

where tx_hash = '0x03842f94478931ad5c73114e4f604362745b28f4a1f345a580bf5066f848a18d'

and contract_address = '0xb4b0d985ce412a428676b22b858ad973a8c0bede'

--where contract_address = '0xd8deae5e75750512b50ef20dbf8e0163af3d6acc'

--limit

-- 100 --0x3593564c

QueryRunArchived: QueryRun has been archived

flipside