theericstoneanchor airdrop behavior after receiving
    Updated 2022-04-09
    -- 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
    -- Airdrops
    -- https://finder.extraterrestrial.money/columbus-5/address/terra146ahqn6d3qgdvmj8cj96hh03dzmeedhsf0kxqm -- ANC
    -- Select the Token to analyze from the list below
    -- ANC
    with token_to_analyze as (
    select
    'ANC' as token
    ),
    exchanges as (
    -- KuCoin - Deposits https://terra.engineer/en/terra_addresses/terra14l46jrdgdhaw4cejukx50ndp0hss95ekt2kfmw
    (
    select
    'terra14l46jrdgdhaw4cejukx50ndp0hss95ekt2kfmw' as exchange_address
    )
    union
    -- Binance - Deposits https://terra.engineer/en/terra_addresses/terra1ncjg4a59x2pgvqy9qjyqprlj8lrwshm0wleht5
    (
    select
    'terra1ncjg4a59x2pgvqy9qjyqprlj8lrwshm0wleht5' as exchange_address
    )
    ),
    -- This is a collection of relavant token details for each token that we use below
    token_details as (
    select
    'terra146ahqn6d3qgdvmj8cj96hh03dzmeedhsf0kxqm' as airdrop_contract,
    'terra1f32xyep306hhcxxxf7mlyh0ucggc00rm2s9da5' as staking_contract,
    'terra14z56l0fp2lsf86zy3hty2z47ezkhnthtr9yq76' as token_contract,
    -- ANC-UST Pairs
    Run a query to Download Data