with aurora_label AS (

SELECT address

, initcap(label_type) AS label_typee

, initcap(project_name) AS project

, label_typee || ': '||project AS tag

, initcap(address_name )AS contract_details

FROM crosschain.core.address_labels

WHERE BLOCKCHAIN = 'aurora'

),

base_volume_user_tx AS(

SELECT

'User Is From' AS type

,a.block_timestamp

,a.tx_hash

,a.From_address AS user

,address AS label_interact_address

,value AS tx_volume_eth

,project

,label_typee

,NVL(contract_details , 'Not Have Details') AS any_details

FROM aurora.core.fact_transactions a

JOIN aurora_label b

on a.to_address = b.address

WHERE a.From_address NOT IN(SELECT address FROM aurora_label)

SELECT

'User Is To' AS type

,a.block_timestamp

,a.tx_hash

,a.to_address AS user

,address AS label_interact_address