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

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

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?