BlockTrackertop user based on volume of bridge satellitte
    Updated 2023-10-25
    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