Ideal Airdrop Recipients

    Who is the ideal recipient for airdrops? To whom do I want to airdrop my tokens, so that they become loyal and active members of my project?"

    1,The ideal candidate is an address, that participated in previous airdrops and did one of the following:

    A, staked the tokens they received(possibly even bought more)

    B, held on to the token (did not sell)

    We can query recipients of previous airdrop events and identify (step1)

    (A by): the same address after the event (say in next two weeks) deposited at least half of the relevant token balance to a relevant pool address (more like 47% to account for conversion costs if we suppose they swapped first) (step2)

    (B by): addresses in (step1), but not in (step2) excluding addresses where the relevant balance did decrease by at least the airdropped amount (step3)

    2, An ideal candidate may also be identified as a 'resident' of Terra ie. an address where the net cumulative inflows-outflows with CEX-s and bridges is non-negative. (may or may not be the same as balance_usd change of the address )

    Steps: 1. Query CEXs and bridges.

    1. For each address calculate sum(event_amount) where event_to IN (step1)
    2. For each address calculate sum(event_amount) where event_from IN (step1)
    3. (3.)-(2.)=flow
    4. make list as sorting addresses by flow