Flipside TeamTop bridged assets volume - mpine copy
    Updated 2024-09-12
    -- forked from MLDZMN / Top bridged assets volume - mpine @ https://flipsidecrypto.xyz/MLDZMN/q/XHt4Fuc1PqfJ/top-bridged-assets-volume---mpine

    -- forked from Sandesh / Top bridged assets @ https://flipsidecrypto.xyz/Sandesh/q/TfYfcnbVM5Nx/top-bridged-assets

    -- forked from Bridge base query @ https://flipsidecrypto.xyz/edit/queries/1b0b595d-6a46-4d40-8dc5-9443604d20e7

    with deposits as
    (
    (
    SELECT
    'bridge_out' as action,
    tx_hash,
    erc20.block_timestamp,
    dl.label,
    erc20.to_address as bridge_address,
    erc20.contract_address as token_address,
    erc20.SYMBOL as symbol,
    (erc20.amount) as amount,
    (erc20.amount_usd) as usd_amount,
    from
    ethereum.core.ez_token_transfers erc20
    inner join
    ethereum.core.dim_labels dl
    on erc20.to_address=dl.address
    where 1=1
    -- and eth.to_address = lower('0x28C6c06298d514Db089934071355E5743bf21d60')
    and dl.label_type='bridge'
    and dl.label_subtype='bridge'
    and SYMBOL in (
    'USDT','USDC','DAI','WETH','WBTC','ARB','BNB','FDUSD','SHIB','PEPE','stETH',
    'FTM','FLOKI','LINK','APEX','TRX','ID','RSR','RNDR','ONDO','FET'
    )
    )
    union
    (
    SELECT
    QueryRunArchived: QueryRun has been archived