select

'GMP' as Type,

CREATED_AT as Block_timestamp,

--split(ID, '_')[0] as TX_ID,

ID as TX_ID,

call:transaction:from::string as User_address,

AMOUNT,

CALL:chain::string as Src_Chain,

CALL:returnValues:destinationChain::string as Dst_Chain,

data:symbol::string as Symbol,

data:price::float as Price,

AMOUNT * price as Amount_USD

from axelar.axelscan.fact_gmp

union all

select

'Token Transfer' as Type,

CREATED_AT as Block_timestamp,

--split(ID, '_')[0] as TX_ID,

ID as TX_ID,

SENDER_ADDRESS as User_address,

SEND_AMOUNT as AMOUNT,

SOURCE_CHAIN as Src_Chain,

DESTINATION_CHAIN as Dst_Chain,

SEND_DENOM as Symbol,

link:price as Price,

SEND_AMOUNT * Price as Amount_USD

from axelar.axelscan.fact_transfers

where 1=1

and link:price != '[]'

select

date_trunc(month, block_timestamp) as Month,

Type,