select

*

from Polygon.core.fact_event_logs

where ORIGIN_TO_ADDRESS='0xf715beb51ec8f63317d66f491e37e7bb048fcc2d' and ORIGIN_FUNCTION_SIGNATURE='0xbbbfa60c'

and EVENT_INPUTS:to='0x5b3256965e7c3cf26e11fcaf296dfc8807c01073'

select

distinct EVENT_INPUTS:from::string as unique_purchasers,

sum(EVENT_INPUTS:value/1e18)*0.25 as paid_fee

from Polygon.core.fact_event_logs

where ORIGIN_TO_ADDRESS='0xf715beb51ec8f63317d66f491e37e7bb048fcc2d' and ORIGIN_FUNCTION_SIGNATURE='0xbbbfa60c'

and EVENT_INPUTS:to='0xf715beb51ec8f63317d66f491e37e7bb048fcc2d' and CONTRACT_ADDRESS='0x7ceb23fd6bc0add59e62ac25578270cff1b9f619'

and tx_hash in (select tx_hash from tb1)

group by 1 order by 2 desc

limit 10