select distinct(tx_hash), ORIGIN_FROM_ADDRESS

from ethereum.core.fact_event_logs

where CONTRACT_ADDRESS = lower('0x881D40237659C251811CEC9c364ef91dC08D300C')

and ORIGIN_TO_ADDRESS = lower('0x881D40237659C251811CEC9c364ef91dC08D300C')

and TX_STATUS = 'SUCCESS'

and BLOCK_TIMESTAMP >= '2022-01-01'

),

metamask_swap as (

select *

from ethereum.core.ez_token_transfers e join metamask_tx t on e.TX_HASH = t.TX_HASH and e.to_address = t.ORIGIN_FROM_ADDRESS

where HAS_DECIMAL = True

and HAS_PRICE = True

and --e.TX_HASH not in ('0x3f95844988ba98d4bf008a516ffa088f9ec4b5419da92f3ba24d2fef0c04b2c2', '0x3f95844988ba98d4bf008a516ffa088f9ec4b5419da92f3ba24d2fef0c04b2c2','0xd99f180df7f3dbb2070dedcdb51e8700e8eacc862229f18189cf2305f0689e40')

SYMBOL not in ('$WEAPON', 'VOLT')

),

metamask as (

select BLOCK_TIMESTAMP::date as date,

'Metamask' as Platforms,

count(distinct to_address) as number_of_users,

sum(AMOUNT_USD) as swap_volume,

swap_volume/number_of_users as Average_amount_swapped

from metamask_swap

group by date

),

sushiswap as (

select BLOCK_TIMESTAMP::date as date,

'Sushiswap' as Platforms,

count(distinct ORIGIN_FROM_ADDRESS) as number_of_users,

sum(AMOUNT_IN_USD) as swap_volume,

swap_volume/number_of_users as Average_amount_swapped

from ethereum.core.ez_dex_swaps

where EVENT_NAME = 'Swap'

and PLATFORM = 'sushiswap'

and BLOCK_TIMESTAMP::date >= '2022-01-01'

group by date