flipside

    rbts exp
    Hessishrbts exp
    Updated 3 hours ago
    select
    b.value as bet_amt,
    ((LENGTH(RIGHT(data, LENGTH(data) - 194)) / 64) - 1) as cards_in_slip,
    ethereum.public.udf_hex_to_int(a.TOPICS[2]) as bet_id_decoded,
    a.tx_hash,
    a.ORIGIN_FROM_ADDRESS,
    a.BLOCK_TIMESTAMP
    from monad.testnet.fact_event_logs a
    join monad.testnet.fact_transactions b
    on a.tx_hash = b.tx_hash
    WHERE
    a.ORIGIN_FUNCTION_SIGNATURE = '0x5029defb'
    and a.ORIGIN_TO_ADDRESS in ('0x3ad50059d6008b711209a509fe58e68f0b672a42','0x740990cb01e893a371a050736c62ae0b779109e7')
    and b.TO_ADDRESS in ('0x3ad50059d6008b711209a509fe58e68f0b672a42','0x740990cb01e893a371a050736c62ae0b779109e7')
    group by all
    order by BLOCK_TIMESTAMP desc
    limit 5000
    Last run: about 3 hours ago
    BET_AMT
    CARDS_IN_SLIP
    BET_ID_DECODED
    TX_HASH
    ORIGIN_FROM_ADDRESS
    BLOCK_TIMESTAMP
    1
    		0.12206520x5d7066366d024822a60c6643200dfc0ffffc2c3136af59b73416e4aedecda1180x1d87b5bf4a3bc4410b893431c6ac7bc338982ca42025-04-24 03:35:21.000
    2
    		0.14206510x350795398dc2a4d903759e015b61a9962fa90a631e80c528c4bc5448b7d4afa80x3e61ecb0fe326353eec8b7e37552d8f7b85227f92025-04-24 03:35:12.000
    3
    		0.13206500xc171b9d3ecd0c6e4bf2bdd0b44599ad44fe421fcd65351c6aa18a5e0c6f5f8560x7b8c005de6e2e6e60057513bd0e8935921d595e32025-04-24 03:34:05.000
    4
    		0.121997730x27fe078699d944e63913f6e7ea091c0d38abbb0bd6fb3e298b5b0d266fbc19470x7a5e9c1de84f93a29a7f2864e2e1f36aa76b6a9d2025-04-24 03:34:00.000
    5
    		0.121997720x1b85255ab3f0a55771ad01b6e5685f91add1be8be7e481e2d3f141c2d2d56f6b0x3612dfc2ad4e49186454dc8db4fa7b37c34e9d502025-04-24 03:33:15.000
    6
    		0.121997710x9ef447087afe20486d111e8308607afed8370d6be38ebc6ad9cca719eb3efb930x1246d3707586075c478805e9143b3267f8e526742025-04-24 03:33:06.000
    7
    		0.121997700x09a68d5122982facbe6195bbbde62e55ce152a64fa841bb541e36feaf6d895f30x845703db6909566f9664108346e83a0c7cbbf9e12025-04-24 03:33:03.000
    8
    		0.12206490xa4dcac991823bf66e2aa6e0f62a12c7d3e1e3166ab7577d422df80cdeb86d7560x2c811f3ce70e2e3e7dc3413eea2b0470877a9b032025-04-24 03:33:02.000
    9
    		0.12206480xb817d5247a9c7ed67af5173d115b8af4be0069f128735e8373040baede3c08250xd7b9236f62569e1690ab0b0b689c5ecf8dbc571c2025-04-24 03:33:00.000
    10
    		0.12206470x2791f7e52aedad8628725867c8a837c8b968541db0a7d1deaabdc1dd88fa4ae20xa5f819af80d320842e99742e31674b7025c961b12025-04-24 03:32:58.000
    11
    		0.12206460x350583deb5c2d732e713fa35f1575839cd939cc949304b271554cd60915ef8010xfb37c95d8070acdfebcb487e144f4644a90b281d2025-04-24 03:32:49.000
    12
    		0.12206450xa5f8aad2d440ae775122b90cd983814ae5ad32b248aa8871135ce5c22a42f49c0x2c6fbc57a6a771b86378fb01e36fbe3c1b414eca2025-04-24 03:32:35.000
    13
    		0.12206440x16e9ddaf297a9a3cec75bc89a1c228cb2966828865663ae494aee2a00e79569f0x8dfde6fd46b609a61650a08ec0e400e2c42adf1c2025-04-24 03:32:29.000
    14
    		0.121997690x78a78a5f32eef8b49d72eaf19b1ba9fa2c445db27f8a9a5732a8978dea2937000x83cae742c8cfe0cb11cc123e7238fe0766bd37362025-04-24 03:32:22.000
    15
    		0.12206430xfdac5f3053f24dbaa33904cf1225769d9811693c3993fe7dc28174bca132fa170x57f9eb38885f5efd9e8e1fb9e5a85af0c13978e22025-04-24 03:32:19.000
    16
    		0.121997680xef7c7d53ec3c8b8507fb4f2ddca6c627f15572e36925c73cc61443edbec7156f0xef75e11e504154cf87b8018af5e737a23c09206d2025-04-24 03:32:15.000
    17
    		0.121997670x99dcb3c03911c476e118ee4c250e5aa6eb9846dee2819445062c7a7823c0c91c0xb83ade556c1022d2c0c917a8cfa0a699397dd0e72025-04-24 03:32:00.000
    18
    		0.27206420x6dee3486c284a9b950bf6c265098207ef1a4f580b4d94a0aba4f53e3d78e90ca0x216d7e5273dced2962e3f3d8feb9333757c8cbda2025-04-24 03:31:56.000
    19
    		0.12206410x90712cd5977cd4884f153cfa9546b55ff60b401a8cb07ed05ae2c3a295377e9c0x360acde8730557db55ead35408fe5a5c9e728f562025-04-24 03:31:54.000
    20
    		0.121997660xe78b140b83b9c947ed91a6122ba069bb8d4a4dfa8a7cc74f1ea2df96df0e97880x29f9713f56f47c15ee228435f69afeb650ddc2842025-04-24 03:31:40.000
    ...
    5000
    761KB
    103s