potmocomplete fee list by satelite route
Updated 2022-12-10Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with source_msgs as (
select date_trunc('month', block_timestamp) as month,
tx_id,
attribute_value as from_chain,
case when from_chain = 'Ethereum' then 'ETH'
when from_chain = 'Axelarnet' then 'COS'
when from_chain in ('celo', 'Polygon', 'Avalanche', 'arbitrum', 'Moonbeam', 'binance','Fantom') then 'EVM'
else 'oopsie'
end as from_module
from axelar.core.fact_msg_attributes
where attribute_key = 'sourceChain'
and tx_succeeded
),
destination_msgs as (
select tx_id,
attribute_value as to_chain,
case when to_chain = 'Ethereum' then 'ETH'
when to_chain in ('celo', 'Polygon', 'Avalanche', 'arbitrum', 'Moonbeam', 'binance','Fantom') then 'EVM'
else 'COS'
end as to_module
from axelar.core.fact_msg_attributes
where attribute_key = 'destinationChain'
),
senders as (
select
tx_id,
block_timestamp,
attribute_value as sender
from axelar.core.fact_msg_attributes
where TX_SUCCEEDED = 'TRUE'
and attribute_key = 'sender'
),
Run a query to Download Data