with anc_claim as (select block_timestamp as ClaimDate, tx_id as claim_tx, sender from anchor.reward_claims where claim_0_amount = 0 AND claim_1_amount > 0 ), anc_swap as (select block_timestamp as SwapDate, tx_id as swap_tx, msg_value:sender as sender, (msg_value:execute_msg:send:amount) / POW(10,6) as swap_amount from terra.msgs where msg_value:execute_msg:send:contract = 'terra1gm5p3ner9x9xpwugn9sp6gvhd0lwrtkyrecdn3' and msg_value:sender in (select sender from anc_claim) ), tx_n_dt as (select s.sender as wallets, ClaimDate, claim_tx, SwapDate, swap_tx from anc_swap s left join anc_claim c ON s.sender = c.sender group by 1, 2, 3, 4, 5 ), sold_cr as (select year(ClaimDate) as yearz, month(ClaimDate) as monthz, count(distinct wallets) as wallets from tx_n_dt where ClaimDate >= '2021-09-01' and ClaimDATE <= '2021-09-30' AND DATEDIFF(dd, SwapDate, ClaimDate) <= 7 group by 1, 2 union ALL select year(ClaimDate) as yearz, month(ClaimDate) as monthz, count(distinct wallets) as wallets from tx_n_dt where ClaimDate >= '2021-10-01' and ClaimDATE <= '2021-10-31' AND DATEDIFF(dd, SwapDate, ClaimDate) <= 7 group by 1, 2 union ALL select year(ClaimDate) as yearz, month(ClaimDate) as monthz, count(distinct wallets) as wallets from tx_n_dt where ClaimDate >= '2021-11-01' and ClaimDATE <= '2021-11-30' AND DATEDIFF(dd, SwapDate, ClaimDate) <= 7 group by 1, 2 union ALL select year(ClaimDate) as yearz, month(ClaimDate) as monthz, count(distinct wallets) as wallets from tx_n_dt where ClaimDate >= '2021-12-01' and ClaimDATE <= '2021-12-31' AND DATEDIFF(dd, SwapDate, ClaimDate) <= 7 group by 1, 2 union ALL select year(ClaimDate) as yearz, month(ClaimDate) as monthz, count(distinct wallets) as wallets from tx_n_dt where ClaimDate >= '2022-01-01' and ClaimDATE <= '2022-01-31' AND DATEDIFF(dd, SwapDate, ClaimDate) <= 7 group by 1, 2 ), claim_cl as (select year(ClaimDate) as yearz, month(ClaimDate) as monthz, count(distinct sender) as claimers from anc_claim where ClaimDate >= '2021-09-01' and ClaimDATE <= '2021-09-30' group by 1, 2 union ALL select year(ClaimDate) as yearz, month(ClaimDate) as monthz, count(distinct sender) as claimers from anc_claim where ClaimDate >= '2021-10-01' and ClaimDATE <= '2021-10-31' group by 1, 2 union ALL select year(ClaimDate) as yearz, month(ClaimDate) as monthz, count(distinct sender) as claimers from anc_claim where ClaimDate >= '2021-11-01' and ClaimDATE <= '2021-11-30' group by 1, 2 union ALL select year(ClaimDate) as yearz, month(ClaimDate) as monthz, count(distinct sender) as claimers from anc_claim where ClaimDate >= '2021-12-01' and ClaimDATE <= '2021-12-31' group by 1, 2 union ALL select year(ClaimDate) as yearz, month(ClaimDate) as monthz, count(distinct sender) as claimers from anc_claim where ClaimDate >= '2022-01-01' and ClaimDATE <= '2022-01-31' group by 1, 2) select s.yearz, s.monthz, wallets, claimers, (wallets / claimers) * 100 as sold_percentage from sold_cr s join claim_cl c ON s.yearz = c.yearz AND s.monthz=c.monthz group by 1, 2, 3, 4

Anchor Emissions (Hard Mode)