kumbayaa2024-04-10 02:45 AM
    Updated 2024-04-10
    SELECT DATE_TRUNC('day', BLOCK_TIMESTAMP) AS DATE,PLATFORM,
    CONTRACT_ADDRESS, CREATOR, ORIGIN_FROM_ADDRESS, SENDER,
    SUM (AMOUNT_OUT_USD) AS Amount_received
    FROM ethereum.defi.ez_dex_swaps AS a
    INNER JOIN ethereum.core.dim_labels AS b
    ON a.CONTRACT_ADDRESS=b.address
    WHERE PLATFORM='uniswap-v2' AND AMOUNT_OUT_USD >0
    GROUP BY ('day', BLOCK_TIMESTAMP),PLATFORM,CONTRACT_ADDRESS,
    CREATOR, ORIGIN_FROM_ADDRESS, SENDER,TX_TO
    ORDER BY Amount_received DESC
    LIMIT 10;
    QueryRunArchived: QueryRun has been archived