CartanGroupsol dau
Updated 2024-07-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with txs as (
select block_timestamp, tx_to as address from solana.core.fact_transfers
where MINT='2b1kV6DkPAnxd5ixfnxCpjxmKwqjjaYmCZfHsFu24GXo'
and block_timestamp >= DATEADD('month', -6, CURRENT_DATE())
UNION
select block_timestamp, tx_from as address from solana.core.fact_transfers
where MINT='2b1kV6DkPAnxd5ixfnxCpjxmKwqjjaYmCZfHsFu24GXo'
and block_timestamp >= DATEADD('month', -6, CURRENT_DATE())
)
select
date_trunc('day', block_timestamp) AS date,
count(distinct address) as dau
from txs t
group by 1 order by 2 desc
QueryRunArchived: QueryRun has been archived