adambalanumber of active wallets per week
Updated 2021-11-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
SELECT
date_trunc('week',block_timestamp) as date,
count(tx_id) as tx_number
from ethereum.dex_swaps where platform in ('sushiswap')
and block_timestamp >=getdate() - interval '48 weeks'
AND block_timestamp::date > current_date-365
group by date
UNION
SELECT
date_trunc('week',block_timestamp) as date,
count(tx_id) as tx_number
from ethereum.dex_swaps where platform in ('uniswap-v2','uniswap-v3')
and block_timestamp >=getdate() - interval '48 weeks'
AND block_timestamp::date > current_date-365
group by date
order by date , tx_number
Run a query to Download Data