Pine Analyticsslow-coral
    Updated 2025-03-08
    select
    date_trunc('week', block_timestamp) as week,
    count(distinct from_address) as swappers,
    count(Distinct tx_id) as transactions,
    sum(case when not FROM_AMOUNT_USD is null then FROM_AMOUNT_USD else to_AMOUNT_USD end) as swap_volume_Usd


    from maya.defi.fact_swaps
    group by 1


    QueryRunArchived: QueryRun has been archived