flipside

    rbts exp
    Hessishrbts exp
    Updated 36 minutes ago
    select
    b.value as bet_amt,
    count(c.tx_hash) 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_traces b
    on a.tx_hash = b.tx_hash
    join monad.testnet.fact_traces c
    on a.tx_hash = c.tx_hash
    WHERE
    a.ORIGIN_FUNCTION_SIGNATURE = '0x5029defb'
    and a.ORIGIN_TO_ADDRESS = '0x3ad50059d6008b711209a509fe58e68f0b672a42'
    and b.TO_ADDRESS = '0x3ad50059d6008b711209a509fe58e68f0b672a42'
    and c.TO_ADDRESS = '0xf70da0470b81315fe9ceb695c9be89f67713c815'
    group by all
    order by BLOCK_TIMESTAMP desc
    limit 5000
    Last run: 36 minutes ago
    BET_AMT
    CARDS_IN_SLIP
    BET_ID_DECODED
    TX_HASH
    ORIGIN_FROM_ADDRESS
    BLOCK_TIMESTAMP
    1
    		0.12988830xcfbe800487062f357920551543d9a7163e155ae0bd8097d6102261c8716da56e0x072d5b90c4c26c47f806ddb9fd24e5159a36b9722025-03-18 02:24:41.000
    2
    		0.35988820xc17f48a20ee0115e040204c53147f9e60f3715a6d00ac311c3b2dbad5daa0d670xdc4ab741c7fc70c245872223e1dca2d1d61b530e2025-03-18 02:24:17.000
    3
    		0.12988810x6992e3387469127e5a261bc6ba86f008fd81327d0413d2f41f0d9c66a49617e20xe8425eb8eb4bdb311bc92599fad73e47f4b9c3d22025-03-18 02:23:34.000
    4
    		0.12988800xf4e30b54e6b700f5801f61ee7cfed9c6f340f0f6592858a28efcacdd531ad4090x3d8035daa53247613be4e75476e899afd4d2e3542025-03-18 02:23:23.000
    5
    		0.13988790x3b68472ba1205b35a3267f2906f40ee7db5fcea604e509e9c78a331779ccb19a0x072d5b90c4c26c47f806ddb9fd24e5159a36b9722025-03-18 02:23:23.000
    6
    		0.12988780x9b883997e7b0b2af1ec6b4f58e9c952256cf5b159abb6ffef45e7753734bbe5a0xe8425eb8eb4bdb311bc92599fad73e47f4b9c3d22025-03-18 02:23:22.000
    7
    		0.13988770xc9b643ee8c9abab66e8c880f42c7a4f9b8de7eff3474e641b1571a713fea89680x1d1180ab509683381c6a5216d5e241f000e91caf2025-03-18 02:23:11.000
    8
    		1.12988760x69569cfba8159811ea0d50f2b97698da51ee8d991b41d03d359854e8b2d92b840xc7185eff4b52f2331a7135d3815c8dc37ceb97df2025-03-18 02:23:04.000
    9
    		0.13988750xa3bf3da8069ffe23ccef08bffb66342ee7e3c49de28128a10a66789b389b593c0x7ff8c30ef7a6deb0396af752c3abb28d3b96d7e92025-03-18 02:22:44.000
    10
    		0.12988740x5106edf5d39d14b8ab53ea77b5caf2505c12f83529ab771f98f452993e6190af0xa4e685862acbe632be607006031dfe9f43b9a1192025-03-18 02:22:39.000
    11
    		0.12988730x5ab391edc388783991bba8fe4983a54183c7ab2c31175e8e86e92bc85e5c2c440x60b38db477d6e67bf35a060c333f6f1820dbae352025-03-18 02:20:51.000
    12
    		0.12988720x74d11f717086f0fa209c8791af7230c59fb119fd4f94d64e4be9d1986b601d6a0x217e21f7a6131a4b60bf63d221d2bbf1ab6f79dd2025-03-18 02:20:15.000
    13
    		0.14988710x1689382f70016b166bfccd3abefe26ae797799e521e75c77906ee113ebd5c9e40x5b40df42949dabf8af873a870c6ac047bec750eb2025-03-18 02:19:51.000
    14
    		0.23988700x0be76154955e84eac05c1d66c379e4f9365a0fd431a33f332f0a1dc9136118050xf871945ae53f4cbe31b01de14b0a5ec12e0181042025-03-18 02:18:56.000
    15
    		0.12988690xd10c8e947e2163434572a626ec48fc7cfa9a15182564a83967010df9aeee91290xac811ce936e1bc16828d6ffcfbee8eaeab36797e2025-03-18 02:18:38.000
    16
    		0.12988680x90cb54b8bc1eaa8049665c339859c3c6ca818440ef65e86215498a446168c14d0xec65354b3bc1baf8905d989556e6a35550f0295c2025-03-18 02:18:38.000
    17
    		0.12988670x535cf69f5a5f3ad6c4a9c79f8655e12cd0de72d5158ae0f7250fb153d257b54b0x084842ca8938f35093a12dd22ea28d9ed614cd1d2025-03-18 02:18:29.000
    18
    		0.12988660x98b6e0936584be46ce8e486f4db9a5544e38e0968e6e0fde3f84665351caa7450xf71123b7cfaba6434a60e9d88585dc144ac23a1c2025-03-18 02:18:16.000
    19
    		0.12988650x9218edf9e80e4b7805b5d3c247e46819b6689e244e9bcf188743cdb98de81c6e0xa0ddf985ec95e4b889baeea6db2c35e0080c72b42025-03-18 02:18:12.000
    20
    		0.12988640x12b0df9bb54ca03c8cd32f1b36c15b6c882eccfc3e48df5729bf2dff2ee8222e0xd8ab4bc12362310113615c76f3f71698dc9cf08e2025-03-18 02:18:00.000
    ...
    5000
    761KB
    88s