crypto_gostredundant-beige
    Updated 2024-11-09
    WITH period_data AS (
    SELECT
    tx_hash,
    origin_from_address,
    amount_in_usd,
    CAST(block_timestamp AS DATE) AS transaction_date
    FROM
    blast.defi.ez_dex_swaps
    WHERE
    platform = 'ambient'
    AND block_timestamp >= DATEADD(day, -30, CURRENT_DATE)
    )

    SELECT
    COUNT(DISTINCT tx_hash) / COUNT(DISTINCT transaction_date) AS daily_average_swaps,
    SUM(amount_in_usd) / COUNT(DISTINCT transaction_date) AS daily_volume_usd,
    COUNT(DISTINCT origin_from_address) / COUNT(DISTINCT transaction_date) AS daily_average_swappers,
    AVG(amount_in_usd) AS average_amount_usd
    FROM
    period_data;


    QueryRunArchived: QueryRun has been archived