select

block_timestamp,

event_inputs:_to as minter

from polygon.core.fact_event_logs

where origin_function_signature in ('0x5a86c41a', '0x669f5a51')

and event_inputs:_from = '0x0000000000000000000000000000000000000000'

and event_name = 'TransferSingle'

and tx_status = 'SUCCESS'

and block_timestamp > '2022-07-01'),

next_transactions as (

distinct tx_hash as tx,

l.block_timestamp,

origin_from_address,

origin_to_address,

contract_address,

event_inputs,

event_name

from polygon.core.fact_event_logs l

inner join minters m on origin_from_address = minter

where l.block_timestamp > m.block_timestamp

and l.block_timestamp > '2022-07-01')

select

event_name,

contract_address,

address_name,

project_name,

origin_to_address,

count(tx) as interaction

from next_transactions t inner join polygon.core.dim_labels on (origin_to_address = address)

where event_name not in ('Approval', 'ApprovalForAll')

group by 1, 2, 3, 4, 5

order by interaction DESC