Eman-Raztotal stats: deployer & fee
Updated 2025-02-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT count(distinct data:call:transaction:from) as "Deployer",
sum(data:gas:gas_used_amount * data:gas_price_rate:source_token.token_price.usd) as "Gas Fees"
FROM axelar.axelscan.fact_gmp
where data:interchain_token_deployment_started:event='InterchainTokenDeploymentStarted'
and data:approved:returnValues:contractAddress='0xB5FB4BE02232B1bBA4dC8f81dc24C26980dE9e3C'
and status='executed'
and event='ContractCall'
and simplified_status='received'
and gas_status='gas_paid_enough_gas'
and is_call_from_relayer='false'
and is_invalid_call='false'
and is_two_way='false'
and created_at::date between '{{Start_Date}}' and '{{End_Date}}'
Auto-refreshes every 24 hours
QueryRunArchived: QueryRun has been archived