Moecompare fees
Updated 2022-06-29
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
28
29
30
31
32
33
34
35
36
›
⌄
with st as (select
tx_hash
from
ethereum.core.ez_eth_transfers
where --tx_hash = '0x9d992b215825406fd406c51ded0a91295dd5053527a815b72cf1f8c2e4c0e371'
ORIGIN_TO_ADDRESS = '0xae0ee0a63a2ce6baeeffe56e7714fb4efe48d419'
and ORIGIN_FUNCTION_SIGNATURE = '0xb6b55f25'
union all
select
tx_hash
from
ethereum.core.ez_eth_transfers
where --tx_hash = '0x230749362bcfc2ff5646d3c3de1906fc8e560a60931c2be222ed086003fceaf4'
eth_FROM_ADDRESS = '0xae0ee0a63a2ce6baeeffe56e7714fb4efe48d419'
and ORIGIN_FUNCTION_SIGNATURE = '0x00f714ce')
select
sum(tx_fee)/count (distinct tx_hash) as fee_per_tx_starwake,
(select
sum(tx_fee)/count(distinct tx_hash) as sushi_swap_fees
from ethereum.core.fact_transactions
WHERE
tx_hash in (select tx_hash from ethereum.sushi.ez_swaps where BLOCK_TIMESTAMP ilike '2022-01%' )
and tx_fee is not null
) as fee_per_tx_sushiswap
from ethereum.core.fact_transactions
where tx_hash in (select * from st)
Run a query to Download Data