HeminbLUNA and bETH daily unique bidders
    Updated 2022-04-17
    with tab1 as(
    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
    Run a query to Download Data