Crazy_KidNew Active Users
Updated 2022-05-09
9
1
2
3
4
5
6
7
8
9
›
⌄
WITH dataset AS (SELECT DISTINCT from_address as wallets, min(block_timestamp) as block_timestamp
FROM ethereum.udm_events
WHERE to_label='paraswap' AND date(block_timestamp) BETWEEN '2022-03-01' and '2022-04-30' AND from_label_type IS NULL
GROUP BY from_address)
SELECT date(block_timestamp) as date, COUNT(wallets) as no_of_new_wallets
FROM dataset
GROUP BY date
ORDER BY date
Run a query to Download Data