select ft.block_timestamp,

ft.tx_id,

ft.payer,

ft.proposer,

fe.event_type

-- case

-- when fe.event_type is like 'Tokens%' then fe.event_data:amount

-- end as amount,

-- case

-- when fe.event_type is like 'Fee%' then fe.event_data:amount

-- end as fee

from flow.core.fact_transactions ft

left join flow.core.fact_events fe

on ft.tx_id = fe.tx_id

where ft.payer <> ft.proposer

--and fe.event_type = 'AccountCreated'

--and fe.event_type = 'FeesDeducted'

and ft.tx_succeeded = TRUE

)

select *,

case payer

when '0x18eb4ee6b3c026d2' then 'TopShot Marketplace'

when '0xecfad18ba9582d4f' then 'Joyride'

when '0x55ad22f01ef568a1' then 'Blocto'

when '0x4bbff461fa8f6192' then 'Fantastec'

when '0x62b3063fbe672fc8' then 'Zeedz'

when '0xe2e1689b53e92a82' then 'Anique'

when '0xcf5785613ee3ba9d' then 'Mercury'

when '0x18eb4ee6b3c026d2' then 'DapperWallet'

when '0x33f75ff0b830dcec' then 'Lilico'

when '0x6f649aee955bef6d' then 'RCRDSHPNFT'

when '0x9b00972a3ecb364b' then 'Seussibles'

when '0xcaf376f596546f72' then 'NWayPlay Olympic Pin'

when '0x319e67f2ef9d937f' then 'FLOAT'