Eman-RazVolume & Fees Over Time
Updated 2025-01-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select date_trunc('{{Time_Frame}}',created_at) as "Date", sum(data:value) as "Transfers Volume",
sum("Transfers Volume") over (order by "Date" asc) as "Total Transfers Volume",
sum((data:gas:gas_used_amount)*(data:gas_price_rate:source_token.token_price.usd)) AS "Transfer Fees",
sum("Transfer Fees") over (order by "Date") as "Total Transfer Fees",
avg((data:gas:gas_used_amount)*(data:gas_price_rate:source_token.token_price.usd)) AS "Avg",
median((data:gas:gas_used_amount)*(data:gas_price_rate:source_token.token_price.usd)) AS "Median",
max((data:gas:gas_used_amount)*(data:gas_price_rate:source_token.token_price.usd)) AS "Max"
from axelar.axelscan.fact_gmp
where (call ilike '%0xb5fb4be02232b1bba4dc8f81dc24c26980de9e3c%')
and data:interchain_transfer:event='InterchainTransfer'
and event='ContractCall'
and status = 'executed'
and simplified_status = 'received'
and data:executed:receipt:logs[1]:address is not null
and created_at::date between '{{Start_Date}}' and '{{End_Date}}'
group by 1
order by 1
Auto-refreshes every 24 hours
QueryRunArchived: QueryRun has been archived