ORIGIN_FROM_ADDRESS AS user,

sum(EVENT_INPUTS:value/1e18) AS Amount

from ethereum.core.fact_event_logs

CONTRACT_ADDRESS='0xb3999f658c0391d94a37f7ff328f3fec942bcadc' and EVENT_NAME='Transfer' and EVENT_INPUTS:from='0x1a9a4d919943340b7e855e310489e16155f4ed29' and ORIGIN_FUNCTION_SIGNATURE='0xeb4d6138'

group by 1),

tb2 AS (

select

date_trunc('HOUR',BLOCK_TIMESTAMP) AS HOUR,

count(distinct ORIGIN_FROM_ADDRESS) AS "sellers number"

from ethereum.core.ez_dex_swaps inner join tb1 on ORIGIN_FROM_ADDRESS=User

where TOKEN_OUT=lower('0xb3999F658C0391d94A37f7FF328F3feC942BcADC') group by 1

union ALL

select

date_trunc('HOUR',BLOCK_TIMESTAMP) AS HOUR,

count(distinct ORIGIN_FROM_ADDRESS) AS "sellers number"

from ethereum.core.ez_token_transfers A inner join tb1 B on ORIGIN_FROM_ADDRESS=User

where CONTRACT_ADDRESS=lower('0xb3999F658C0391d94A37f7FF328F3feC942BcADC') group by 1

select HOUR,sum("sellers number") AS "sellers number"

from tb2

group by 1