sssstatisticLucky Coin History
Updated 2024-12-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
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
Auto-refreshes every 12 hours
QueryRunArchived: QueryRun has been archived