pimi1356-HdnUm3Average fee
Updated 2022-06-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
SELECT date_trunc('day', block_timestamp) as date,
'Metamask' as platform,
avg(TX_FEE) as Fee
from ethereum.transactions
where (TO_ADDRESS='0x881d40237659c251811cec9c364ef91dc08d300c')
and block_timestamp >= '2021-01-01'
and TX_FEE<=0.10
GROUP by date
UNION
SELECT date_trunc('day', block_timestamp) as date,
'Other_platforms',
avg (tx_fee)
from ethereum.transactions
where (to_label LIKE 'uniswap%' or
to_label='sushiswap')
and block_timestamp >= '2021-01-01'
and TX_FEE<=0.10
GROUP by date
Run a query to Download Data