select --date_trunc('hour',BLOCK_TIMESTAMP) as hour

count(distinct FROM_ADDRESS) as purchasers

,count(distinct TX_HASH) as purchases

,sum(VALUE) as purchase_volume

,(sum(VALUE)/50) as ticket_amount

from ronin.core.fact_transactions

where TO_ADDRESS='0xbe21424c284654c8b4b1d1b11e732bd1e654b3c4'

and ORIGIN_FUNCTION_SIGNATURE='0xf1151e76'