SELECT DECODED_LOG:ticketId::string as "Ticket id", DECODED_LOG:amount/pow(10,18) as "Golds won", DECODED_LOG:winner as "Winner address",
tx_hash, block_timestamp as "Draw time"
from blast.core.ez_decoded_event_logs
where --tx_hash = '0x3570c70dad877bd8298bbdcd3d4fd2a4588d5a9a7201e810301aa38f418f1888'
EVENT_NAME = 'Winner'
and CONTRACT_ADDRESS = '0x9ad0e3ad90cae1e6acb1cc39cd82867f391b2478'
and ORIGIN_TO_ADDRESS = '0xfec1e33ebe899906ff63546868a26e1028700b0e'
and DECODED_LOG:prizeType = '0'
order by "Draw time" desc