iboo-jbj2MVBLUNA and BETH bids
Updated 2022-04-17
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select block_timestamp::date,
case
when msg_value:execute_msg:submit_bid:collateral_token = 'terra1kc87mu460fwkqte29rquh4hc20m54fxwtsx7gp' then 'bLuna_bids'
when msg_value:execute_msg:submit_bid:collateral_token = 'terra1dzhzukyezv0etz22ud940z7adyv7xgcjkahuun' then 'bETH_bids'
end as bids,TX_STATUS,
count (distinct msg_value:sender)
from terra.msgs
where msg_value:contract in ('terra1e25zllgag7j9xsun3me4stnye2pcg66234je3u','terra1w9ky73v4g7v98zzdqpqgf3kjmusnx4d4mvnac6')
and msg_value:execute_msg:submit_bid:collateral_token in ('terra1kc87mu460fwkqte29rquh4hc20m54fxwtsx7gp','terra1dzhzukyezv0etz22ud940z7adyv7xgcjkahuun')
group by 1,2,3
Run a query to Download Data