whereblock_timestamp>'2022-11-11'-- can change as needed
andevent_type='AccountCreated'
andevent_data:address::string='0x07107a845d6627ee'-- user enters their Dapper Wallet here
)
select*
fromflow.core.fact_transactions
wheretx_idin(selecttx_idfromaccount_creation)
andproposer='0x18eb4ee6b3c026d2'-- dapper labs address, do not exclude. Query will return 0 rows if account was created using another wallet, like Blocto