kiichiUntitled Query
Updated 2022-07-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with tab1 as (
SELECT
a.swapper as users,
b.created_at as created_at
from flipside_prod_db.algorand.swaps a left join flipside_prod_db.algorand.account b
on a.swapper=b.address
where a.block_timestamp BETWEEN '2022-05-1' and '2022-06-30'),
tab2 as (
SELECT
block_id,
block_timestamp
from flipside_prod_db.algorand.block )
SELECT
count(DISTINCT f.users) as wallets,
date_trunc(month,g.block_timestamp) as date
from tab1 f left join tab2 g
on f.created_at=g.block_id
group by date
Run a query to Download Data