While there is growing experimental evidence that cerebrospinal fluid (CSF) flow induced by the beating of ependymal cilia is an important factor for neuronal guidance, the respective contribution of vascular pulsation-driven macroscale oscillatory CSF flow remains unclear. This work uses computational fluid dynamics to elucidate the interplay between macroscale and cilia-induced CSF flows and their relative impact on near-wall dynamics. Physiological macroscale CSF dynamics are simulated in the ventricular space using subject-specific anatomy, wall motion and choroid plexus pulsations derived from magnetic resonance imaging. Near-wall flow is quantified in two subdomains selected from the right lateral ventricle, for which dynamic boundary conditions are extracted from the macroscale simulations. When cilia are neglected, CSF pulsation leads to periodic flow reversals along the ventricular surface, resulting in close to zero time-averaged force on the ventricle wall. The cilia promote more aligned wall shear stresses that are on average two orders of magnitude larger compared with those produced by macroscopic pulsatile flow. These findings indicate that CSF flow-mediated neuronal guidance is likely to be dominated by the action of the ependymal cilia in the lateral ventricles, whereas CSF dynamics in the centre regions of the ventricles is driven predominantly by wall motion and choroid plexus pulsation.