SELECT

DISTINCT instruction:accounts[6] AS mint

FROM

solana.core.fact_events

WHERE

program_id = 'Guard1JwRhJkVH6XZhzoYxeBVQe872VH6QggF4BWmS9g'

AND instruction:accounts[13] = 'yootn8Kf22CQczC732psp7qEqxwPGSDQCFZHkzoXp25'

),

raw AS (

SELECT seller AS user_address

, '-1' AS flow

FROM solana.core.fact_nft_sales

JOIN y00ts_address USING(mint)

UNION ALL

SELECT purchaser AS user_address

, '1' AS flow

FROM solana.core.fact_nft_sales

JOIN y00ts_address USING(mint)

),

holdings AS (

SELECT user_address

, SUM(flow) AS holdings

FROM raw

GROUP BY 1

having holdings > 0

SELECT CURRENT_DATE AS balance_date, *

FROM holdings

ORDER BY holdings DESC

limit 10