select date_trunc('day',block_timestamp)as day,

count (distinct msg_value:sender)as bLUNA_unique_bidders

from terra.msgs

where day>='2021-11-01'

and msg_value:contract in ('terra1e25zllgag7j9xsun3me4stnye2pcg66234je3u','terra1w9ky73v4g7v98zzdqpqgf3kjmusnx4d4mvnac6')

and msg_value:execute_msg:submit_bid:collateral_token = 'terra1kc87mu460fwkqte29rquh4hc20m54fxwtsx7gp'

group by 1),

tab2 as(

select date_trunc('day',block_timestamp)as day,

((count (distinct msg_value:sender)) * -1) as bETH_unque_bidders

from terra.msgs

where day>='2021-11-01'

and msg_value:contract in ('terra1e25zllgag7j9xsun3me4stnye2pcg66234je3u','terra1w9ky73v4g7v98zzdqpqgf3kjmusnx4d4mvnac6')

and msg_value:execute_msg:submit_bid:collateral_token = 'terra1dzhzukyezv0etz22ud940z7adyv7xgcjkahuun'

group by 1)

select tab1.day,tab1.bLUNA_unique_bidders,tab2.bETH_unque_bidders

from tab1

left join tab2

on tab1.day=tab2.day