Deebs-DeFi-j9fRbzAggregating our Data with SUM function and ORDER BY
    Updated 2025-04-07
    -- forked from Aggregating our Data with SUM function @ https://flipsidecrypto.xyz/edit/queries/d0b235dd-949f-41e3-a3a2-5ab2997fc458

    -- forked from Filter data with WHERE - Using Dates AND an Address @ https://flipsidecrypto.xyz/edit/queries/70cba6be-6be1-47a8-968a-262224934f28

    -- forked from Filter data with WHERE - Using Dates @ https://flipsidecrypto.xyz/edit/queries/180d11dd-b1b5-497b-86d2-e5dcaa5ee6de

    -- forked from Filter data with WHERE - Using an address @ https://flipsidecrypto.xyz/edit/queries/0afff5ad-bd2d-4475-85b9-e277163e4834

    -- forked from Your first query! @ https://flipsidecrypto.xyz/edit/queries/08f318a2-b541-4263-8ff5-926d8f2ec6b8

    SELECT
    FROM_ADDRESS,
    SYMBOL,
    contract_address,
    Sum(AMOUNT)
    FROM ethereum.core.ez_token_transfers
    WHERE block_timestamp >= '2023-08-15'
    AND contract_address=lower('0x5A98FcBEA516Cf06857215779Fd812CA3beF1B32')
    GROUP BY FROM_ADDRESS, SYMBOL, contract_address
    ORDER BY Sum(AMOUNT) DESC
    LIMIT 100;





    QueryRunArchived: QueryRun has been archived