datavortexTraders Categories
    Updated 2024-11-02
    WITH SolanaTransactions AS (
    SELECT
    swapper AS "LeadingSwapper",
    COALESCE(swap_from_amount_usd, 0) AS "TransactionVolume"
    FROM
    solana.defi.ez_dex_swaps
    WHERE
    block_timestamp BETWEEN '2024-10-01'
    AND '2024-10-31'
    ),
    EthereumTransactions AS (
    SELECT
    origin_from_address AS "LeadingSwapper",
    COALESCE(amount_in_usd, 0) AS "TransactionVolume"
    FROM
    ethereum.defi.ez_dex_swaps
    WHERE
    block_timestamp BETWEEN '2024-10-01'
    AND '2024-10-31'
    ),
    SolanaTraderVolume AS (
    SELECT
    "LeadingSwapper",
    SUM(COALESCE("TransactionVolume", 0)) AS "TotalVolumeSolana"
    FROM
    SolanaTransactions
    GROUP BY
    "LeadingSwapper"
    ),
    EthereumTraderVolume AS (
    SELECT
    "LeadingSwapper",
    SUM(COALESCE("TransactionVolume", 0)) AS "TotalVolumeEthereum"
    FROM
    EthereumTransactions
    GROUP BY
    QueryRunArchived: QueryRun has been archived