Hi,
If you are referring to the Data Warehouse Tool within Reports & Analytics, it provides 4 delivery frequencies i.e. Daily, Weekly, Monthly and Yearly (It doesn't offer Hourly frequency).
I guess you only observed Monthly and Yearly because of the timeframe selected for your Data Warehouse request. The delivery frequency shown are subject to the timeframe you define for your request. For an ex: If you select 'Last Month' which is one of the preset reporting date, the delivery frequency options available would only be 'Monthly' and 'Yearly'.
Again, if you select another reporting date preset like 'Last Week', now the delivery options would be 'Weekly', Monthly' and 'Yearly'.
The Daily frequency would start showing up as soon as you select any of the day presets like 'Last 7 days'.
Hope this helps.
Note: Data Warehouse data is not real-time. If you are looking for real-time data, you may consider using Run a Real-Time report.