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

date_trunc('hour', block_timestamp) as hour,

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,

sum(purchase_volume_usd) over (ORDER by hour) as total_purchase_volume_usd,

300000000 - total_purchase_volume_usd as unpurchased_presale

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'

group by 1