CarlOwOs(0.O) Swaps - total users, swaps
Updated 2022-10-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
SELECT 'Uniswap' AS platform
, COUNT(*) AS swaps
, COUNT(DISTINCT from_address) AS users
FROM optimism.core.fact_transactions
WHERE (to_address ilike '0xE592427A0AEce92De3Edee1F18E0157C05861564'
OR to_address ilike '0x68b3465833fb72A70ecDF485E0e4C7bD8665Fc45')
AND DATEDIFF('DAY', block_timestamp, CURRENT_DATE) <= 90
AND status = 'SUCCESS'
GROUP BY 1
UNION ALL
SELECT 'Sushiswap' AS platform
, COUNT(*) AS swaps
, COUNT(DISTINCT origin_from_address) AS users
FROM optimism.sushi.ez_swaps
WHERE DATEDIFF('DAY', block_timestamp, CURRENT_DATE) <= 90
GROUP BY 1
Run a query to Download Data