banbannardUntitled Query
Updated 2022-11-06
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
›
⌄
with base as (select min(a.block_timestamp) as first_tx,
case
when payer = '0x55ad22f01ef568a1' then 'Blocto'
when payer = '0x93615d25d14fa337' then 'ChainMonsters'
when payer = '0x18eb4ee6b3c026d2' then 'Dapper Wallet (Used by NBA TopShot)'
when payer = '0xecfad18ba9582d4f' then 'JoyRide'
when payer = '0x39e42c67cc851cfb' then 'Lilico'
else null
end as wallet_provider,
proposer
from flow.core.fact_events a
join flow.core.fact_transactions b
on a.tx_id = b.tx_id
where wallet_provider is not null
and a.tx_succeeded = 'TRUE'
and event_type = 'TokensWithdrawn'
group by 2,3),
base2 as (select wallet_provider,
count(distinct(proposer)) as nft_users
from base a
join flow.core.ez_nft_sales b
on a.proposer = b.buyer
where tx_succeeded = 'TRUE'
group by 1),
base3 as (select wallet_provider,
count(distinct(proposer)) as total_users
from base
group by 1),
base4 as (select b.wallet_provider,
nft_users,
total_users,
total_users - nft_users as non_nft_wallets
from base2 a
Run a query to Download Data