Token | Traders | Trading Volume | |
---|---|---|---|
1 | BECK | 753 | 4855361763.59914 |
2 | CHAD | 333 | 4554250720.51031 |
3 | BabyKraken | 325 | 3128380954.81981 |
4 | AK47 | 275 | 1254534299.62566 |
5 | WAGMI | 198 | 1285621858.00567 |
6 | INKR | 156 | 1764745357.83218 |
7 | FEZ | 152 | 3159801284.08073 |
8 | MILADY | 138 | 2249333542.59512 |
9 | MYST | 128 | 1148296403.37319 |
10 | RCN | 109 | 953238291.623838 |
11 | INKU | 107 | 3192212418.9713 |
12 | PIN | 101 | 2264929738.35115 |
13 | KRET | 100 | 1881634773.73229 |
14 | INKDOG | 98 | 1344174230.35216 |
15 | H1N1 | 96 | 9393294.53945077 |
16 | SQWARD | 91 | 1086645702.44329 |
17 | POKE | 86 | 2249261250.18902 |
18 | SEX | 86 | 993978716.71277 |
19 | $HANK | 84 | 1838038276.9852 |
20 | Arch | 79 | 1188172946.10959 |
Sbhn_NPprinted-aquamarine
Updated 2025-03-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
symbol as "Token",
count(distinct origin_from_address) as "Traders",
sum(ethereum.public.udf_hex_to_int(regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}')[5]) / pow(10,18)) as "Trading Volume"
from ink.core.fact_event_logs
join ink.core.ez_token_transfers using(tx_hash)
where topic_0 in ('0x4b5824a0f21039d7160b2a57d8c140cae3ba13e4f15bcd879cc63e4964681a9e','0x0d29d7b2727600087ca17290038d4c09dc340440df666c931e739ad49594669e')
and origin_to_address = '0x1d74317d760f2c72a94386f50e8d10f2c902b899'
and concat('0x', right(regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}')[4],40)) != '0x1d74317d760f2c72a94386f50e8d10f2c902b899'
and amount>0
group by 1
order by 2 desc
Last run: about 1 month ago
...
271
8KB
11s