lanoKaiaswap UAW
Updated 2024-11-06
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
›
⌄
with ks as
(
select distinct tx_hash
from kaia.core.fact_traces
where to_address IN (
'0xd37243e3ee3064046380c57e1073cde53761369a',
'0x050bb0533a273b509ec502d5bf47dbb07d44c5bc',
'0x4037ce3f802336b0682a821378b7b1e0ff52737b',
'0xe833e5e3a52839ff2a167eb5f3077f254d9d63e9',
'0x5ff11b24e98c8faba612f79d5c2d6cd64407bec3'
) OR from_address IN (
'0xd37243e3ee3064046380c57e1073cde53761369a',
'0x050bb0533a273b509ec502d5bf47dbb07d44c5bc',
'0x4037ce3f802336b0682a821378b7b1e0ff52737b',
'0xe833e5e3a52839ff2a167eb5f3077f254d9d63e9',
'0x5ff11b24e98c8faba612f79d5c2d6cd64407bec3'
)
)
SELECT
count(distinct tx.from_address) as "UAW"
FROM
ks
LEFT JOIN kaia.core.fact_transactions tx ON ks.tx_hash = tx.tx_hash
QueryRunArchived: QueryRun has been archived