jackguyCelsius Swaps 2
    Updated 2022-06-19
    WITH tab1 as (
    SELECT
    DISTINCT address
    FROM flipside_prod_db.crosschain.address_labels
    WHERE address_name LIKE 'celsius wallet'
    )

    SELECT
    origin_from_address,
    count(*) as swaps,
    SUM(amount_out_usd) as volume
    from ethereum.core.ez_dex_swaps
    WHERE origin_from_address IN (SELECT * FROM tab1)
    GROUP by 1
    Run a query to Download Data