CryptoIcicleTerra - 6. New Year, New LUNA? - Swap Metrics - To Luna
Updated 2023-01-16
99
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
›
⌄
-- The holidays and New Year are often chaotic in the crypto and DEFI space, as users make a spree of new transactions and wallets as they receive (and give) some cash and coins as holiday gifts.
-- Has this flurry of winter activity impacted the Terra ecosystem?
-- Are users creating new wallets or buying tokens with their newfound holiday wealth?
-- Are they staking all those new tokens once they get them?
-- Or are they selling tokens to pay for their own gifts and holiday travel?
-- Create a dashboard documenting significant trends in transactions, wallets, supply, staking, development, or other aspects of the Terra ecosystem.
-- Note any changes in metrics such as the average and total transactions per week and the fees associated with them,
-- the total and average number of new wallets created each week, the total and average number of contracts deployed, LUNA staked, and anything else you interesting.
-- We are not looking for data on Terra Classic for this bounty. Please use the terra.core tables hoste
-- Rank Based Payout
-- Payout is in LUNA and xMETRIC, where the top eligible scorers are paid the amounts below. The first, second and third place submissions must have a score of 10 or higher to be eligible for higher payout amounts.
-- If there are not enough eligible submissions for a category, remaining funds will either be paid to lower tier submissions or reserved for future bounty programs. Final determination of payouts and rankings are at the discretion of the MetricsDAO Bounty Operations Team.
-- LUNA Payouts:
-- First place 400$ in LUNA
-- Second place 150$ in LUNA
-- Third place 150$ in LUNA
-- 4th through 15th place 75$ in LUNA
-- 16th through 21st place 50$ in LUNA
-- Payments are issued on the Terra mainnet network.
-- xMETRIC Payouts:
-- Rank xMETRIC amount
-- First place 1000
-- Following Top 20 Submissions 500
-- score of 9 or higher 150
-- score of 8 or higher 100
-- score of 7 or higher 75
-- score of 6 or higher 50
with txns as(
select
date_trunc('{{date_range}}',block_timestamp) as date,
year(block_timestamp) as year,
count(distinct tx_id) as n_txns,
count(distinct trader) as n_wallets,
sum(to_amount/1e6) as fee_luna,