Eman-Razhushed-violet
    Updated 2024-10-19
    select sum(amount_usd) as "Transfers Volume",
    avg(amount_usd) as "Avg",
    median(amount_usd) as "Median",
    max(amount_usd) as "Max",
    count(distinct tx_hash) as "Transfers Count",
    count(distinct source_address) as "Senders Count",
    count(distinct destination_address) as "Receivers Count",
    count(distinct source_chain || '➡' || destination_chain) as "# of Path"
    FROM near.defi.ez_bridge_activity
    where platform='allbridge'
    and (source_chain='near' or destination_chain='near')
    and block_timestamp::date between '{{Start_Date}}' and '{{End_Date}}'

    QueryRunArchived: QueryRun has been archived