dannyamahTotal Users
    Updated 2024-03-23
    WITH jupiterV6 AS (
    SELECT
    count(DISTINCT(swapper)) AS total_jupiter_users
    FROM solana.defi.fact_swaps
    WHERE swap_program = 'jupiter swap v6'
    AND swap_to_amount IS NOT NULL
    AND succeeded
    AND date(block_timestamp) >= CURRENT_DATE - INTERVAL '90 Days'
    ),

    uniswapV3 AS (
    SELECT
    count(DISTINCT(sender)) AS total_uniswap_users
    FROM ethereum.uniswapv3.ez_swaps
    WHERE amount1_usd IS NOT NULL
    AND date(block_timestamp) >= CURRENT_DATE - INTERVAL '90 Days'
    )

    SELECT
    total_jupiter_users,
    total_uniswap_users
    FROM jupiterV6, uniswapV3;

    QueryRunArchived: QueryRun has been archived