Cross-Chain Path | Swapper Count | Swap Count | Swap Volume | Swap Fees | Avg Swap Fees | Median Swap Fees | Max Swap Fees | |
|---|---|---|---|---|---|---|---|---|
1 | 56 | 40927 | 76006 | 37942351.4230862 | 97818.249200397 | 1.286980623 | 0.3540722696 | 391.26417527 |
Eman-RazTotal Stats: Swap stats
Updated 2024-09-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select count(distinct lower(data:call:chain) || '➡' || lower(data:call:returnValues:destinationChain)) as "Cross-Chain Path",
count(distinct data:call:transaction:from) as "Swapper Count", count(distinct id) as "Swap Count",
sum(data:value) as "Swap Volume",
sum((data:gas:gas_used_amount)*(data:gas_price_rate:source_token.token_price.usd)) AS "Swap Fees",
avg((data:gas:gas_used_amount)*(data:gas_price_rate:source_token.token_price.usd)) as "Avg Swap Fees",
median((data:gas:gas_used_amount)*(data:gas_price_rate:source_token.token_price.usd)) as "Median Swap Fees",
max((data:gas:gas_used_amount)*(data:gas_price_rate:source_token.token_price.usd)) as "Max Swap Fees"
from axelar.axelscan.fact_gmp
where (call ilike '%0xce16F69375520ab01377ce7B88f5BA8C48F8D666%'
or call ilike '%0xDC3D8e1Abe590BCa428a8a2FC4CfDbD1AcF57Bd9%'
or call ilike '%0x492751eC3c57141deb205eC2da8bFcb410738630%')
and (data:call:chain='scroll' or data:call:returnValues:destinationChain='scroll')
and event='ContractCallWithToken'
and status = 'executed'
and simplified_status = 'received'
and created_at::date between '{{Start_Date}}' and '{{End_Date}}'
Last run: about 2 months agoAuto-refreshes every 24 hours
1
89B
18s