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

Technowatermelon. Elder Millenial. Building Farcaster. 

nf.td/varun

I work at the posts office

terminally.online

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

Data Analyst | Co-founder of https://www.brianknows.org/ | Dune: https://dune.com/jondar

Prev : NonFungible | NFT18. Analysing NFT market & Drawing vectors. Host /dataviz 
konohime.xyz

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?

Farcaster Devs

Farcaster Pro initial 10K list

A reminder this will be onchain and in the protocol in a couple weeks. 

But for now, here's the official list of 10,000 FIDs, in order of when they subscribed, that qualified for the NFT. Should be helpful for anyone who wants to do data analysis.

https://docs.google.com/spreadsheets/d/1hi8BnReWA9iIiuOcyQbzdRxKbRY0tNYuNdE2JgH4s3o/edit?gid=129247491#gid=129247491

Mmh... Have you tried to join the Dan list with your query? Maybe you'll find who's missing this way

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

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

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