freemartianSwap Count
Updated 2022-06-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
select count(distinct tx_hash) as swap_count, 'UniSwap' as label
from ethereum.core.ez_dex_swaps
where platform = 'uniswap-v2'
and origin_from_address not in (
select distinct origin_from_address as MetaMask_Swappers
from ethereum.core.fact_event_logs
where origin_to_address = '0x881d40237659c251811cec9c364ef91dc08d300c')
UNION
select count(distinct tx_hash) as swap_count, 'SushiSwap' as label
from ethereum.core.ez_dex_swaps
where platform = 'sushiswap'
and origin_from_address not in (
select distinct origin_from_address as MetaMask_Swappers
from ethereum.core.fact_event_logs
where origin_to_address = '0x881d40237659c251811cec9c364ef91dc08d300c')
UNION
select count(distinct tx_hash) as swap_count, 'MetaMask' as label
from ethereum.core.ez_dex_swaps
where origin_from_address in (
select distinct origin_from_address as MetaMask_Swappers
from ethereum.core.fact_event_logs
where origin_to_address = '0x881d40237659c251811cec9c364ef91dc08d300c')
Run a query to Download Data