-- When: no due date but would be great to have today -- Bounty reward: 3 LUNA -- Review criteria: approval by TFL team member -- Polish level: moderate; 1-2 paragraphs max will be sufficient, the insights here matter more than the presentation -- Bounty: -- Analyze the age of ANC holdings (average is good, distribution of ages is even better) for wallets who voted YES -- on Poll 18: https://app.anchorprotocol.com/poll/18 -- Are these voters longtime holders, or are they acquiring ANC for the purpose of voting in this proposal? with yes_votes as ( select * from anchor.gov_vote where poll_id='18' and vote = 'yes' ), voters as ( select min(b.date) as first_anc_date, v.voter, avg(v.balance) as avg_anc_balance, max(v.balance) as max_anc_balance, datediff('day', first_anc_date,'2022-03-10') as n_days_anc_held from terra.daily_balances b join yes_votes v on b.address = v.voter and b.currency = 'ANC' where b.date >= CURRENT_DATE - 120 group by voter ) select count(distinct voter) as n_voters, CASE WHEN n_days_anc_held > 0 and n_days_anc_held <= 10 THEN 'a. < 10 Days' WHEN n_days_anc_held > 10 and n_days_anc_held <= 20 THEN 'b. 10-20 Days' WHEN n_days_anc_held > 20 and n_days_anc_held <= 30 THEN 'c. 20-30 Days' WHEN n_days_anc_held > 30 and n_days_anc_held <= 40 THEN 'd. 30-40 Days' WHEN n_days_anc_held > 40 and n_days_anc_held <= 50 THEN 'e. 40-50 Days' WHEN n_days_anc_held > 50 and n_days_anc_held <= 60 THEN 'f. 50-60 Days' WHEN n_days_anc_held > 60 and n_days_anc_held <= 70 THEN 'f. 60-70 Days' WHEN n_days_anc_held > 70 and n_days_anc_held <= 80 THEN 'f. 70-80 Days' WHEN n_days_anc_held > 80 and n_days_anc_held <= 90 THEN 'f. 80-90 Days' WHEN n_days_anc_held > 90 THEN 'g. > 90 Days' END as category from voters group by category order by category

Anchor ANC Holding Prop-18