datavortexcian
Updated 2025-01-04
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
30
31
32
33
34
35
›
⌄
WITH combined_data AS (
SELECT
from_address AS "from",
amount_usd
FROM
ethereum.core.ez_token_transfers t
WHERE
t.to_address = LOWER('0x6dD1736E15857eE65889927f40CE3cbde3c59Cb2')
AND "from" != LOWER('0x0000000000000000000000000000000000000000')
AND contract_address = LOWER('0xa1290d69c65a6fe4df752f95823fae25cb99e5a7')
UNION ALL
SELECT
from_address AS "from",
amount_usd
FROM
ethereum.core.ez_token_transfers t
WHERE
t.to_address IN (
LOWER('0x6dD1736E15857eE65889927f40CE3cbde3c59Cb2'),
LOWER('0x83B5ab43b246F7afDf465103eb1034c8dfAf36f2'),
LOWER('0xf7cb66145c5Fbc198cD4E43413b61786fb12dF95')
)
AND "from" != LOWER('0x0000000000000000000000000000000000000000')
)
SELECT
COUNT(DISTINCT "from") AS total_from_addresses,
SUM(amount_usd) AS total_amount_usd
FROM
combined_data;
QueryRunArchived: QueryRun has been archived