MoeUser Behavior flow 1
    Updated 2022-06-19
    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