SELECT DISTINCT FLOW_WALLET_ADDRESS as addy --249 wallets

from flow.core.fact_bridge_transactions

where DIRECTION = 'inbound'

)

SELECT count (distinct TX_ID) as counts, CONTRACT_NAME, 'token_buyers' as type

from flow.core.fact_swaps

JOIN flow.core.dim_contract_labels

on EVENT_CONTRACT=TOKEN_IN_CONTRACT

WHERE TRADER in (SELECT addy from wallet)

GROUP by 2,3

order by 1 DESC

limit 5