kaibladeTotal frETH Held
Updated 2022-09-08
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
36
›
⌄
WITH send_receive AS
(SELECT from_address as address, -1*amount AS amount
FROM ethereum.core.ez_token_transfers
WHERE contract_address = '0xb4bd4628e6efb0cb521d9ec35050c75840320374'
UNION ALL
SELECT to_address as address, amount AS amount
FROM ethereum.core.ez_token_transfers
WHERE contract_address = '0xb4bd4628e6efb0cb521d9ec35050c75840320374'
)
,
raw_output AS (
SELECT address, SUM(amount) AS balance
FROM send_receive
GROUP BY address
ORDER BY balance DESC)
,
processed_output AS (
SELECT *
FROM raw_output
WHERE balance > 0
),
TFcreator_raw AS
(SELECT * , LEN(output) as length
FROM ethereum.core.fact_traces
WHERE data:from = '0x0fbb8d17027b16810795b12cbeadc65b252530c4' AND identifier = 'CALL_ORIGIN' AND length = 66
OR (data:from= '0x0fbb8d17027b16810795b12cbeadc65b252530c4' AND identifier = 'CREATE_ORIGIN')
)
,
TFcreator_addresses AS (SELECT (CASE
WHEN identifier = 'CALL_ORIGIN' THEN RIGHT(OUTPUT,40)
WHEN identifier = 'CREATE_ORIGIN' THEN RIGHT(TO_ADDRESS,40)
END
Run a query to Download Data