select

ADDRESS,

PROJECT_NAME,

LABEL_TYPE,

LABEL_SUBTYPE

from near.core.dim_address_labels

where PROJECT_NAME is not null

and LABEL_TYPE not in ('cex','token','validator')),

base as (

(select

date(BLOCK_TIMESTAMP) as date,

TX_HASH,

TX_RECEIVER as user,

TX_SIGNER as project_Address,

b.PROJECT_NAME as project_name,

TRANSACTION_FEE / pow(10,24) as tx_fee

from near.core.fact_transactions a

inner join labels b on a.TX_SIGNER = b.ADDRESS and a.TX_RECEIVER != b.ADDRESS

where TX_STATUS = 'Success')

union all

(select

date(BLOCK_TIMESTAMP) as date,

TX_HASH,

TX_SIGNER as user,

TX_RECEIVER as project_Address,

b.PROJECT_NAME as project_name,

TRANSACTION_FEE / pow(10,24) as tx_fee

from near.core.fact_transactions a

inner join labels b on a.TX_RECEIVER = b.ADDRESS and a.TX_SIGNER != b.ADDRESS

where TX_STATUS = 'Success')

),