Jondar
@jondar
Joining Farcaster tables on Dune with all the "from" addresses who sent 120 usdc to the subscription address, looks like only 8,225 subs come from verified addresses. Is this possible? @dwr.eth @v @horsefacts.eth https://dune.com/queries/5206627/8565304
1 reply
0 recast
0 reaction
Konohime
@konohime.eth
Some paid with warps, so offchain :)
1 reply
0 recast
2 reactions
Jondar
@jondar
But this is counting all on chain transactions of addresses that sent 120 usdc to the farcaster subscription address. I then joined those addresses to the verified addresses from neynar's tables. Since there are more than 11500 addresses that bought on chain the subscription, at least those should be from verified addresses and then the number of total subscribers should be higher because of offchain subscriptions, or am i missing something?
1 reply
0 recast
0 reaction
Konohime
@konohime.eth
Mmh... Have you tried to join the Dan list with your query? Maybe you'll find who's missing this way https://farcaster.xyz/dwr.eth/0xc48efc17
1 reply
0 recast
0 reaction
Jondar
@jondar
yes, i have this query that returns the list of users that have paid the subscription with a verified address that also joins the dwr list to label who has also the nft. My theory is that 8,250 users paid with warplet and the rest 3,250 paid with warps as you said, but for each warps subscription the team made a transaction of 120 usdc to the subscription address with a new, non verified address. If someone from the team confirms this i can go on with my dashboard https://dune.com/queries/5207027
0 reply
0 recast
1 reaction
