deevhynTop Q1 AXL Users by volume
    Updated 2024-07-03
    SELECT
    a.sender,
    COUNT(DISTINCT a.tx_hash) + COUNT(DISTINCT b.tx_hash) AS trades,
    SUM(a.amount) + SUM(b.amount) AS total_volume
    FROM axelar.defi.ez_bridge_satellite a
    JOIN axelar.defi.ez_bridge_squid b
    ON a.sender = b.sender
    WHERE date_part('quarter', a.block_timestamp) = 1
    AND date_part('year', a.block_timestamp) = 2024
    AND date_part('quarter', b.block_timestamp) = 1
    AND date_part('year', b.block_timestamp) = 2024
    AND a.amount IS NOT NULL
    AND b.amount IS NOT NULL
    GROUP BY 1
    ORDER BY 3 DESC
    LIMIT 20

    QueryRunArchived: QueryRun has been archived