Aggregating our Data with SUM function

Deebs-DeFi-j9fRbzAggregating our Data with SUM function

Updated 2025-04-07

-- 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

LIMIT 100;

Last run: 3 months ago

	FROM_ADDRESS	SYMBOL	CONTRACT_ADDRESS	SUM(AMOUNT)
1	0x45349a412dee632eda4277e535020e7643d58d93	LDO	0x5a98fcbea516cf06857215779fd812ca3bef1b32	18
2	0xecd2123d7fb37503c426daf9692d7ae55b430d8a	LDO	0x5a98fcbea516cf06857215779fd812ca3bef1b32	389.74555
3	0x64fe5fcc4a935d9b8722564ad85031a866f60fdf	LDO	0x5a98fcbea516cf06857215779fd812ca3bef1b32	1066.81164008
4	0x039c7320956110b7e9e350d382a354d6ace8d2c0	LDO	0x5a98fcbea516cf06857215779fd812ca3bef1b32	24.413481991
5	0x20f06904e51db04d93d403c77b3118774f15ee64	LDO	0x5a98fcbea516cf06857215779fd812ca3bef1b32	27.512443798
6	0xbba38b5bdd5a04ab5a9f52db87e64efc299b6bd5	LDO	0x5a98fcbea516cf06857215779fd812ca3bef1b32	1543.136522997
7	0x5f8215ee653cb7225c741c7aa8591468d1f158b8	LDO	0x5a98fcbea516cf06857215779fd812ca3bef1b32	19264875.2169856
8	0x23c63440a659433cc7fd92f753310ad3d9211ff2	LDO	0x5a98fcbea516cf06857215779fd812ca3bef1b32	20.184393029
9	0x48aa9a20ace53186db5e75c5a8208dd5c6c03537	LDO	0x5a98fcbea516cf06857215779fd812ca3bef1b32	354.03983
10	0xcbea7739929cc6a2b4e46a1f6d26841d8d668b9e	LDO	0x5a98fcbea516cf06857215779fd812ca3bef1b32	103015.736816592
11	0x1f80d934f61f3a57ec2e78906204b9d68fc00d86	LDO	0x5a98fcbea516cf06857215779fd812ca3bef1b32	63.65779
12	0x3b3ab975f4150398a0d24299892b8a3f244dd853	LDO	0x5a98fcbea516cf06857215779fd812ca3bef1b32	213741.736243934
13	0x00c600b30fb0400701010f4b080409018b9006e0	LDO	0x5a98fcbea516cf06857215779fd812ca3bef1b32	4643853.6825896
14	0x43f4ede1ff5b467cc85e204d7ed316e3e5e727b8	LDO	0x5a98fcbea516cf06857215779fd812ca3bef1b32	1107.0193034
15	0x56a2b8ee60e54cf6b2a4687f3ca2d63e7998b054	LDO	0x5a98fcbea516cf06857215779fd812ca3bef1b32	460.55333
16	0xf55c79a008a9b98cde8bfeb0b6a69ce49379a9f0	LDO	0x5a98fcbea516cf06857215779fd812ca3bef1b32	1078.5
17	0xeb16a13b91579125c9bf5eaf8215f647d7b9778c	LDO	0x5a98fcbea516cf06857215779fd812ca3bef1b32	10697.597457518
18	0x36835a3878d8a68d0ca68fc80526ff11d63680cb	LDO	0x5a98fcbea516cf06857215779fd812ca3bef1b32	17623.129609794
19	0x23529b46bb5fdb9f9d0427e9a35115551b72581b	LDO	0x5a98fcbea516cf06857215779fd812ca3bef1b32	2205.412055174
20	0x8562b1a83f4d3c791eb3eb1fd66b09e7aa437c31	LDO	0x5a98fcbea516cf06857215779fd812ca3bef1b32	79824.78

100

11KB

10s