lanoKaiaswap DAU
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
30
31
32
33
34
›
⌄
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
date_trunc('day', tx.block_timestamp) as date,
count(distinct tx.from_address) as "DAU"
FROM
ks
LEFT JOIN kaia.core.fact_transactions tx ON ks.tx_hash = tx.tx_hash
where
tx.block_timestamp<CURRENT_DATE
group by 1
order by 1 asc
QueryRunArchived: QueryRun has been archived