with all_tx as (

select

date_trunc('day', block_timestamp::date) as dt,

tx_hash,

TO_ADDRESS as event_to,

FROM_ADDRESS as event_from,

AMOUNT_PRECISE as amounts

from ronin.core.ez_token_transfers

where block_timestamp > '2025-01-15'

and contract_address = lower('0x361d8623dc1d91e04ebc148687719aace282249a')),

transfers as

((SELECT

event_to as wallet,

dt,

'mint' as action,

amounts as value

FROM all_tx

where event_from = '0x0000000000000000000000000000000000000000')

union all

(SELECT

event_to as wallet,

dt,

'gain' as action,

amounts as value

FROM all_tx

where event_from != '0x0000000000000000000000000000000000000000')

union all

(SELECT

event_from as wallet,