Moetera cont 4
    Updated 2022-12-21

    select
    date_trunc(month,block_timestamp)::date as month ,
    project_name,
    count(distinct tx_id) as txns,
    count(distinct tx_sender) as wallets,
    row_number()over(partition by month order by wallets desc) as rn

    from
    terra.core.dim_address_labels l, terra.core.fact_transactions t
    where address=tx:body:messages[0]:contract
    group by 1,2 qualify rn <= 5

    Run a query to Download Data