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
    Last run: 3 months ago
    INPUT_DATA
    R
    S
    V
    NONCE
    1
    0x095ea7b3000000000000000000000000771ca29e483df5447e20a89e0f00e1daf09ef5...
    0xfcda5fe9f04b386d111d7c179416f69ff2dab22285a4ba76d6397c9a84e864050x2ea77a9aa33bd71c39cae17ec904f2e41fb44558634c57f767c298befd35169c4075989
    2
    0x095ea7b3000000000000000000000000771ca29e483df5447e20a89e0f00e1daf09ef5...
    0x3aab2598907ba6c155c1dad84c026466d11ad941c67d8e10c3b1d04b06bc60ef0x42c4e93ba27dcfeba7bde5aaf924fa069df19a32a9e9982169b562bf7f40d86a4076256
    3
    0x095ea7b3000000000000000000000000771ca29e483df5447e20a89e0f00e1daf09ef5...
    0x60d79b5da9dd8111208a961601eb33d430af3be3874ebda8d577666120f2a0430x434ef4d259c29ce5440d01ec17d5c3ab5f61ce8a019fcf607d4ceaae7aa3d764407533
    4
    0x095ea7b300000000000000000000000077f96cf7b98b963fb8a9b84787806d396d953b...
    0x4a5bd8f5d238b842d92b80f887618d355dace119a6cb4178f3572c3df17921570x7aab21d5b0161b5096450cbb5ee1a188dcc7b9feb270cb999e14ccdd628b01340759
    5
    0x095ea7b3000000000000000000000000771ca29e483df5447e20a89e0f00e1daf09ef5...
    0xff67c9c55ddb90d513eafb6824ae9039b7783c83ac6ad41ecc94d2c4e69d71d20xb474341912d51f57e5f56d435a50ae7dddcaec91c95646a241b7fc153fa6ebc407550
    6
    0x095ea7b3000000000000000000000000771ca29e483df5447e20a89e0f00e1daf09ef5...
    0x1c5ba3ecfdb408c3d99cbbe17c07196f22ac8336a645a045d142f8311f32b1bd0x373a53539e8991657b50c5cd76b4e3efc1ec90c15d97b867efed11dcf45c36cc40752332
    7
    0x095ea7b3000000000000000000000000771ca29e483df5447e20a89e0f00e1daf09ef5...
    0x8545be6361e413440c2a9fa2ea699ce9c0cadf3bde51dd9383e742c2427f968b0x206cc71828ddf5d0816734c3206b4c0f367faf3bd437c52f621d1c8d9f7eb48b40761347
    8
    0x095ea7b3000000000000000000000000771ca29e483df5447e20a89e0f00e1daf09ef5...
    0xbd240e0689da13c71fc759a6b3f3ab6aad74a37c3726443d8766fcecc9feb1560x2c9443bb2ee220d0a07208716771bb37fce43b7bc1bb85454315df80ee49ed23407525
    9
    0x095ea7b3000000000000000000000000771ca29e483df5447e20a89e0f00e1daf09ef5...
    0x252390a1b16ae6da9ffc8875115bcbf8a2c92363411c64c7476c582cb0f110ea0x4d785ddc0f05edb4a05741653687bc6bc34ce8f573436a382056a79f19a0a0c440762658
    10
    0x095ea7b3000000000000000000000000771ca29e483df5447e20a89e0f00e1daf09ef5...
    0x6276e29b0fe58ba0b07d76d017f8a553628a0c81904a7e8ef66102bdc5201d460x7fa83366c648a68aa3da85ca1963b4b233c4382ae4317b66a5087da97187a5044075769
    11
    0x095ea7b3000000000000000000000000771ca29e483df5447e20a89e0f00e1daf09ef5...
    0x24fca3a93a623591ffa9e2fac4cde0cc7acc410ebbf80cf59c85ebd1b088b92a0x5cf6f5a677eb5d7621fe80b857d32e467526d4ddf026439f110d1efebd50cafa40751010
    12
    0x095ea7b3000000000000000000000000c05afc8c9353c1dd5f872eccfacd60fd5a2a9a...
    0x730d4cc2e5113644203f277dbfa2fba78fb9147de3284a9bc30fcc4dad1e02360x64b5665678361ad7db0a4f0ac6869a82585f7f2cfd577594e39c78106e5a3f30407651
    13
    0x095ea7b3000000000000000000000000771ca29e483df5447e20a89e0f00e1daf09ef5...
    0xd36de85bc26fe90e1cd5406452c9558af097b4e16dff8f68fb668783c6b4e2490x1d78109edd5a459de90e30fcbcf8f9bb69365195d949c2ec258e84d3555ddda740761414
    14
    0x095ea7b3000000000000000000000000771ca29e483df5447e20a89e0f00e1daf09ef5...
    0x62b531b2403b264951ae8da9eba02cbdd097a25302b1d4f62ffacd71b1c4b08c0x3b51843efdd2437e9c3c1b3d303586392fb23ca78cfd5795b8bceb033b2f30b24075129
    15
    0x095ea7b3000000000000000000000000771ca29e483df5447e20a89e0f00e1daf09ef5...
    0x533a7d0da32c39950ff0199c65654183de66b2855c9c909fd168c435942867e10x2c65bce440d1d90d37eaefc22c2c26169bd97143157f49234afa392e5671b0b94076106
    16
    0x095ea7b3000000000000000000000000771ca29e483df5447e20a89e0f00e1daf09ef5...
    0x77fd6fbae6deed4462b2fed88b807b2db4c3ffb4253eb1b3f4dcc213b5108c8d0x35166339c8f2361519aa0558f153d77c052d162ab491f1b9c853f730bf669b634076531
    17
    0x095ea7b3000000000000000000000000771ca29e483df5447e20a89e0f00e1daf09ef5...
    0x421d5e7f5a8b6233f78b76f2a6a43be3eb9e2b22d0740fc618e4a987e86e0f850x649e7c10eab007c384370de4711980ac710eedbc2426c9183c6f172fd740eb04075733
    18
    0x095ea7b3000000000000000000000000771ca29e483df5447e20a89e0f00e1daf09ef5...
    0xa791143596ca573edc66c7e906ff9e5375cea168c17bf010f72d36fa3caee1040x499a336820c919426a969ee4c80c14e35b0eda18789566cf7b398574c6a845a94076254
    19
    0x095ea7b3000000000000000000000000771ca29e483df5447e20a89e0f00e1daf09ef5...
    0xb57205722a36c239a3330c5be58afc6e8678c77ed68c33301c2a8a465941048a0x661cdf2f1c009ff0cc28c456a2693a9f0160c99cfdc1f87bc4ded009c81d23da4076253
    20
    0x095ea7b3000000000000000000000000771ca29e483df5447e20a89e0f00e1daf09ef5...
    0xd86f1cf49ef2b1c38d09c7f93e8fddbb2db8aa24c1869a4b9b08245ca81e4f2b0x4648b749b5c16d0c36a2cf510ec8956416ef2e7162da5c0f4e540395141002f340751997
    ...
    200
    57KB
    2s