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

tx_hash, event_inputs:to::string as event_to,

event_inputs:from::string as event_from, event_inputs:tokenId::string as token_id

from ethereum.core.fact_event_logs

where contract_address = lower('0x7EA3Cca10668B8346aeC0bf1844A49e995527c8B')

and event_name = 'Transfer'

and block_timestamp > '2021-03-05'

),

transfers as

((SELECT

event_to as wallet,

dt,

'mint' as action,

1 as value

FROM all_tx

where event_from = '0x0000000000000000000000000000000000000000')

union all

(SELECT

event_to as wallet,

dt,

'gain' as action,

1 as value

FROM all_tx

where event_from != '0x0000000000000000000000000000000000000000')

union all

(SELECT

event_from as wallet,

dt,

'lose' as action,

-1 as value