There are queries in
SQL Query to Base Calendars
which illustrate how you would get to the data.
Somebody has also a query for availlability per day
select
u.last_name
,u.first_name
,u.unique_name
--,s.prj_object_id
,s.slice_date
,s.slice
from
prj_blb_slicerequests r
,prj_blb_slices s
,srm_resources u
where
r.id = s.slice_request_id
and r.request_name = 'DAILYRESOURCEAVAILCURVE'
and u.id = s.prj_object_id
and u.unique_name = 'cal'
and slice_date >= '2013-04-01'
and slice_date <= '2013-04-15'