I'm a graphql noob...

What's the best way to count all casts that contain "$DEGEN" and group by the hour?

I don't see any filters for text: https://docs.airstack.xyz/airstack-docs-and-faqs/api-references/api-reference/farcastercasts-api

will tip $DEGEN 🫡

🏗️ web3 builder  |  
👑 /degengame  |  
🔮 /topframes  |  
🩹 patchwallet.com  |  
🌐 nf.td/corbin

Hi @corbin.eth 👋  We do not currently have this particular data; GraphQL is just an API language fetching the data we have in the database. It does not support taking actions with the data - that has to be done on our side. We do have all casts.

Building a new way to consume blockchain data at Airstack.xyz. 

However, we will be adding text search for the casts, so it will be possible to fetch all the data with the timestamps soon.