flipside

    rbts exp
    Hessishrbts exp
    Updated 2 days 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: 1 day ago
    BET_AMT
    CARDS_IN_SLIP
    BET_ID_DECODED
    TX_HASH
    ORIGIN_FROM_ADDRESS
    BLOCK_TIMESTAMP
    1
    		0.12898920xc94f8da6bd94e90999a3f7d65df5b1663014927dd94a2c39a2043def2881be210x427c1910c358d79973885768d318819689180eaf2025-03-15 16:35:32.000
    2
    		17898910xe9c51b761a4634544154a2c892b85ff4778ecb942e5a3e9309bad83fb49a04870x680f611b1ddb81752bfd334a1b157803af9c5c5a2025-03-15 16:34:51.000
    3
    		12898900x45ca14f849331cb018d42303bec1b65f7049a88d6886f9486d586a35d2fbd94c0xe04b38530565e3f101c4b50efe25baf3ac2908792025-03-15 16:34:46.000
    4
    		0.12898890xff8e9ee595d69ea470d4d2fd3e4a8458bdc597d09700aefad2f72f399697946e0x1ae0c610b3e31e1d6362c2927b5e88c090d1377b2025-03-15 16:34:28.000
    5
    		0.12898880x34dde37d1bee18e28be5f4c10d0394f1af2289e7b4780b26a076d66edbe12cb70xfab941ec3a71b8f56d566fd301e61e8d0a0606802025-03-15 16:34:19.000
    6
    		0.24898870xb13c54729c09e4ce75a8810dee68cc497af21e69c66e6af00d3243dbc1f353360x09828b718a5f56f0a3a4bddf10d64b399417fe742025-03-15 16:34:12.000
    7
    		0.17898860x3e876939e29a46dd3f9b99ecf5c3018e5c73c964bc3de1d363bb74cf68aa7a9f0x20dbd7436548a314113f89b785faf07d1c00ea752025-03-15 16:33:31.000
    8
    		0.12898850x301836ec375ba23ad7d30663734d4f10684fad322bf1501350a546b3420e9e710x1e3c2340f6fdf42604a0103835387d7d8f1d674a2025-03-15 16:33:23.000
    9
    		107898830x314b53d63376bf2a6633657c3d1b169d02c979140f7fc895b1e1394f7d6ee7430x16a3e03f2d5b4fa60660dffbdf3edb426e086db92025-03-15 16:33:07.000
    10
    		0.33898840x0823f5de51f9d0046544356d4ce6ea7daffc6afb8036dc265e191378633f7f220x670b5a37e95d52da68a4e2610b85b2229170bcc72025-03-15 16:33:07.000
    11
    		0.16898820xce9631b57b1fc1db61b2abd8623e1e3b7455408c07339293924c66f1b92a7c880xb083919e02c372e6d12150b4bd5e0c4c0ea624e72025-03-15 16:30:44.000
    12
    		0.13898810x41ac0812d81015584a5746702d180efac147450712c52116b59b2ddf2d901f680x1ae0c610b3e31e1d6362c2927b5e88c090d1377b2025-03-15 16:30:31.000
    13
    		0.13898800x474cdfb199df079c38ab58ced6df3444728207c485d0d4581568ef735ec9ac2e0x1ae0c610b3e31e1d6362c2927b5e88c090d1377b2025-03-15 16:30:11.000
    14
    		0.15898790xefcfe1485fcf802ebe2a13d9d5e0519520df0c6f4de4c5fdbace973e4f68f5a30x232c2488e0b3505bdbed00e39b56ad990a3c514a2025-03-15 16:29:51.000
    15
    		0.12898780x4a3ddf5720369207a0b78fd01a56e9673b6035a4a3867de2d6c5c3db6a72da860x2c26aacb6f424def38313ef05b1d36c9038e67622025-03-15 16:29:26.000
    16
    		0.22898770x0e2273de586dc2f6272fc72e7114c789cebe5aa5fcdb8e3cb530991dc03dbe850x95a68792fa637e79be31375591a56f513043b54e2025-03-15 16:28:16.000
    17
    		0.12898760xf8250c8ce7a5a8b1265eea7319d9f751e4799dc50e0684c6569dc1c37b5f5c030x3d4a8beaecf40eb9b9e505496a8bc8a371d9fa3c2025-03-15 16:27:27.000
    18
    		0.12898750xbd747a12572bd28a8b96a8250559472d70c2ef18aaecd374392ba51131f932e20x5e6d14c7daf2bc2f4f5ec444f84b2eed542c75092025-03-15 16:25:59.000
    19
    		0.16898740xf5a7df78b87976243d4ae0e4cf0bd223fd6a2b7bd64bde5ec556a316030edfdc0x1940da26583f13439f98c7ae1712b2c9f2e02faf2025-03-15 16:25:49.000
    20
    		0.12898730x860d94ad861fc0a2b3ddd1e1bf71e6cc97e0d61f319d1d147e25dc130d115a010xe38e9c250a4f623e04eaccfd31fc5c1335ff9d442025-03-15 16:25:42.000
    ...
    5000
    761KB
    63s