SELECT *

FROM (

SELECT *,

row_number() over (PARTITION BY from_address ORDER BY block_timestamp) as seq

FROM thorchain.swaps

) txn

WHERE seq = 1

SELECT blockchain, from_asset as asset, count(distinct from_address) as wallets,

SUM(IFF(TO_ASSET = 'THOR.RUNE', 1, 0)) as swap_to_RUNE

FROM first_swap_txns

WHERE blockchain <> 'THOR'

GROUP BY asset, blockchain