marquMayan Swap Bridge - Period Summary by Asset
    Updated 2024-02-03
    with

    transfers_eth as (

    select

    bridge_txs.*
    , coalesce(tokens.contract_address, 'Native ETH') as contract_address
    , coalesce(ifnull(tokens.symbol, left(tokens.contract_address, 8)), 'ETH') as symbol
    , coalesce(tokens.amount, eths.amount, 0) as amount
    , coalesce(tokens.amount_usd
    , eths.amount_usd
    , iff(tokens.contract_address in ('0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48', '0xdac17f958d2ee523a2206206994597c13d831ec7')
    , tokens.amount
    , 0)
    ) as amount_usd
    , 'Ethereum' as source

    from (

    select
    block_timestamp
    , tx_hash
    , origin_from_address
    from ethereum.core.ez_decoded_event_logs
    where tx_status = 'SUCCESS'
    and event_removed = 'false'
    and origin_to_address = '0xf3f04555f8fda510bfc77820fd6eb8446f59e72d' -- Mayan Finance
    and contract_address = '0x98f3c9e6e3face36baad05fe09d375ef1464288b' -- Wormhole Ethereum Core Bridge
    and event_name = 'LogMessagePublished'
    and decoded_log :sender = '0xf3f04555f8fda510bfc77820fd6eb8446f59e72d'
    and substr(decoded_log :payload, 139, 2) = '01' -- Solana Wormhole Chain ID
    and block_timestamp ::date > current_date() - interval '{{weeks}} weeks'

    Last run: about 1 year ago
    SYMBOL
    Vol. USD
    Token Amount
    Bridge Transfers
    Users
    Contract Addresses
    1
    USDC $21,104,169.36 21,106,084.1563584789
    [ "0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48", "0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e", "0xff970a61a04b1ca14834a43f5de4533ebddb5cc8", "0xaf88d065e77c8cc2239327c5edb3a432268e5831", "0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d", "0xc88dc63bf0c8c8198c97db0945e3ef25ca89a8e4", "0x0950fc1ad509358daead5eb8020a3c7d8b43b9da" ]
    2
    ETH $11,842,494.8 4,965.8 50353625
    [ "Native ETH" ]
    3
    USDT $4,867,309.72 4,887,074.5225491985
    [ "0xdac17f958d2ee523a2206206994597c13d831ec7", "0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9", "0x55d398326f99059ff775485246999027b3197955", "0xd343968e46690d6c89a88a36a5b8ce5fb5d65ac4" ]
    4
    WETH $4,738,784.37 1,987.171342610784
    [ "0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2", "0x82af49447d8a07e3bd95bd0d56f35241523fbab1" ]
    5
    WBTC $989,920.19 22.7 3016
    [ "0x2260fac5e5542a773aa44fbcfedf7c193bc2c599" ]
    6
    BNB $303,447.57 1,167.8319511424
    [ "Native BNB" ]
    7
    AVAX $212,530.19 6,198.97831633
    [ "Native AVAX" ]
    8
    DAI $74,246.16 74,335.261711
    [ "0x6b175474e89094c44da98b954eedeac495271d0f" ]
    9
    SOL $68,760. 723.6686
    [ "0xfa54ff1a158b5189ebba6ae130ced6bbd3aea76e", "0xd31a59c85ae9d8edefec411d448f90841571b89c" ]
    10
    USDt $47,695.57 47,721.25146122
    [ "0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7" ]
    11
    BUSD $21,865.5 21,868.244640
    [ "0xe9e7cea3dedca5984780bafc599bd69add087d56" ]
    12
    $1,138.62 106,222.134039
    [ "0x91ca579b0d47e5cfd5d0862c21d5659d39c8ecf0", "0x49d5cc521f75e13fa8eb4e89e9d381352c897c96", "0xb9f747162ab1e95d07361f9048bcdf6edda9eea7" ]
    13
    LDO $982.72 328.6 22
    [ "0x5a98fcbea516cf06857215779fd812ca3bef1b32" ]
    14
    WAVAX $657.47 19.0166
    [ "0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7" ]
    15
    1SOL $578.51 29,320.6632
    [ "0x009178997aff09a67d4caccfeb897fb79d036214" ]
    16
    WBNB $315.14 1.0177
    [ "0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c" ]
    17
    SHIB $261.52 28,011,447.0622
    [ "0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce" ]
    18
    FRAX $202.64 202.7911
    [ "0x853d955acef822db058eb8505911ed77f175b99e" ]
    19
    SUSHI $98.47 89.8411
    [ "0x6b3595068778dd592e39a122f4f5a5cf09c90fe2" ]
    20
    UNI $56.14 8.9 11
    [ "0x1f9840a85d5af5bf1d1762f925bdaddc4201f984" ]
    22
    3KB
    58s