drone-mostafaUNI tatal
Updated 2023-05-12
9
1
2
3
4
5
6
7
8
›
⌄
with base as (SELECT
ORIGIN_FROM_ADDRESS, min (BLOCK_TIMESTAMP) as BLOCK_TIMESTAMP
FROM ethereum.core.ez_dex_swaps WHERE PLATFORM LIKE '%uniswap%'
GROUP by 1)
SELECT
count (DISTINCT ORIGIN_FROM_ADDRESS) as New_Users
FROM base WHERE BLOCK_TIMESTAMP >= current_date -365
Run a query to Download Data