Is it possible to achieve the following result in SC, with a smaller timeframe embedded within the candles of a larger timeframe? I have tried using the study/price overlay, but not getting the results I am looking for.

You can do it with a study contributed by user Kiwi:
Go to Analysis >> Studies >> Add Custom Study >> User Contributed Studies >> NMinBars