AmiRtotal
    Updated 2024-10-17
    select
    count(DISTINCT TX_hash) as swaps,
    count(DISTINCT ORIGIN_FROM_ADDRESS) as swappers,
    count(DISTINCT POOL_NAME) as pool_count,
    sum(AMOUNT_in_USD) as vol
    from kaia.defi.ez_dex_swaps
    where BLOCK_TIMESTAMP>=current_date-60 and platform='kaiaswap'
    QueryRunArchived: QueryRun has been archived