shadilSuccessful Bids on Kujira - unique users on each asset
    Updated 2022-04-11
    -- 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