Ali3NDately Aptos => Avalanche Bridged Assets Count
    Updated 2024-10-25
    select date_trunc ({{Time_Interval}},block_timestamp) as date,
    symbol,
    count (distinct tx_hash) as Bridges,
    count (distinct tx_sender) as Bridgor,
    sum (bridges) over (partition by symbol order by date asc) as Cumulative_Bridges
    from aptos.defi.fact_bridge_activity t1 join aptos.core.dim_tokens t2 on t1.token_address = t2.token_address
    where destination_chain_name ilike 'avalanche'
    and block_timestamp >= '{{Start_Date}}' and block_timestamp <= '{{End_Date}}'
    group by 1,2
    order by 1 desc



    Auto-refreshes every 24 hours
    QueryRunArchived: QueryRun has been archived