You can check on dapps to see it for yourself because hourly payment APY is the shortest time I saw in DeFi so far. It's not base on the coin but rather on the DeFi that offering the coin farming since they dictate the standards on APY structure of the token they are listing? Project should agree to there terms before they will be listed. Shorter claim period means more has fee it consume especially if you are on Ethereum network so I don't see the sense on looking for shortr time frame.