sssstatisticTOP Lucky Coin
    Updated 17 hours ago
    WITH tables AS (
    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['cost'] / pow(10, 18)) AS cost,
    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
    ), info AS (
    -- winner
    SELECT winner as address,
    sum(cost * 90 / 100) AS reward,
    max(cost) AS cost,
    count(*) as times
    FROM tables tb
    WHERE winner is not NULL
    group by winner
    UNION ALL
    -- unlucky
    SELECT CASE
    WHEN winner = player then host
    ELSE player
    END AS address,
    sum(cost * -1) AS reward,
    sum(cost) as cost,
    count(*) as times
    FROM tables
    WHERE winner is not NULL
    Last run: about 17 hours agoAuto-refreshes every 12 hours
    ADDRESS
    CAPITAL
    PROFIT
    Profit(%)
    Play Times
    1
    0x04c9208613e3386802a374c23b064a7f20640321
    13051000000122938992000941.9890583117
    2
    0xaf6b6713724a987e36e7ab7d16020e9c5271b736
    13120000000122430000000933.15548780516
    3
    0x07a83dbd5930ec4d96a28e78302cbad262525298
    46690500000119874400000256.742592176102
    4
    0x438526cc58c30d17793a7996e71dba832224fe3c
    2365291085887029848226.4367.945614596147
    5
    0xe379f51d31a754d01a440819c384ba5126bbbd96
    2050100000086699000000422.90132188714
    6
    0x765aa3116c46aec2aa743514597cedb82baa412a
    1313100000077869000000593.01652577912
    7
    0x06fb7dcd4ae4bfdd5fe9c3a20bbc43165c93db94
    2900000000077300000000266.55172413813
    8
    0x0f1e1c9da8e9aa0a5ea890dadaadefcda541795a
    790300000004077000000051.58800455527
    9
    0x07d18e0241e79cbc3c81ba61cdd061580f8409c5
    1020600000022007800000215.63590045117
    10
    0x51806d0e1f1fda5324650ce41e6efea9f41e7512
    652683680917461770539.2267.5380287633
    11
    0x1af1283d9b8c3dc68a5b4cb96c6895e9a6f27ec0
    5195099900015661050503.330.145812024177
    12
    0xb11412bcacbae0617196bd451974b1ad4d12ed1d
    1278394343415161852935.6118.60075112142
    13
    0x4680f95dbabc0e39daea05a80c10c47c2d6f2975
    1116000000015130000000135.57347670321
    14
    0x62ec1636785797e3c312197a108c018448e72736
    10000000000135000000001352
    15
    0x4c101947fbf01d871d06438f12b149fada868876
    1378777777712544883722.490.9855375210
    16
    0xa5b877f8d4114a2758148f4996686bcc5f7cc1c3
    3000099999912399000001.941.3286223877
    17
    0xcdd5e00124e4f20f63e7ea8416369683b4618947
    3573099999912216055300.334.188954411176
    18
    0xdbdbe2a7b1eb6292f4346825d8d6c5049de4fc52
    270050000001220510000045.19570449956
    19
    0xcdcdb78b04b88acc64977dcf2ac9f169773c52f2
    980020000001189800000012.1405685623
    20
    0xfa585be0a6a84bd1f80a605767440cff05ab0588
    801500000011781660000146.9951341244
    ...
    2765
    209KB
    33s