kumbayaa2024-04-15 09:55 PM
    Updated 2024-04-15
    --ethereum.core.dim_labels
    --ethereum.defi.ez_dex_swaps

    SELECT
    label,
    label_type,
    address_name,
    symbol_in,
    amount_in_usd
    FROM ethereum.defi.ez_dex_swaps x
    JOIN ethereum.core.dim_labels y
    ON x.contract_address = y.address
    WHERE platform LIKE 'uniswap%'
    AND amount_in_usd IS NOT NULL
    ORDER BY 5 DESC
    LIMIT 10
    QueryRunArchived: QueryRun has been archived