Moetera cont 4
Updated 2022-12-21Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
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