CryptoIcicleSolana-107.DUST is in the Air - Top 10 Swappers from $DUST
Updated 2022-09-08
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
›
⌄
-- Grand Prize
-- 3.441 SOL (A score of 11 or 12 earns you a Grand Prize title)
-- Payout
-- 2.294 SOL
-- Score Multiplier
-- 0-7 : 0%
-- 8 : 50%
-- 9 : 75%
-- 10 : 100%
-- 11 : 125%
-- 12 : 150%
-- Payout Network Solana
-- Level Beginner
-- Difficulty Medium
-- Q107. $Dust is the utility token behind the most popular NFT project on Solana - Degods.
-- The team and the community have been building with $DUST. How is $DUST being used in the Solana ecosystem?
-- What are its most popular use cases and where are buyers of $DUST coming from?
-- Highlight at least 3 metrics showing $DUST trends in Solana.
with swappers_from_dust as (
select
l.address_name as swap_to_token,
s.*
from solana.fact_swaps s
join solana.core.dim_labels l on s.swap_to_mint = l.address
where swap_from_mint = 'DUSTawucrTsGU8hcqRdHDCbuYhCPADMLM2VcCb8VnFnQ' -- DUST token address
and block_timestamp >= '2022-01-01'
and swap_program = 'jupiter aggregator v2'
)
select
swapper,
sum(swap_from_amount) as dust_amount
from swappers_from_dust
Run a query to Download Data