boomer77unique users CHAI
Updated 2021-09-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with payments as
(SELECT
date_trunc('month', block_timestamp) as block_month,
count(distinct event_from) as Unique_users
FROM terra.transfers
WHERE (event_from_address_label = 'chai'
OR event_to_address_label = 'chai') and tx_status = 'SUCCEEDED' and event_amount is not null and event_amount_usd is not null and block_month between '2021-03-01' and '2021-08-01'
group by 1
order by 1 desc
)
select *
from payments
order by 1 desc
Run a query to Download Data