CarlOwOs(2.O) Swaps - Daily Users
Updated 2022-10-14Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT DATE_TRUNC('DAY', block_timestamp) AS date
, 'Uniswap' AS platform
, 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, 2
UNION ALL
SELECT DATE_TRUNC('DAY', block_timestamp) AS date
, 'Sushiswap' AS platform
, COUNT(DISTINCT origin_from_address) AS users
FROM optimism.sushi.ez_swaps
WHERE DATEDIFF('DAY', block_timestamp, CURRENT_DATE) <= 90
GROUP BY 1, 2
Run a query to Download Data