address_name as token_address,

COUNT(DISTINCT(tx_id)) as unique_swaps

FROM solana.swaps a

LEFT JOIN solana.labels b

ON a.swap_to_mint = b.address

WHERE swap_from_mint = 'So11111111111111111111111111111111111111112'

AND swap_program = 'orca'

AND succeeded = 'TRUE'

AND block_timestamp >= current_date -30

GROUP BY token_address

ORDER BY unique_swaps DESC

LIMIT 5