Hadisehmeta vs other
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
›
⌄
with metamask as ( select tx_hash
from ethereum.core.fact_event_logs
where ORIGIN_TO_ADDRESS = lower('0x881d40237659c251811cec9c364ef91dc08d300c')
and EVENT_INPUTS:from = ORIGIN_FROM_ADDRESS)
,
sushi as ( select tx_hash
from ethereum.core.ez_dex_swaps
where platform = 'sushiswap' )
,
uni as ( select tx_hash
from ethereum.core.ez_dex_swaps
where platform = 'uniswap-v2' )
select 'sushi' as platform , date(BLOCK_TIMESTAMP) as date , sum(tx_fee) as total_fee , avg(tx_fee) as avg_fee
from ethereum.core.fact_transactions
where tx_hash in ( select tx_hash from sushi)
group by 1,2
UNION
select 'sushi' as platform , date(BLOCK_TIMESTAMP) as date , sum(tx_fee) as total_fee , avg(tx_fee) as avg_fee
from ethereum.core.fact_transactions
where tx_hash in ( select tx_hash from uni)
group by 1,2
UNION
select 'sushi' as platform , date(BLOCK_TIMESTAMP) as date , sum(tx_fee) as total_fee , avg(tx_fee) as avg_fee
from ethereum.core.fact_transactions
where tx_hash in ( select tx_hash from metamask)
group by 1,2
Run a query to Download Data