with tab1 as (

SELECT

tx_hash

FROM ethereum.core.fact_event_logs

where contract_address LIKE lower('0xe217E15b3C19cC0427F9492dC3bcfe8220aFAD10')

AND origin_function_signature like '0xf496a610'

AND block_timestamp > '2024-10-10'

SELECT

sum(raw_amount / power(10,18)) * 0.015 as purchase_volume_usd,

count(DISTINCT tx_hash) as events,

count(DISTINCT origin_from_address) as buyers

FROM ethereum.core.fact_token_transfers

where tx_hash in (SELECT * from tab1)

AND contract_address LIKE lower('0xdA5e1988097297dCdc1f90D4dFE7909e847CBeF6')

AND block_timestamp > '2024-10-10'