Heminunique users placed bid with UST or aUST
Updated 2022-04-18
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
›
⌄
WITH ust as (
SELECT
date_trunc('day', block_timestamp) as day,
COUNT(DISTINCT msg_value:sender) as ust_unique_users,
avg(msg_value:"execute_msg":"submit_bid":"premium_slot") as ust_avg_slot,
sum(msg_value:coins[0]:amount / 1e6) as ust_bid_amount,
sum(ust_unique_users) over (ORDER BY DAY) as cum_ust_users
FROM terra.msgs
WHERE msg_type = 'wasm/MsgExecuteContract'
AND msg_value:"contract" = 'terra1e25zllgag7j9xsun3me4stnye2pcg66234je3u'
AND msg_value:"execute_msg":"submit_bid" is not NULL
AND TX_STATUS = 'SUCCEEDED'
AND msg_value:coins[0]:denom = 'uusd'
AND block_timestamp >= '2022-02-04'
GROUP BY 1
),
aust as (
SELECT
date_trunc('day', block_timestamp) as day,
COUNT(DISTINCT event_attributes:"from" )as aust_unique_users,
sum(event_attributes:"0_amount" / 1e6) as aust_bid_amount,
avg(event_attributes:"premium_slot") as aust_avg_slot,
sum(aust_unique_users) over (ORDER BY DAY) as cum_aust_users
FROM terra.msg_events
WHERE event_type = 'wasm'
AND event_attributes:"0_contract_address" = 'terra1hzh9vpxhsk8253se0vv5jj6etdvxu3nv8z07zu'
AND event_attributes:"1_contract_address" = 'terra13nk2cjepdzzwfqy740pxzpe3x75pd6g0grxm2z'
AND event_attributes:"1_action" = 'submit_bid'
GROUP BY 1
)
SELECT
ust.day,
Run a query to Download Data