Updated 2025-04-08
    SELECT
    block_timestamp,
    tx_hash,
    CONTRACT_ADDRESS,
    ORIGIN_FROM_ADDRESS,
    ORIGIN_FUNCTION_SIGNATURE,
    decoded_log,
    contract_name,
    CASE
    WHEN CAST(decoded_log:_amount0In AS INTEGER) > 0
    THEN CAST(decoded_log:_amount0In AS INTEGER) / POWER(10, 6)
    ELSE CAST(decoded_log:_amount0Out AS INTEGER) / POWER(10, 6)
    END AS amount0_used
    FROM
    ronin.core.ez_decoded_event_logs
    WHERE
    contract_address = '0x4f7687affc10857fccd0938ecda0947de7ad3812'
    AND origin_to_address = '0x5f0acdd3ec767514ff1bf7e79949640bf94576bd'
    AND origin_function_signature = '0x3593564c'
    AND event_name = 'Swap'
    LIMIT 50;

    /*
    select
    block_timestamp, tx_hash, CONTRACT_ADDRESS,
    ORIGIN_FROM_ADDRESS,
    ORIGIN_FUNCTION_SIGNATURE,
    decoded_log, contract_name
    from
    ronin.core.ez_decoded_event_logs
    where
    contract_address = '0x4f7687affc10857fccd0938ecda0947de7ad3812'
    and origin_to_address = '0x5f0acdd3ec767514ff1bf7e79949640bf94576bd'
    and origin_function_signature = '0x3593564c'
    and event_name = 'Swap'
    limit 50;
    Last run: 27 days ago
    BLOCK_TIMESTAMP
    TX_HASH
    CONTRACT_ADDRESS
    ORIGIN_FROM_ADDRESS
    ORIGIN_FUNCTION_SIGNATURE
    DECODED_LOG
    CONTRACT_NAME
    AMOUNT0_USED
    1
    2025-04-08 13:01:34.0000x8653277240e79ad247c3006dfc2faa0ea5ba450796b6f6c62fe749a6686351780x4f7687affc10857fccd0938ecda0947de7ad38120x9722bb4fa956d56c4fed4886472c2b4ea85801f20x3593564c
    {"_amount0In":0,"_amount0Out":8399356,"_amount1In":"15000000000000000000...
    USD Coin - Wrapped Ronin8.399356
    2
    2025-04-07 06:51:31.0000x0e6d83dafaa9c7571e9cdd94cb82fd908f4e044042127dfff2b5b56f30700d860x4f7687affc10857fccd0938ecda0947de7ad38120x2d2d54a64673ed23aca4a7c7165739ebd7c2eb620x3593564c
    {"_amount0In":0,"_amount0Out":7381350,"_amount1In":"14130193821282447279...
    USD Coin - Wrapped Ronin7.38135
    3
    2025-04-07 00:48:39.0000xbeaed63048ec26318bd4d2b6ad60228a98af29d580684bae5bdc9377fd4dee2e0x4f7687affc10857fccd0938ecda0947de7ad38120x3541a17e4a027befe7d2a68b0cb665fe1ba378440x3593564c
    {"_amount0In":700000000,"_amount0Out":0,"_amount1In":0,"_amount1Out":"12...
    USD Coin - Wrapped Ronin700
    4
    2025-04-07 00:20:03.0000x84a0ab8f33a572d926b49b956d53c99d4eecc4c14f94022b1e3e72617880b0770x4f7687affc10857fccd0938ecda0947de7ad38120xfe59ca14be9daf8a7f1bef5b1dd118195d76149e0x3593564c
    {"_amount0In":0,"_amount0Out":15728860,"_amount1In":"2814374836797234232...
    USD Coin - Wrapped Ronin15.72886
    5
    2025-04-07 00:17:09.0000x61f0fc6c1550b0319110d28b3cbe8d2779994b96fc1081d4bc801efc85e740420x4f7687affc10857fccd0938ecda0947de7ad38120xc3386cc0a6cf20e388d89b21724a81ee6005a7780x3593564c
    {"_amount0In":134311,"_amount0Out":0,"_amount1In":0,"_amount1Out":"23843...
    USD Coin - Wrapped Ronin0.134311
    6
    2025-04-07 06:41:39.0000x1896abb2314a553c6b7e0fdc7c59c6648a20d0d0a16da1a7a765c1bee02983210x4f7687affc10857fccd0938ecda0947de7ad38120xe205abf0daf45830494de13869b59a55df0d7f2d0x3593564c
    {"_amount0In":517778,"_amount0Out":0,"_amount1In":0,"_amount1Out":"97101...
    USD Coin - Wrapped Ronin0.517778
    7
    2025-04-07 00:16:39.0000x47fc14df57c1d010d2291d91d5510f994509be21eb01186fff78ccd18a75ec680x4f7687affc10857fccd0938ecda0947de7ad38120x13f72e513b8f50450550db21d233d45496c33bef0x3593564c
    {"_amount0In":0,"_amount0Out":6299658617,"_amount1In":"11250000000000000...
    USD Coin - Wrapped Ronin6299.658617
    8
    2025-04-07 06:38:18.0000xc2bf49e43303cd4971d1f029c234ff6da957098366172b0583178c2b9ed9b0d70x4f7687affc10857fccd0938ecda0947de7ad38120xfe05192ee1214fbf708af62358db6b6bb2b56d900x3593564c
    {"_amount0In":0,"_amount0Out":222920842,"_amount1In":"420000000000000000...
    USD Coin - Wrapped Ronin222.920842
    9
    2025-04-07 07:08:31.0000xa68631dac61a2888064ef7164ad930158478b5017a69242bae540ab99f2744bf0x4f7687affc10857fccd0938ecda0947de7ad38120x30fbd154152d29631f0f91ff272415ad895113880x3593564c
    {"_amount0In":0,"_amount0Out":101525028,"_amount1In":"195000000000000000...
    USD Coin - Wrapped Ronin101.525028
    10
    2025-04-07 06:05:18.0000xd3d7a5d5046b7fceb2082e5923fbd20cf71f0450ae428a3d5e62510b6b3c65760x4f7687affc10857fccd0938ecda0947de7ad38120x65792e11d42f4f85f0c4d937d0829e92a0a07a910x3593564c
    {"_amount0In":0,"_amount0Out":3015000,"_amount1In":"5488342436787836396"...
    USD Coin - Wrapped Ronin3.015
    11
    2025-04-07 07:00:40.0000xd5e3a09390d1d36ec683b262518cf2d6e64533f7642b13c6f44a20f6145d5aa20x4f7687affc10857fccd0938ecda0947de7ad38120xb08dd9c01b4255953390c43001dfa16d3587db730x3593564c
    {"_amount0In":0,"_amount0Out":738675000,"_amount1In":"142511339079203360...
    USD Coin - Wrapped Ronin738.675
    12
    2025-04-04 22:48:13.0000xe2a3b07d15a67cd79e1661e1d573c0fe63ec492af4496436e34b9cedc49796470x4f7687affc10857fccd0938ecda0947de7ad38120xfd074612c12bd2e9422282be0fc8be1c8d67aed40x3593564c
    {"_amount0In":0,"_amount0Out":37180699,"_amount1In":"5610941832471314780...
    USD Coin - Wrapped Ronin37.180699
    13
    2025-04-08 12:33:31.0000xe8d868e373186acd5737c001a3de98dc1e21e826d674981c75b17085009aac400x4f7687affc10857fccd0938ecda0947de7ad38120x8281fd549a198b29506d77efdf2f16d3c24971a40x3593564c
    {"_amount0In":0,"_amount0Out":20077789,"_amount1In":"3580000000000000000...
    USD Coin - Wrapped Ronin20.077789
    14
    2025-04-04 22:41:40.0000x3379317bb8600218bd53e9464469ef890fac57ee4bc29fe9bb3761c2c6922e570x4f7687affc10857fccd0938ecda0947de7ad38120xe54973e6e93a583651b6d05f42602dc5c0ba4ae50x3593564c
    {"_amount0In":0,"_amount0Out":86081109,"_amount1In":"1299172413129897288...
    USD Coin - Wrapped Ronin86.081109
    15
    2025-04-07 00:53:03.0000x3763bf4eee569299b13e357202031da901b48ef24a90380485df658ab0830b5f0x4f7687affc10857fccd0938ecda0947de7ad38120xa2ed3229852c295fa1f1e2141c068679f7a45c060x3593564c
    {"_amount0In":0,"_amount0Out":138187500,"_amount1In":"248665294822741734...
    USD Coin - Wrapped Ronin138.1875
    16
    2025-04-04 22:32:10.0000x80cb70ce6cce1c7d0aa0ca536a33d017f694343e60b644a4998072281ad8664a0x4f7687affc10857fccd0938ecda0947de7ad38120xe8b2e0a9e97913b92a0760454854c4d02e0713020x3593564c
    {"_amount0In":0,"_amount0Out":5040000,"_amount1In":"7608046227608375445"...
    USD Coin - Wrapped Ronin5.04
    17
    2025-04-07 00:58:39.0000x7dd504db0bb4e2501f03746b249fef2dd16a9e369a70bfc7f9a8d2b6b70638ae0x4f7687affc10857fccd0938ecda0947de7ad38120x2ad82d0b4382d588244634fca6d6cd99dc31c6c90x3593564c
    {"_amount0In":0,"_amount0Out":144847842,"_amount1In":"260000000000000000...
    USD Coin - Wrapped Ronin144.847842
    18
    2025-04-07 17:57:21.0000xa320482ecdb7b3faace23e7d690851549acf0e2278763b7cd49ff5e4806341020x4f7687affc10857fccd0938ecda0947de7ad38120x5e48c3444e09d56925ead49bcd6c922893596b680x3593564c
    {"_amount0In":75280906,"_amount0Out":0,"_amount1In":0,"_amount1Out":"133...
    USD Coin - Wrapped Ronin75.280906
    19
    2025-04-04 22:29:10.0000x5934129a27b3bb43c12bfb2db227a0863b40c5588325bccf018f61deffa629d50x4f7687affc10857fccd0938ecda0947de7ad38120x5b45108958a85437a875bd1f303ca50baedd5f750x3593564c
    {"_amount0In":0,"_amount0Out":140282630,"_amount1In":"211762284941782880...
    USD Coin - Wrapped Ronin140.28263
    20
    2025-04-04 23:12:28.0000x17f485fd04341f78419e247002c4ec87de32b9d091df2a2d0253800185d0a6550x4f7687affc10857fccd0938ecda0947de7ad38120xbceea7180b5af5fd01d0215f97c24399d11fead30x3593564c
    {"_amount0In":4469669,"_amount0Out":0,"_amount1In":0,"_amount1Out":"6705...
    USD Coin - Wrapped Ronin4.469669
    50
    21KB
    2s