SELECT DISTINCT tx_hash

-- count(DISTINCT ORIGIN_FROM_ADDRESS)

FROM ethereum.core.fact_event_logs

WHERE contract_address LIKE lower('0x881D40237659C251811CEC9c364ef91dC08D300C')

SELECT

date_trunc('day', block_timestamp) as day,

sum(amount_usd) as volume,

count(DISTINCT origin_from_address) as users ,

avg(AMOUNT_USD) avg_swap_volume

FROM ethereum.core.ez_token_transfers

WHERE tx_hash IN (SELECT * from tab1)

AND amount_usd < 1000000000

GROUP BY 1