benbendapper
Updated 2022-06-30
99
1
2
3
4
5
6
7
8
9
10
›
⌄
with account_creation as (
select * from flow.core.fact_events
where block_timestamp > '2022-06-01' -- can change as needed
and event_type = 'AccountCreated'
and event_data:address::string = '0xd869cc966489a1da' -- user enters their Dapper Wallet here
)
select * from flow.core.fact_transactions
where tx_id in (select tx_id from account_creation)
and proposer = '0x18eb4ee6b3c026d2' -- dapper labs address, do not exclude. Query will return 0 rows if account was created using another wallet, like Blocto
Run a query to Download Data