Deebs-DeFi-j9fRbzAggregating our Data with SUM function and ORDER BY
Updated 2025-04-07Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
›
⌄
-- 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