BlockTrackertop user based on volume of bridge satellitte
Updated 2023-10-25
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 satellite as (
SELECT
CASE
when token_address = 'ibc/6F4968A73F90CF7DE6394BF937D6DF7C7D162D74D839C13F53B41157D315E05F' then 'USTC'
when token_address = 'ibc/4627AD2524E3E0523047E35BB76CC90E37D9D57ACF14F0FCBCEB2480705F3CB8' then 'LUNA'
when token_address = 'ibc/9117A26BA81E29FA4F78F57DC2BD90CD3D26848101BA880445F119B22A1E254E' then 'ATOM'
when token_symbol = 'USDC.axl' then 'axlUSDC'
when token_symbol = 'USDT.axl' then 'axlUSDT'
when token_symbol = 'DOT.axl' then 'DOT'
when token_symbol IN ('axlATOM', 'stATOM') then 'ATOM'
when token_symbol = 'axlMATIC' then 'MATIC'
when token_symbol = 'axlwstETH' then 'ETH'
when token_symbol = 'axlKNC' then 'KNC'
when token_symbol = 'axlFIL' then 'FIL'
when token_symbol = 'axlDAI' then 'DAI'
when token_symbol IN ('polygon.USDC','avalanche.USDC') then 'USDC'
else token_symbol end as symbols,
tx_hash,
block_timestamp,
sender,
CASE when token_address IN ('ibc/6F4968A73F90CF7DE6394BF937D6DF7C7D162D74D839C13F53B41157D315E05F',
'ibc/4627AD2524E3E0523047E35BB76CC90E37D9D57ACF14F0FCBCEB2480705F3CB8',
'ibc/9117A26BA81E29FA4F78F57DC2BD90CD3D26848101BA880445F119B22A1E254E')
then raw_amount/1e6 else amount end as amounts,
source_chain,
destination_chain,
receiver
FROM axelar.defi.ez_bridge_satellite
)
,
main as (
SELECT
a.* , amounts*b.price as amount_usd
FROM satellite a
Run a query to Download Data