MoeUser Behavior flow 1
Updated 2022-06-19Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
date_trunc(day,BLOCK_TIMESTAMP)::date as days,
CONTRACT_NAME,
count(distinct TX_ID) as num_interaction,
sum(num_interaction)over(partition by CONTRACT_NAME order by days rows between unbounded preceding and current row) as num_interaction_growth
from flow.core.dim_contract_labels l , flow.core.fact_events s
where BLOCK_TIMESTAMP >= '2022-01-01'
and l.EVENT_CONTRACT = s.EVENT_CONTRACT
and s.EVENT_CONTRACT != 'A.f919ee77447b7497.FlowFees'
and CONTRACT_NAME != 'FlowToken'
group by 1,2 order by 1
Run a query to Download Data