Airdrop Actions
tl; dr We'd like a percentage breakdown of what addresses are doing with their airdropped tokens within 90 days after receiving them, to help understand what addresses are the best candidates for airdrops. ------ The Ask: For each token airdrop - LUNA, ANC, MINE, MIR, PSI, LOOP, and STT airdrops - provide a percentage breakdown of the actions taken, by address, within 90 days of receiving the airdrop. We’d like the breakdown to cover the following actions: -Held -Subsequently purchased more of the airdropped token -Transferred -Staked -Swapped Details: We’re looking for science, not presentation magic. Specifically: our data science team would love to turbocharge the airdrops analytics we’re putting together to identify addresses that are prime candidates for Airdropz. So - we’re placing a premium on clean, organized, well-commented SQL. No need to spend time on flair or snazzy presentation - the goal is to create solid SQL building blocks rather than beautiful facades