datavortexVolume Per Trader
    Updated 2024-11-05
    WITH EthereumUserVolume AS (
    SELECT
    origin_from_address AS user,
    SUM(amount_in_usd) AS total_volume
    FROM
    ethereum.defi.ez_dex_swaps
    WHERE
    block_timestamp BETWEEN '2024-01-01' AND '2024-10-31'
    GROUP BY
    origin_from_address
    ),
    SolanaUserVolume AS (
    SELECT
    swapper AS user,
    SUM(swap_from_amount_usd) AS total_volume
    FROM
    solana.defi.ez_dex_swaps
    WHERE
    block_timestamp BETWEEN '2024-01-01' AND '2024-10-31'
    GROUP BY
    swapper
    )

    SELECT
    'Ethereum' AS Platform,
    AVG(total_volume) AS AvgVolumePerUser
    FROM
    EthereumUserVolume
    UNION ALL
    SELECT
    'Solana' AS Platform,
    AVG(total_volume) AS AvgVolumePerUser
    FROM
    SolanaUserVolume;

    QueryRunArchived: QueryRun has been archived