from bsc.core.fact_event_logs

where EVENT_NAME='Transfer'

and CONTRACT_ADDRESS='0xa4838122c683f732289805fc3c207febd55babdd'

and TX_STATUS='SUCCESS'

and (EVENT_INPUTS:to=ORIGIN_FROM_ADDRESS or EVENT_INPUTS:from=ORIGIN_FROM_ADDRESS )

and TX_HASH in ( select TX_HASH as hash from bsc.core.fact_event_logs where EVENT_NAME='Swap')

and block_timestamp>=CURRENT_DATE-1

limit 1