flipside

    rbts exp
    Hessishrbts exp
    Updated 4 hours 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: about 4 hours ago
    BET_AMT
    CARDS_IN_SLIP
    BET_ID_DECODED
    TX_HASH
    ORIGIN_FROM_ADDRESS
    BLOCK_TIMESTAMP
    1
    		0.93981490x5faa17139c95d7139a72f79b0027289c08e79937646da1b4a52d8d1edc893d880x83ac4cc66e5bd3497cc753c8527e94a754ada8602025-03-17 20:35:26.000
    2
    		0.12981480x7391ea2e29a90999ff04fe22df9277cd0b0dc8fe89784b999c879d79480d6bc00x84c1586f4827915a003f0cc31887a88c795978e12025-03-17 20:35:14.000
    3
    		0.33981470xb434b89bbba0a9f164fa3738d604c324b733ae74d7fcaf0827b8aad380af2b0e0x9cff538bbabed63632356e5cce0297a7f70618522025-03-17 20:34:20.000
    4
    		0.52981460xa1d4dabf787914135361918e2d5e7192a1eceaa8633765b0b68a01fd3d106d090x5b879954ff3efd82690114e409ca6e964a9ae9b22025-03-17 20:33:53.000
    5
    		0.54981450x66bb49b09ab3dad2edc3b08613ac046023989190c14feb14c5ac364aa8d50b770x8edc1d93dc1f3ced7245f380c54b0f2ece72cdb82025-03-17 20:33:23.000
    6
    		0.23981440xab43244552c5afdf1e6a129ea13161de0037879854a7680624a88b6731c2701f0x8edc1d93dc1f3ced7245f380c54b0f2ece72cdb82025-03-17 20:32:56.000
    7
    		0.12981430x79a1c98f7f8150c3f7a46a221b71746fd87bdd05313caf8eb99b6587af6eb6520x0e90f3af5dc8bd534f72070a17814f08840e84512025-03-17 20:31:09.000
    8
    		0.12981420xa3512b619c884a615263eaf54e5cba62bf1b955cd793c1a232a80ec7ec0857a10x8cfcb920d1006fa0506d24b3cd33d7205f84efeb2025-03-17 20:31:08.000
    9
    		0.12981410x51c7b9ef33b29485d925353982be900a46a44763c888c8fe5edcb174f9e3e0740x8020aede70e00316199d689bf40dfc906e0a62832025-03-17 20:30:23.000
    10
    		0.12981400x2f912c42e2f55d6eb0f9ce6dc810e4be7df7c941e9bfcf52bb40301d45806f400xd695003f2ec2417907311d78b5ff8f58e3b537252025-03-17 20:30:08.000
    11
    		0.14981390x85fc144d1a0b3b5ee5c2d472e77bef029cd085f5be38d093da112e36f1f878790x5afa4a27accdab68e23cc4f1ae63d837fb55f3d32025-03-17 20:30:07.000
    12
    		0.12981380xea6b6a792aaf53d00258fd1d4b9dcc416cb1f07f738e2de3f398f18c7b289b720x51dceda5cb994593e92cdbbd0db0a188f2c41e252025-03-17 20:28:57.000
    13
    		0.12981370xae2e1abff016630aed70d0d1c9630f880660347e704172672f0a4b383225ac680x95b7dbe3bd101a79d59974558600b99679c52a4c2025-03-17 20:28:51.000
    14
    		0.12981360x1d1faee770324e9ff728253627e077d1c1a27dd2bb2aa7d8d0baaedaf6483e330xefc16c234ad787e979b5af5b99970c406b6170de2025-03-17 20:28:49.000
    15
    		1.32981350x4a701ab2af8bebf9eb94b4592d3cb2fd2b23fb9ac6aa0652044158bc640506190x3bfc64d70445c3b9055af0cb124043447e69cf042025-03-17 20:28:43.000
    16
    		0.12981340xe63104589382cef97a3a5dd9213bd9298599dd6d14b4184b871ab854ebc4f27d0xe9bcf646fd11ad12d532829ecb6316ea986142d42025-03-17 20:28:37.000
    17
    		0.12981330x6234efd9475fb20fda4ab437a08ccf9ce5fcc4dc7cc53c6ae77e5cf392b965940x4e16faff6cd99f665329936588f9f03864a557b32025-03-17 20:28:32.000
    18
    		0.12981310xaca592253d60ab39a158d45207f988fa2fdddc86921adb78016c87e0f11144890x70a4a113177f54243d430aec741dbc787d7758cd2025-03-17 20:28:24.000
    19
    		0.12981320x41d20e2f79be72c13753b183876146c62ac0a15d93a217bb06d9ee7e1b9d249e0xa506c633cb5462a864ba23e3d8fab4d4cda23c132025-03-17 20:28:24.000
    20
    		0.12981300xac1253c6bb2df7bda6296ab301b8accbc444cf69a5f56aa8f34d6c8c9639a48e0x8fc939fa021cc4ee7e74a3498ed96c6769cf2cab2025-03-17 20:28:22.000
    ...
    5000
    761KB
    56s