with axelarscan_flipside as (with axelar_services as ( select created_at, data:value as amount, 'GMP' as "Service" from axelar.axelscan.fact_gmp union all select created_at, case when created_at::date>='2023-08-01' and created_at::date<='2023-08-31' then 0.02741*(data:send:amount * data:link:price) else (data:send:amount * data:link:price) end as amount, 'Token Transfers' as "Service" from axelar.axelscan.fact_transfers where (data:send:amount) <> '' and (data:link:price) <> '' and (data:link:price) <> '[]' and (data:send:amount * data:link:price) <= 20000000 union all select created_at, 0.97259*(data:send:amount * data:link:price) as amount, 'Airdrop Participations' as "Service" from axelar.axelscan.fact_transfers where (data:send:amount) <> '' and (data:link:price) <> '' and (data:link:price) <> '[]' and (data:send:amount * data:link:price) <= 20000000 and (created_at::date>='2023-08-01' and created_at::date<='2023-08-31')) select date_trunc('month',created_at) as "Date", round(sum(amount),2) as "Transfers Volume", "Service" from axelar_services where "Service"<>'Airdrop Participations' group by 1,3), axelarscan_direct as (WITH token_transfer_tab AS ( WITH axelar_table AS ( SELECT TO_TIMESTAMP_LTZ(value:timestamp::NUMBER / 1000) AS block_timestamp, value:num_txs AS num_txs, value:users AS user, value:volume AS volume, value:fee AS fee FROM (SELECT PARSE_JSON(livequery.live.udf_api('https://api.axelarscan.io/token/transfersChart')) AS response), LATERAL FLATTEN(input => response:data:data) ) SELECT DATE_TRUNC('month', block_timestamp) AS "Date", case when date_trunc('month', block_timestamp)='2023-08-01 00:00:00.000' then 0.02742*(sum(volume)) else round(sum(volume)) end as "Transfers Volume", sum(num_txs) as "Transfers Count", round(sum(fee),2) as "Transfer Fees", 'Token Transfers' as "Service" FROM axelar_table WHERE block_timestamp != TO_TIMESTAMP_LTZ(0) GROUP BY block_timestamp ), ------------------------------------------------------------------------ gmp_tab AS ( WITH axelar_table AS ( SELECT TO_TIMESTAMP_LTZ(value:timestamp::NUMBER / 1000) AS block_timestamp, value:num_txs AS num_txs, value:users AS user, value:volume AS volume, value:fee AS fee FROM (SELECT PARSE_JSON(livequery.live.udf_api('https://api.axelarscan.io/gmp/GMPChart')) AS response), LATERAL FLATTEN(input => response:data:data) ) SELECT DATE_TRUNC('month', block_timestamp) AS "Date", round(SUM(volume)) AS "Transfers Volume", sum(num_txs) as "Transfers Count", round(sum(fee),2) as "Transfer Fees", 'GMP' as "Service" FROM axelar_table WHERE block_timestamp != TO_TIMESTAMP_LTZ(0) GROUP BY 1 ) -------------------------------------------------------------- SELECT * FROM token_transfer_tab UNION ALL SELECT * FROM gmp_tab) select "Date", round(sum("Transfer Fees"),2) as "Transfer Fees", "Service" from axelarscan_direct group by 1, 3 order by 1

Query	Creator	Created
Top 5 Interchain Tokens By Transaction Count axelar ibc axelscan	Flipside Axelar Analysts	Dec 23, 2024
Total paths axelar ibc axelscan	Flipside Axelar Analysts	Dec 23, 2024
Cross-Chain Transfer Fees per Month axelar ibc axelscan	Flipside Axelar Analysts	Dec 22, 2024

Flipside Axelar Analysts

2 Members