CryptoIcicleIn the News - 13. DYDX Unlock - 2. Swaps from DYDX
Updated 2023-01-26
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
›
⌄
-- DYDX holders are bracing for a massive event next month, as 105% of the circulating supply will be distributed to investors and team members.
-- Have holders begun preparing for this massive unlock? If so, what actions are they taking to prepare? How do you expect the market to react
-- in the weeks leading up to and following the unlock? Back up your assertions with data.
-- Basis of Payment:
-- To be eligible for payment.
-- The submission must be sent before the deadline indicated on the bounty page.
-- The submission must score a minimum of 6 points according to the Evaluation Criteria.
-- 💰 Payout
-- Rank Based Payout
-- Payout is in USDC 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.
-- USDC Payouts:
-- Rank USDC amount
-- First place 400
-- Second place 150
-- Third place 150
-- 4th through 15th place 75
-- 16th through 21st place 50
with txns as(
select
date_trunc('{{date_range}}',block_timestamp) as date,
platform as type,
count(distinct tx_hash) as n_txns,
count(distinct origin_from_address) as n_wallets,
sum(amount_in_usd) as swap_amount_usd,
sum(amount_in) as swap_amount_token,
sum(n_txns) over (partition by type order by date asc rows between unbounded preceding and current row) as cum_n_txns,
sum(n_wallets) over (partition by type order by date asc rows between unbounded preceding and current row) as cum_n_wallets,
sum(swap_amount_usd) over (partition by type order by date asc rows between unbounded preceding and current row) as cum_swap_amount_usd,
sum(swap_amount_token) over (partition by type order by date asc rows between unbounded preceding and current row) as cum_swap_amount_token
from ethereum.core.ez_dex_swaps
where block_timestamp >= CURRENT_DATE - {{n_days}}
Run a query to Download Data