mariyabLUNA
    Updated 2022-04-14
    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