mohamadreza221166Total TOKE Holders
Updated 2022-06-21
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
›
⌄
WITH TOKE_transfers AS(
SELECT *
FROM ethereum.core.ez_token_transfers
WHERE CONTRACT_ADDRESS = lower('0x2e9d63788249371f1DFC918a52f8d799F4a38C94')
AND DATE(BLOCK_TIMESTAMP) <= CURRENT_DATE
),
transfers AS(
SELECT FROM_ADDRESS AS ADDRESS, sum(AMOUNT) AS AMOUNT, COUNT(*) number_of_transactions, -1 AS flag
FROM TOKE_transfers
GROUP BY FROM_ADDRESS
UNION
SELECT TO_ADDRESS AS ADDRESS, sum(AMOUNT) AS AMOUNT, COUNT(*) number_of_transactions, 1 AS flag
FROM TOKE_transfers
GROUP BY TO_ADDRESS
)
SELECT COUNT(DISTINCT T1.ADDRESS) number_of_toke_HOlders, sum(T1.Amount * flag)::string total_holded_amount, sum(number_of_transactions) AS number_of_transactions
FROM transfers T1
--SELECT * FROM ethereum.core.fact_transactions WHERE tx_hash = '0x415a7d7d016be2bb0e1d0eaea2a87f3a7d395f199f019282b134191fd22e1673'
--SELECT SYMBOL FROM ethereum.core.ez_token_transfersWHERE SYMBOL LIKE '%TOKE%' GROUP BY SYMBOL
--select * from ethereum.core.dim_contracts where ADDRESS = lower('0x2e9d63788249371f1DFC918a52f8d799F4a38C94')
Run a query to Download Data