2844wallet created DATE
Updated 2022-07-07
9
1
2
3
4
5
6
7
8
›
⌄
select count (distinct s.swapper) as swappers,DATE_TRUNC('MONTH',B.BLOCK_TIMESTAMP::DATE) AS DATE
from flipside_prod_db.algorand.account
inner join flipside_prod_db.algorand.swaps s on s.swapper=flipside_prod_db.algorand.account.ADDRESS
inner join flipside_prod_db.algorand.block B on B.block_id=flipside_prod_db.algorand.account.CREATED_AT
where S.block_timestamp>= '2022-05-01' and S.block_timestamp <'2022-07-01'
GROUP BY 2
ORDER BY 2
Run a query to Download Data