deevhyntotal satellite trades and users
    Updated 2024-07-04
    SELECT
    COUNT(DISTINCT tx_hash) AS total_trades,
    COUNT(DISTINCT sender) AS total_users,
    COUNT(DISTINCT tx_hash) / 3 AS avg_trade_per_month,
    total_trades / total_users AS avg_trade_per_user
    FROM axelar.defi.ez_bridge_satellite
    WHERE date_part('quarter', block_timestamp) = 1
    AND date_part('year', block_timestamp) = 2024

    QueryRunArchived: QueryRun has been archived