CryptoIcicleSolana - 5. Gaming on Sol
Updated 2023-02-06
9999
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
›
⌄
-- According to Spire, gaming has been picking up on Solana https://twitter.com/voteforpedrito/status/1620886335937708032?s=20&t=cOIVO1EtSx4F4dkzNT78iA
-- Between Star Atlas, Genopets, and Aurory, games are beginning to allow users to experiment with what they have been building over the past year and a half.
-- Create a dashboard showing user activity and growth of these three games.
-- Is there any crossover between these three games in terms of users or does each game seem to have its own fan base?
-- What is the profile of gaming users on Solana? What types of activities are these users doing within the games and within the Solana ecosystem?
-- 💰 Payout
-- Rank Based Payout
-- Payout is in SOL 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.
-- SOL Payouts:
-- Rank Amount
-- First place $500 in SOL
-- Second place $300 in SOL
-- Third place $300 in SOL
-- 4th through 15th place $75 in SOL
-- 16th through 25st place $50 in SOL
-- Payments are issued on the Solana network.
-- SQL_CREDIT: https://dune.com/dsaber/solana-gaming-stats
WITH gaming_responses AS (
SELECT 'BR1' AS game, 'BRAVO READY' AS studio, '5Mj3eghzZG2qZLEWKr4sDePQCxmd2PqWD8yb9ss7fb2B' AS address, 'NFT collection' AS type
UNION ALL
SELECT 'BR1' AS game, 'BRAVO READY' AS studio, '5nZvDAEpnPaf9xM1BYFeFpA3oYamaqJ8kdTUUXdgDAjK' AS address, 'Hot wallet' AS type
UNION ALL
SELECT 'DeFi Land' AS game, 'DeFi Land' AS studio, '5PqvBsEQFvM5DQRC9wsT1fWBXRThb2voYumbyKUcvFW8' AS address, 'NFT collection' AS type
UNION ALL
SELECT 'DeFi Land' AS game, 'DeFi Land' AS studio, '6rPWVjP1AJSDN2pNgUktadz1Zp7gqQJVJq2zpSXNnDHE' AS address, 'NFT collection' AS type
UNION ALL
SELECT 'DeFi Land' AS game, 'DeFi Land' AS studio, '2PQi1KRJrGSJnVXmLRJCXa9yuhA7DA9otXkbncXnBTxs' AS address, 'Hot wallet' AS type
UNION ALL
SELECT 'DeFi Land' AS game, 'DeFi Land' AS studio, 'GoLDYyyiVeXnVf9qgoK712N5esm1cCbHEK9aNJFx47Sx' AS address, 'Fungible token' AS type
UNION ALL
SELECT 'DeFi Land' AS game, 'DeFi Land' AS studio, 'DFL1zNkaGPWm1BqAVqRjCZvHmwTFrEaJtbzJWgseoNJh' AS address, 'Fungible token' AS type
Run a query to Download Data