Well I hope this helps......
As an Aquarian lady I understand your concerns and I also understand his "aloofness". It is a challenge for anyone to be with an Aquarius, even another Aquarius. I am sure he values your friendship. However, as an Aquarian, I would rebel against anything being shoved down my throat. And it sounds like that is kind of happening with you trying too hard to be his friend. I have alot of Aquarian friends, most are single. Most Aquarians can't handle clingy, needy people because they exhaust all of our energy.
It is important to remember that this man is human and he requires all the love and friendship that anyone does. He is just a different sort. If you are determined to "figure him out" you are wasting your time. He accepts you for who you are and you must do the same if you want this man as your friend.
We are thinkers and we can't help it. It is hard for us to decipher emotions because we can't compute. Sometimes we feel more "at home" with a stranger, than our own circle of friends. But when you do get an Aquarian to feel, we remember it for the rest of our lives.