farcasterunion

Not integrated atm with my Dune Dashboard to audit your followers (will happen later), but I have a list with all casters who paid with USDC. 
- Interestingly enough, there are a lot of wallets that are not verified (warplets?)
- from at the moment 10.3k payments there are 5k with label 2, and 1.8k with label 0. The rest is no label or not linked to a FID atm

Need to find out if, and where, I can find the Warplets in the datasets.
You can find my list here: https://dune.com/queries/5198010

I have two additional columns in my Farcaster Followers Audit:
- fc_pro: if someone has a pro subscription. Far from perfect atm, but better than nothing.
- fc_pro_10k: fun part if:
   - an account is specially made to buy one of the first 10k pro subscriptions it will be marked with '🟥 1st 10k, farmer'. This is when your FID is higher than 1,089,899
   - if your  FID is below or equal to 1,089,899, and your spam label is 2 it will be marked '🟩 1st 10k, Pro OG'
   - if your  FID is below or equal to 1,089,899, and your spam label is 0 it will be marked '🟧 1st 10k, spammy'

Spam labels aren't static, by the way. The rest is.

I have two additional columns in my Farcaster Followers Audit:
- fc_pro: if someone has a pro subscription. Far from perfect atm, but better than nothing.
- fc_pro_10k: fun part if:
   - an account is specially made to buy one of the first 10k pro subscriptions it will be marked with '🟥 1st 10k, farmer'. This is when your FID is higher than 1,089,899
   - if your  FID is below or equal to 1,089,899, and your spam label is 2 it will be marked '🟩 1st 10k, Pro OG'
   - if your  FID is below or equal to 1,089,899, and your spam label is 0 it will be marked '🟧 1st 10k, spammy'

Spam labels aren't static, by the way. The rest is. 
https://dune.com/nhejyht/farcaster-followers-audit

Interests: crypto, economics, TA & blockchain related innovations | 🔗 https://linktr.ee/cryptonjal 🔗 https://dune.com/nhejyht

I think especially that red square is an interesting one. 

Probably need to get a better understanding of how to operate Dune.

A teller / of stories, that is me. / Curious to learn new ways to see. / Proud dad of two. Now, what / about you? | Builds https://paragraph.xyz/@trpplffct

Just vibing. With Claude.ai and some patience to fix errors it's doable.
Mostly the same errors, and copy-paste errors into Claude will also help.