theericstoneanchor airdrop behavior after receiving
Updated 2022-04-09
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- 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