(SELECT native_to_address as addr , min(block_timestamp) as first_use, 'swap' as type from thorchain.swaps

where to_asset = 'THOR.RUNE'

GROUP by 1),

cex as

(SELECT to_address as addr,min(block_timestamp) as first_use, 'cex' as type

from thorchain.transfers

where from_address in ('thor1ty6h2ll07fqfzumphp6kq3hm4ps28xlm2l6kd6','thor1t60f02r8jvzjrhtnjgfj4ne6rs5wjnejwmj7fh','thor1uz4fpyd5f5d6p9pzk8lxyj4qxnwq6f9utg0e7k')

GROUP by 1 ),

transfer as

(SELECT to_address as addr,min(block_timestamp) as first_use, 'transfer' as type

from thorchain.transfers

where from_address not in ('thor1ty6h2ll07fqfzumphp6kq3hm4ps28xlm2l6kd6','thor1t60f02r8jvzjrhtnjgfj4ne6rs5wjnejwmj7fh','thor1uz4fpyd5f5d6p9pzk8lxyj4qxnwq6f9utg0e7k')

GROUP by 1 ),

upgrades as

(SELECT to_address as addr,min(block_timestamp) as first_use, 'upgrade' as type

from thorchain.upgrades

GROUP by 1 ),

data_ as

(SELECT * from upgrades

UNION ALL

SELECT * FROM transfer

UNION ALL

SELECT * FROM cex

UNION ALL

SELECT * FROM swaps )

SELECT blockchain, count(DISTINCT ad) as total_addresses from

(SELECT * from

(SELECT * from

(SELECT * from

(select addr as ad , min(first_use) as actual_first_use from data_

GROUP by 1 )

inner join data_

on first_use = actual_first_use and ad = addr )

where type = 'swap' )