date_trunc('day', block_timestamp) as day,

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 NULL

END AS colleteral_token,

COUNT(DISTINCT msg_value:sender) as unique_users ,

sum(msg_value:coins[0]:amount / 1e6) as bid_amounts,

avg(msg_value:"execute_msg":"submit_bid":"premium_rate" * 100) as premium_avg,

avg(msg_value:"execute_msg":"submit_bid":"premium_slot") as avg_slot

FROM terra.msgs

WHERE msg_type = 'wasm/MsgExecuteContract'

AND msg_value:"contract" IN ('terra1w9ky73v4g7v98zzdqpqgf3kjmusnx4d4mvnac6' , 'terra1e25zllgag7j9xsun3me4stnye2pcg66234je3u')

AND msg_value:"execute_msg":"submit_bid" is not NULL

AND TX_STATUS = 'SUCCEEDED'

AND msg_value:coins[0]:denom = 'uusd'

AND colleteral_token is not NULL

GROUP BY 1 , 2