repo_owner,

repo_name,

endpoint_name,

snapshot_timestamp,

data:forks_count::int AS forks

FROM

near.core.fact_developer_activity

WHERE

DATE_TRUNC('day', snapshot_timestamp) = CURRENT_DATE

AND data:forks_count::int > 0

ORDER BY forks DESC

LIMIT 10;