Sbhn_NPslow-olive
    Updated 2024-10-16
    select count(*) as txs,
    count(DISTINCT origin_from_address) as users,
    sum(coalesce(amount_in_usd,amount_out_usd)) as usd_volume
    from kaia.defi.ez_dex_swaps
    where platform = 'kaiaswap'
    and block_timestamp::date >= current_date-30
    having usd_volume>0

    QueryRunArchived: QueryRun has been archived