account_address,

SUM(amount) AS balance

FROM

aptos.core.fact_transfers AS et

JOIN

aptos.core.dim_tokens AS dt ON et.token_address = dt.token_address

WHERE

dt.symbol = 'GUI'

AND et.success = TRUE

AND et.block_timestamp >= DATEADD({{Period}}, -1, CURRENT_DATE)

GROUP BY

account_address

ORDER BY

balance DESC

LIMIT 10;