Sbhn_NPgross-tan
Updated 2025-03-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select distinct concat('0x', right(topics[2],40)) as "Trader",
count(distinct tx_hash) as "Swaps",
sum(amount_usd) as "USD Volume",
count(distinct block_timestamp::date) as "Active Days"
from ink.core.fact_event_logs
join ink.core.ez_token_transfers a using(tx_hash)
where topic_0 = '0xd78ad95fa46c994b6551d0da85fc275fe613ce37657fb8d5e3d130840159d822'
and concat('0x', right(topics[1],40)) = '0xa8c1c38ff57428e5c3a34e0899be5cb385476507'
and a.contract_address = '0x4200000000000000000000000000000000000006'
and concat('0x', right(topics[2],40)) != '0xa8c1c38ff57428e5c3a34e0899be5cb385476507'
group by 1
order by 3 desc
limit 1000
QueryRunArchived: QueryRun has been archived