SocioCryptoTotal unique users placed bids on Kujira since its inception
Updated 2022-04-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT DISTINCT count(DISTINCT msg_value:sender) as unique_users,
-- msg_value:coins[0]:denom as bid_currency,
-- msg_value:coins[0]:amount/pow(10,6) as bid_amount,
-- msg_value:execute_msg:submit_bid:premium_slot as premium_slot,
CASE WHEN msg_value:execute_msg:submit_bid:collateral_token = 'terra1kc87mu460fwkqte29rquh4hc20m54fxwtsx7gp' THEN 'bluna'
WHEN msg_value:execute_msg:submit_bid:collateral_token = 'terra1dzhzukyezv0etz22ud940z7adyv7xgcjkahuun' THEN 'beth'
ELSE 'other' END as collateral_token
FROM terra.msgs
WHERE msg_value:execute_msg:submit_bid is not NULL
AND (msg_value:contract = 'terra1e25zllgag7j9xsun3me4stnye2pcg66234je3u' OR msg_value:contract = 'terra1w9ky73v4g7v98zzdqpqgf3kjmusnx4d4mvnac6') --anchor contract address
-- AND (msg_value:execute_msg:submit_bid:collateral_token = 'terra1kc87mu460fwkqte29rquh4hc20m54fxwtsx7gp' OR
-- msg_value:execute_msg:submit_bid:collateral_token = 'terra1dzhzukyezv0etz22ud940z7adyv7xgcjkahuun')
GROUP BY collateral_token
Run a query to Download Data