0xHaM-dTop 10 Tokens
Updated 2024-09-25
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
›
⌄
-- forked from Token Transferring @ https://flipsidecrypto.xyz/edit/queries/63424a3f-7d7d-4be9-8d93-23965bf55ce0
with transferTb as (
SELECT
BLOCK_TIMESTAMP,
EVENT_INDEX,
TX_HASH,
CONTRACT_ADDRESS as token_address,
CONCAT('0x', SUBSTR(topics [1], 27, 40))::STRING as from_address,
CONCAT('0x', SUBSTR(topics [2], 27, 40))::STRING as to_address,
livequery.utils.udf_hex_to_int(SUBSTR(DATA, 3, 64)) as raw_amount_precise
FROM blast.core.fact_event_logs
WHERE topics[0]::STRING = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
AND data !='0x'
)
SELECT
token_address,
CASE
when token_address = '0x4300000000000000000000000000000000000004' then 'WETH'
when token_address = '0x9bd75c164daf830733ac2ea71a0258f95aac7c57' then 'BCat'
when token_address = '0x4300000000000000000000000000000000000003' then 'USDB'
when token_address = '0x63d758c3ad4c1bdf3279a3f8fea04471462952e1' then 'BOOST'
when token_address = '0x216a5a1135a9dab49fa9ad865e0f22fe22b5630a' then 'PUMP'
when token_address = '0x34050224f9ea1859790b7cbbbe2264f1204771a6' then 'BINU'
when token_address = '0xa43904ba981c92bc7100462f1d09fed8f8e6f5a5' then 'MIA'
when token_address = '0x7217124c626f0b7077be91df939195c9a8184ecc' then 'FINGER'
when token_address = '0x5fe8534a6f96cb01261bd96e98c17c2c1cab3204' then 'BAJA'
when token_address = '0xa4c7aa67189ec5623121c6c94ec757dfed932d4b' then 'Mia'
end as symbol,
count(DISTINCT TX_HASH) as n_transfer,
count(DISTINCT from_address) as n_senders,
count(DISTINCT to_address) as n_receivers
FROM transferTb
GROUP by 1,2
ORDER by 3 DESC
LIMIT 10
QueryRunArchived: QueryRun has been archived