sssstatisticLucky Coin History
    Updated 2024-12-15
    select decoded_log['tableId'] AS tableId,
    max(decoded_log['host']) AS host,
    max(decoded_log['player']) AS player,
    max(decoded_log['winner']) AS winner,
    max(decoded_log['reward'] / pow(10, 18)) AS reward
    from blast.core.ez_decoded_event_logs
    where contract_address = '0xaf466677d96e6df2e31a86fda7e54a31d64647ed'
    and event_name in (
    'NewTable',
    'Play',
    'Claim'
    )
    GROUP BY decoded_log['tableId']
    order by tableId DESC
    Last run: 2 months agoAuto-refreshes every 12 hours
    TABLEID
    HOST
    PLAYER
    WINNER
    REWARD
    1
    13431
    0xfd53384d48af026f582dd9a525d542de0403af58
    0xfa585be0a6a84bd1f80a605767440cff05ab0588
    0xfa585be0a6a84bd1f80a605767440cff05ab0588
    204060000
    2
    13430
    0x790e3620d2e4c920727ae7619806bcda88859f55
    0x54a6b302abd33d44cee0232dc2bc90303acb849c
    0x54a6b302abd33d44cee0232dc2bc90303acb849c
    9500000
    3
    13429
    0x29b1d8eca3e640dad9decccaa3cb1589bf6ada07
    0xfdb3cfe0b781fc3124b9d12a1560b0766058edfa
    0xfdb3cfe0b781fc3124b9d12a1560b0766058edfa
    2660000000
    4
    13428
    0x29b1d8eca3e640dad9decccaa3cb1589bf6ada07
    0xfdb3cfe0b781fc3124b9d12a1560b0766058edfa
    0xfdb3cfe0b781fc3124b9d12a1560b0766058edfa
    855000000
    5
    13427
    0x8fbf818228b9d8d3b1723904f881d3f25c65249d
    0x790e3620d2e4c920727ae7619806bcda88859f55
    0x790e3620d2e4c920727ae7619806bcda88859f55
    38000000
    6
    13426
    0x8fbf818228b9d8d3b1723904f881d3f25c65249d
    0x0699e9f43597ddb38eea68ef2420839a0fa3b603
    0x0699e9f43597ddb38eea68ef2420839a0fa3b603
    19000000
    7
    13425
    0x2d553e8a46bb75ff16782ed9165506d982498dda
    0xebcd6813836631afbbb0e83c30bc4e88e1a54e33
    0x2d553e8a46bb75ff16782ed9165506d982498dda
    190000000
    8
    13424
    0xcec99a2749ee1ae44532bf1aa00775fe87916c85
    0xc7dcf2f21a9765b11a8edfc91fd531de6373dbd4
    0xcec99a2749ee1ae44532bf1aa00775fe87916c85
    95000000
    9
    13423
    0x8ed5d448b1b0623522e78fb1e68dccf255a8dd81
    0x20aef130be2f2f3dbd70ffcd04bb07b53fe714a9
    0x20aef130be2f2f3dbd70ffcd04bb07b53fe714a9
    1900000
    10
    13422
    0x824a5dd20cf27c51da3a7726dd2e8ac8a83ff732
    0x20aef130be2f2f3dbd70ffcd04bb07b53fe714a9
    0x20aef130be2f2f3dbd70ffcd04bb07b53fe714a9
    76000000
    11
    13421
    0x824a5dd20cf27c51da3a7726dd2e8ac8a83ff732
    0x20aef130be2f2f3dbd70ffcd04bb07b53fe714a9
    0x20aef130be2f2f3dbd70ffcd04bb07b53fe714a9
    66500000
    12
    13420
    0x824a5dd20cf27c51da3a7726dd2e8ac8a83ff732
    0xcec99a2749ee1ae44532bf1aa00775fe87916c85
    0xcec99a2749ee1ae44532bf1aa00775fe87916c85
    76000000
    13
    13419
    0x824a5dd20cf27c51da3a7726dd2e8ac8a83ff732
    0x20aef130be2f2f3dbd70ffcd04bb07b53fe714a9
    0x20aef130be2f2f3dbd70ffcd04bb07b53fe714a9
    2850000
    14
    13418
    0x790e3620d2e4c920727ae7619806bcda88859f55
    0xeb5deee8e8276bce3f6c7d270c89db64439c9beb
    0xeb5deee8e8276bce3f6c7d270c89db64439c9beb
    9500000
    15
    13417
    0x29b1d8eca3e640dad9decccaa3cb1589bf6ada07
    0x3162066ae00fbf95fba02eeeccdc841e42729f56
    0x3162066ae00fbf95fba02eeeccdc841e42729f56
    475000000
    16
    13416
    0x29b1d8eca3e640dad9decccaa3cb1589bf6ada07
    0x3162066ae00fbf95fba02eeeccdc841e42729f56
    0x3162066ae00fbf95fba02eeeccdc841e42729f56
    722000000
    17
    13415
    0x29b1d8eca3e640dad9decccaa3cb1589bf6ada07
    0x3162066ae00fbf95fba02eeeccdc841e42729f56
    0x3162066ae00fbf95fba02eeeccdc841e42729f56
    323000000
    18
    13414
    0x29b1d8eca3e640dad9decccaa3cb1589bf6ada07
    0x3162066ae00fbf95fba02eeeccdc841e42729f56
    0x3162066ae00fbf95fba02eeeccdc841e42729f56
    285000000
    19
    13413
    0x29b1d8eca3e640dad9decccaa3cb1589bf6ada07
    0x3162066ae00fbf95fba02eeeccdc841e42729f56
    0x29b1d8eca3e640dad9decccaa3cb1589bf6ada07
    68150796
    20
    13412
    0x29b1d8eca3e640dad9decccaa3cb1589bf6ada07
    0x3162066ae00fbf95fba02eeeccdc841e42729f56
    0x3162066ae00fbf95fba02eeeccdc841e42729f56
    66500000
    ...
    13431
    2MB
    30s