transfers as (

SELECT

case when from_address in ('thor1ty6h2ll07fqfzumphp6kq3hm4ps28xlm2l6kd6') then 'Crypto.com CEX'

when from_address in ('thor1t60f02r8jvzjrhtnjgfj4ne6rs5wjnejwmj7fh','thor1uz4fpyd5f5d6p9pzk8lxyj4qxnwq6f9utg0e7k') then 'Binance CEX'

else 'Direct Transfer' end as origin,

to_address as member,

min(block_timestamp) as debut

from flipside_prod_db.thorchain.transfers

where asset='THOR.RUNE'

group by 1,2

),

upgrades as (

SELECT

case when burn_asset='BNB.RUNE-B1A' then 'BNB upgrade'

else 'ETH upgrade' end as origin,

to_address as member,

min(block_timestamp) as debut

from flipside_prod_db.thorchain.upgrades

group by 1,2

),

swaps as (

SELECT

'Swap from other chains asset' as origin,

native_to_address as member,

min(block_timestamp) as debut

from flipside_prod_db.thorchain.swaps

where from_asset <> 'THOR.RUNE' and to_asset='THOR.RUNE'

group by 1,2

),

final_data as (

select * from transfers

UNION

select * from upgrades

UNION

select * from swaps