jackguyUniswap V3 vs QuickSwap vs SushiSwap 7
Updated 2022-01-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH tab12 as (
SELECT *
FROM (VALUES
(lower('0x167384319B41F7094e62f7506409Eb38079AbfF8'), 'WMATIC / WETH'),
(lower('0xb2F8Ba544E4874D4E0F817359D0F4bcff209b87E'), 'USDC / XSGD'),
(lower('0x50eaEDB835021E4A108B7290636d62E9765cc6d7'), 'WBTC / WETH'),
(lower('0x1DccB1Aa49D10d489D774440116d4d5ABe7F4E56'), 'GFC / WETH'),
(lower('0x88f3C15523544835fF6c738DDb30995339AD57d6'), 'MATIC / USDC'),
(lower('0x0e44cEb592AcFC5D3F09D996302eB4C499ff8c10'), 'USDC / WETH'),
(lower('0x6e53cb6942e518376e9e763554db1a45ddcd25c4'), 'USDC / SWYF'),
(lower('0x45dDa9cb7c25131DF268515131f647d726f50608'), 'USDC / WETH 2'),
(lower('0x3F5228d0e7D75467366be7De2c31D0d098bA2C23'), 'USDC / USDT'),
(lower('0x5f69C2ec01c22843f8273838d570243fd1963014'), 'USDC / DAI')
) t1 (address, address_name)
), tab22 as (
SELECT
from_address,
min(date_trunc('day', block_timestamp)) as md
FROM polygon.udm_events LEFT outer join tab12 on address = to_address
WHERE to_address IN (SELECT address from tab12)
-- AND (ORIGIN_FUNCTION_NAME LIKE '%swap%' or ORIGIN_FUNCTION_NAME LIKE '%Swap%')
-- AND address_name in (SELECT a1 from tab101)
GROUP by 1
), tab3 as (
SELECT
md,
count(*) as amt
from tab22
GROUP by 1
)
SELECT
md,
amt as new_users,
SUM (amt) OVER (ORDER BY md) as total_users
FROM tab3
Run a query to Download Data