deevhyn2024-04-18 02:57 AM
    Updated 2024-04-18
    SELECT
    COUNT(DISTINCT date_trunc('day', block_timestamp)) AS date,
    COUNT(DISTINCT tx_hash) AS Transactions,
    COUNT(DISTINCT sender) AS Users,
    SUM(amount) AS usd_volume,
    usd_volume/date AS avg_vol_per_day
    FROM axelar.defi.ez_bridge_satellite
    WHERE block_timestamp >= '2023-01-01'


    QueryRunArchived: QueryRun has been archived