CryptoIcicleFlow-19.Wallet Providers - Top 10
Updated 2022-07-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- Wallet Providers
-- Q19. Some wallet providers, like Blocto, subsidize the FLOW network fees for their users. As such, the payer for all of these transactions, as listed on the scanner and in our tables, is the wallet address 0x55ad22f01ef568a1.
-- Payout 47.468 FLOW
-- Grand Prize 142.41 FLOW
-- Level Intermediate
-- Q19. Some wallet providers, like Blocto, subsidize the FLOW network fees for their users.
-- As such, the payer for all of these transactions, as listed on the scanner and in our tables, is the wallet address 0x55ad22f01ef568a1.
-- Are other wallet providers doing something similar?
-- Can we determine what wallet provider an address is using from payer or any other transaction data?
with txns as (
select
payer,
count(distinct tx_id) as n_txns
from flow.core.fact_transactions
where 1=1
-- and payer = '0x55ad22f01ef568a1'
-- and proposer <> payer
group by payer
order by n_txns desc
limit 100
)
select
l.contract_name,
t.*
from txns t
left join flow.core.dim_contract_labels l on t.payer = l.account_address
-- where l.contract_name is null
order by n_txns desc
limit 10
Run a query to Download Data