select t.block_timestamp

,t.tx_id

,t.authorizers

,t.count_authorizers

,t.payer

,t.proposer

,e.event_data

,e.event_data:amount as fee

from flow.core.fact_transactions t

left join flow.core.fact_events e

on t.tx_id = e.tx_id

where e.event_type = 'AccountCreated' and e.tx_succeeded = TRUE and t.payer <> t.proposer

select block_timestamp::date as fecha

,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'

else payer

end as payer_id

,count (tx_id) as daily_txs

,sum (fee) as daily_fees

,sum (daily_txs) over (partition by payer_id order by fecha RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) as acc_txs

,sum (daily_fees) over (partition by payer_id order by fecha RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) as acc_fees