flipside

    rbts exp
    Hessishrbts exp
    Updated 11 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 11 hours ago
    BET_AMT
    CARDS_IN_SLIP
    BET_ID_DECODED
    TX_HASH
    ORIGIN_FROM_ADDRESS
    BLOCK_TIMESTAMP
    1
    		0.121118790x300429485c48ad2ce58dc7dcf89142967ce1b64bb1f9e8b8dd232e7d8bc4aa9c0x64bf7f25726dd06eca96b8ce4bd759e5dac4728e2025-03-21 18:35:00.000
    2
    		0.131118780x4473179f9d931b636c125d69461f3feb3001c441407d04a98f10734ceacb7c290x73deb9c8d2e894545eaa6aba8d5d931485fc98262025-03-21 18:34:51.000
    3
    		0.121118770x159263f702795d8f1d950167e42ddfdf71613bbd9bf848cab04f8a217276cad40x9a269d663875f6c06954e66ddfd0a8ff410d807d2025-03-21 18:34:33.000
    4
    		0.121118760xeb1bbdfe7c2e0983fc02fc84780bdb452bef38d9d427c6bf577f33464a2845410x9a269d663875f6c06954e66ddfd0a8ff410d807d2025-03-21 18:34:11.000
    5
    		0.221118750x7bd954cef65f557fcb83fcdee16e74f292c6bf0afdfd154cde5fdfb8034b1e7f0xe9f1f580d6eff56f77e8962669d6d3645fc96b7a2025-03-21 18:32:38.000
    6
    		0.421118740x6fed2c33b8a4015ac1fbee2cc832151dc07796d16f982974197dcbf2313abc070xebdd0990e20dbf8b23bb76bcb0ca9a9287e4a2182025-03-21 18:32:34.000
    7
    		0.221118730xb4694dc45ee4a4e7e80613e7fbdbd23044428fb444a91e7503b2d1d3af4408730xe9f1f580d6eff56f77e8962669d6d3645fc96b7a2025-03-21 18:32:32.000
    8
    		0.221118720xa36ecd456e9d216de13b2bdd9426b10d856f13e0874dcfce2458b2ac0e138f130xe9f1f580d6eff56f77e8962669d6d3645fc96b7a2025-03-21 18:32:25.000
    9
    		0.221118710xeeec118f26625eff0fa74897c729ce2f026a374358dd3c84c807c5af0a4c6d600xe9f1f580d6eff56f77e8962669d6d3645fc96b7a2025-03-21 18:32:12.000
    10
    		0.161118700xe4597499f49b8f62ede22835b1cbe98c609506e3df167bbe246f2caac9d281f90x843574df975a66118ba077d92672003ff1f2d5a52025-03-21 18:32:12.000
    11
    		0.121118690x8ff555c844200b277886fb11f66c47b702fb52d1ef1ad4660d0a6e0d242125090xa7f9a855e8fbfe718b4183102a3d998a413180832025-03-21 18:32:09.000
    12
    		0.221118680x55edbd73931ccf689cbee3491a12396bb769936a30e6d15319d1bd0626ef7b3a0xe9f1f580d6eff56f77e8962669d6d3645fc96b7a2025-03-21 18:31:59.000
    13
    		0.221118670x4ab6d1276e33ab0345835911907a6ca1ff14add8d8eb462dd1b5d24f4e0e93eb0xe9f1f580d6eff56f77e8962669d6d3645fc96b7a2025-03-21 18:31:44.000
    14
    		0.221118660xf76f8c7bae82dc88d80e438ea3fa5dd70bdb9b3fabe5f2d65aa7a47ec6cb79220xe9f1f580d6eff56f77e8962669d6d3645fc96b7a2025-03-21 18:31:38.000
    15
    		0.221118650x9313582791a48a213c11855f714e51f38507b09a57486b858df2df6b34219d9d0xe9f1f580d6eff56f77e8962669d6d3645fc96b7a2025-03-21 18:31:31.000
    16
    		0.121118640x9c920f49ba5d7b09cef1db192eb2d99772feb77b5d02d45b86736cdde468de9f0xfc726ea2bd8bb0dae92f9d28d64e80ca76fa66a62025-03-21 18:31:20.000
    17
    		0.721118620x3ec0669f16fe67763a3a2ea576db08d091bfa5ed7f6f5a8087e4bebe48c9ca750x4074206083e4dbedb41890b3f0e431c9a54f12bd2025-03-21 18:31:15.000
    18
    		0.221118630xe597cd3c578975cc90931a76a6fa26dabf635f5d956b682b13ae46defe047cd40xe9f1f580d6eff56f77e8962669d6d3645fc96b7a2025-03-21 18:31:15.000
    19
    		0.221118610x89c26f761c4c13ff370b935de77cfde526cb5461b139a051c11bc752120a2cec0xe9f1f580d6eff56f77e8962669d6d3645fc96b7a2025-03-21 18:31:09.000
    20
    		0.221118600x76f413891db2f959116981181e37a6d76d3af40944c9bde41145a8aa3fd940b00xe9f1f580d6eff56f77e8962669d6d3645fc96b7a2025-03-21 18:31:03.000
    ...
    5000
    766KB
    76s