select ft.block_timestamp,

ft.tx_id,

ft.payer,

fe.event_type,

fe.event_data:amount 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 r.block_timestamp::date as fecha,

r.payer,

case r.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'

when '0x1b65c33d7a352c61' then 'FanCraze'

when '0x38c0aa1b1eaa65cc' then 'EnemyMetal'

when '0x9e06eebf494e2d78' then 'Unknown'

else r.payer

end as payer_id,