with from_address as (sELECT VALUE as source_chain,

created_at,

id,

amount as amount_column,

FROM axelar.axelscan.fact_gmp,

LATERAL FLATTEN(PARSE_JSON(call)) flattened_data

where path = 'chain'

,

sender as (SELECT a.created_at,

a.id,

b.source_chain,

max(amount_column) as amt_column,

max(value:"amount") as amount,

max(value:"destinationChain") as destination_chain,

max(value:"symbol") as symbol,

max(value:"from") as sender

FROM axelar.axelscan.fact_gmp a join from_address b on a.id = b.id,

LATERAL FLATTEN(PARSE_JSON(call)) flattened_data

group by all

,

fee as (SELECT a.id,

a.created_at as date_ii,

max(value:"decimals") as decimal,

max(value:"name") as name,

max(value:"symbol") as symbol_II,

max(value:"value") as amount_II,

max(value:"token_price") as token_price

FROM axelar.axelscan.fact_gmp a join from_address b on a.id = b.id,

LATERAL FLATTEN(PARSE_JSON(FEES)) flattened_data

where path = 'source_token' --source_token

group by all)

,