Pmisha-bmlMdxdex.1
Updated 2022-05-22
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select
date_trunc('day',block_timestamp) as dt,
SWAP_PROGRAM,
count(distinct SWAPPER) as no_users,
sum(no_users) over (partition by SWAP_PROGRAM order by dt) as cumulative_users,
count(TX_GROUP_ID) as usages_dex
from flipside_prod_db.algorand.swaps
where BLOCK_TIMESTAMP>='2022-04-01'
and SWAP_PROGRAM in ('tinyman','algofi','pactfi')
group by dt,SWAP_PROGRAM
Run a query to Download Data