Flipside TeamFS near report - top projects daus and txs daily
Updated 2024-07-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select date_trunc(day, BLOCK_TIMESTAMP) as "Date",
case
when receiver ilike 'linear-protocol.near' then 'Linear'
when receiver ilike 'contract.main.burrow.near' then 'Burrow'
when receiver ilike 'meta-pool.near' then 'Meta Pool' end as "Platform",
count(*) as "TXs",
count(distinct case
when tx:actions[0]:Delegate is not null then tx:actions[0]:Delegate:delegate_action:sender_id::string
else TX_SIGNER end) as "DAUs"
from (select *, ifnull(tx:actions[0]:Delegate:delegate_action:receiver_id::string, TX_RECEIVER) as receiver
from near.core.fact_transactions
where TX_SUCCEEDED=true
and BLOCK_TIMESTAMP::date>='2024-01-01'
and receiver in ('contract.main.burrow.near','meta-pool.near','linear-protocol.near')) a
group by 1,2
QueryRunArchived: QueryRun has been archived