freemartianAverage Amount Metamask
Updated 2022-06-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with meta as (
select count(distinct origin_from_address) as user_count, count(distinct tx_hash) as swap_count, sum(amount_in_usd) as volume
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')
)
select volume/swap_count as average_metamask
from meta
Run a query to Download Data