top sui token sender copy

CartanGrouptop sui token sender copy

Updated 2024-02-01

-- forked from masterdai / top sui token sender @ https://flipsidecrypto.xyz/masterdai/q/MaEEwCapSdOn/top-sui-token-sender

SELECT

value:sender::string AS sender,

value:total::int AS total

FROM

(

SELECT

chainbase_utils.post('/v1/dw/query', {

'query': 'SELECT sender, count() as total FROM sui.transactions WHERE sender != "0x0000000000000000000000000000000000000000000000000000000000000000" GROUP BY sender ORDER BY total DESC LIMIT 10'

}) :: variant AS resp

) AS subquery,

LATERAL FLATTEN(input => resp:data:data:result)

Last run: over 1 year ago

No Data to Display

29s