abcfy27D-DAU
Updated 2024-10-14
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
-- forked from 7D-daily-transactions @ https://flipsidecrypto.xyz/edit/queries/f799e014-0359-44f8-8283-35cab8cb94f6
select
LEFT(INSERTED_TIMESTAMP, 10) as day,
count(DISTINCT FROM_ADDRESS) as dau
from
kaia.core.fact_transactions
where
TO_ADDRESS = LOWER('0x13585Dc6268B0B5424d47aF4f63D8A50D6F56CF8')
and TX_SUCCEEDED
group by
1
QueryRunArchived: QueryRun has been archived