Sandglass LED lamp