AmiRdaily
    Updated 2024-10-16
    select block_timestamp::date as day,
    count(DISTINCT TX_hash) as bridge,
    count(distinct ORIGIN_FROM_ADDRESS) as bridger,
    count(DISTINCT TOKEN_SYMBOL) as tokens_bridged,
    sum(AMOUNT_USD) as bridge_vol
    from avalanche.defi.ez_bridge_activity
    where BLOCK_TIMESTAMP>=current_date-60
    group by 1
    order by 1


    QueryRunArchived: QueryRun has been archived