2024 began, and I haven't stopped. Last month, I finished an airdrop project for ZKX, a perpetual exchange protocol based on Starknet Foundation. It was an interesting and challenging project because the criteria for selecting eligible addresses were sophisticated.
For this project, I used SQL-based data providers for dealing with blockchain data, such as Dune, Flipside, and Transpose. I also used Python and API integration to retrieve and prepare data from different sources. For this selection, we considered:
📈 Perpetual Protocols: High volume and active traders in famous perpetual exchanges like dYdX, Synthetix, GMX, Vertex, GNS, etc., from multiple chains.
🎨 NFT community: NFT holders for some collections.
🐳 Whales: Liquidity providers in Stake protocols like Lido and Rocket Pool.
👨🏻⚖️ DAO governance participants of certain protocols and projects.
Thank you, ZKX, for trusting me with this challenging and important task. Many thanks to Flipside and its feature Live-query, which allowed me to integrate different on-chain data sources into Flipside Studio to perform advanced data manipulation and exclude contracts from multiple blockchains.
If you want to know more about the airdrop eligibility criteria, access this article: ZKX Airdrop Eligibility Criteria