CryptoIcicleMiso User Base - Weekly
Updated 2022-09-19
999
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
›
⌄
-- Miso User Base
-- Analyze the user base of Miso.
-- Pay by Quality
-- Your score determines your final payout.
-- Grand Prize 62.501 SUSHI (A score of 11 or 12 earns you a Grand Prize title)
-- Payout 41.667 SUSHI
-- Score Multiplier 0-7 : 0% 8 : 50% 9 : 75% 10 : 100% 11 : 125% 12 : 150%
-- Payout Network Ethereum
-- Level Beginner
-- Difficulty Medium
-- Q112. Analyze the user base of Miso.
-- How many users does it have across how many chains?
-- Chart that by week and by month.
-- Has the recent bear market affected that?
with eth_markets as (
select
distinct contract_address
from ethereum.core.fact_event_logs
where 1=1
and origin_function_signature = '0xfa18022c' -- prepareMiso
and event_name = 'AuctionWalletUpdated'
-- and tx_hash = '0x79a6e43a80bff6db671bfff8cbee46ac46d612c8ef282b1cb9ba1bc134890d38'
order by contract_address
),
eth_commit_txns as (
select
*
from ethereum.core.fact_event_logs
where 1=1
and (
-- Non-ETH Tokens
(
origin_function_signature = '0xdc97e082' -- commitTokens
Run a query to Download Data