AmiRdaily
    Updated 2024-08-17
    select block_timestamp::date as day,
    count(DISTINCT TX_hash) as swaps,
    count(DISTINCT ORIGIN_FROM_ADDRESS) as swappers,
    count(DISTINCT pool_name) as pool_count,
    count(DISTINCT token_in) as sold_tokens,
    count(DISTINCT token_out) as purchase_tokens,
    sum(AMOUNT_OUT_USD) as vol,
    avg(AMOUNT_OUT_USD) as Avg_vol
    from polygon.defi.ez_dex_swaps
    where BLOCK_TIMESTAMP>=current_date-60 and platform='quickswap-v3'
    group by 1
    QueryRunArchived: QueryRun has been archived