ShaylinsrrUntitled Query
Updated 2022-06-25Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT 'Metamask' as platform, COUNT(DISTINCT ORIGIN_FROM_ADDRESS)::string as "Number of Users"
from ethereum.core.ez_token_transfers
where ORIGIN_TO_ADDRESS='0x881d40237659c251811cec9c364ef91dc08d300c'
AND block_timestamp >= '2022-01-01'
UNION All (
SELECT 'Uniswap-v3' as platform, COUNT(DISTINCT ORIGIN_FROM_ADDRESS)::string as "Number of Users"
from ethereum.core.ez_token_transfers
where ORIGIN_TO_ADDRESS= lower('0x68b3465833fb72A70ecDF485E0e4C7bD8665Fc45')
AND block_timestamp >= '2022-01-01')
UNION All (
SELECT 'Sushiswap' as platform, COUNT(DISTINCT ORIGIN_FROM_ADDRESS)::string as "Number of Users"
from ethereum.core.ez_token_transfers
where ORIGIN_TO_ADDRESS='0xd9e1cE17f2641f24aE83637ab66a2cca9C378B9F'
AND block_timestamp >= '2022-01-01')
Run a query to Download Data