mariyabLUNA
Updated 2022-04-14
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT
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'
end as token,
count(distinct MSG_VALUE:sender) as unique_users
from terra.msgs
where (MSG_VALUE:contract='terra1e25zllgag7j9xsun3me4stnye2pcg66234je3u'
or MSG_VALUE:contract='terra1w9ky73v4g7v98zzdqpqgf3kjmusnx4d4mvnac6')
and TX_STATUS='SUCCEEDED'
group by 1 having token is not null
Run a query to Download Data