shadilSuccessful Bids on Kujira - unique users on each asset
Updated 2022-04-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
-- kujira
-- Old contract https://finder.terra.money/columbus-4/address/terra1w9ky73v4g7v98zzdqpqgf3kjmusnx4d4mvnac6
-- New contract https://finder.terra.money/columbus-5/address/terra1e25zllgag7j9xsun3me4stnye2pcg66234je3u
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 asset_name,
count(DISTINCT msg_value:sender) as unique_users
from terra.msgs
where (msg_value:contract = 'terra1e25zllgag7j9xsun3me4stnye2pcg66234je3u' or msg_value:contract = 'terra1w9ky73v4g7v98zzdqpqgf3kjmusnx4d4mvnac6')
and msg_type = 'wasm/MsgExecuteContract'
and msg_value:execute_msg:submit_bid is not NULL
and (msg_value:execute_msg:submit_bid:collateral_token = 'terra1kc87mu460fwkqte29rquh4hc20m54fxwtsx7gp' or msg_value:execute_msg:submit_bid:collateral_token = 'terra1dzhzukyezv0etz22ud940z7adyv7xgcjkahuun')
and tx_status = 'SUCCEEDED'
and date(block_timestamp) >= '2021-11-11' -- inception date
GROUP BY asset_name
Run a query to Download Data