During my wandering across the internet I found out about the Walled City of Kowloon:
It was 6.5 acres of buildings, built on top of other buildings, blocking out sun light to the lower levels. It would have grown taller, but it was located by an airport.
Here's a short article on the city:
http://io9.com/5512888/the-walled-city-where-sunlight-couldnt-reach
and here's a cool cross section map, EDIT: fixed the link to show the whole map:
http://www.deconcrete.org/wp-content/uploads/2010/03/Kowloon-Cross-section-low.jpg
It really influence my vision of what
some hive cities would look like, (yes I know there is tons of variety across the Imperium)