0xaimanTransaction Fees Paid by Metamask Users
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
24
25
26
27
›
⌄
select * from (with swapsx as (with
-- '0x881d40237659c251811cec9c364ef91dc08d300c')
mm as (select distinct from_address from ethereum.core.fact_transactions where to_address=lower('0x881d40237659c251811cec9c364ef91dc08d300c') ),
txn as (select block_timestamp, mm.from_address,tx_fee, tx_hash, to_address from ethereum.core.fact_transactions as ft inner join mm on mm.from_address=ft.from_address where status='SUCCESS')
select from_address,block_timestamp, tx_hash,tx_fee, ADDRESS, ADDRESS_NAME, LABEL_TYPE, LABEL from ethereum.core.dim_labels as l inner join txn on txn.to_address=l.address
where label_type='dex')
select label, min(tx_fee)/10e17 as min_tx_fee_non_adjusted, max(tx_fee) as max_tx_fee , avg(tx_fee) as avg_tx_fee
from swapsx
where label='uniswap' or
label='metamask' or
label ='sushiswap' or
label ='1inch' or
label='0x'
group by 1
)
Run a query to Download Data