Payload
{
"ref": "refs/heads/main",
"before": "19f28088c7435a51587b3b777e4e19b662b03a19",
"after": "978bd0e3c19380cbf910e475eafaaf40eeb1f7a1",
"repository": {
"id": 1184214329,
"node_id": "R_kgDORpWtOQ",
"name": "dune",
"full_name": "darkmatter/dune",
"private": true,
"owner": {
"name": "darkmatter",
"email": "hello@dm.sh",
"login": "darkmatter",
"id": 17834193,
"node_id": "MDEyOk9yZ2FuaXphdGlvbjE3ODM0MTkz",
"avatar_url": "https://avatars.githubusercontent.com/u/17834193?v=4",
"gravatar_id": "",
"url": "https://api.github.com/users/darkmatter",
"html_url": "https://github.com/darkmatter",
"followers_url": "https://api.github.com/users/darkmatter/followers",
"following_url": "https://api.github.com/users/darkmatter/following{/other_user}",
"gists_url": "https://api.github.com/users/darkmatter/gists{/gist_id}",
"starred_url": "https://api.github.com/users/darkmatter/starred{/owner}{/repo}",
"subscriptions_url": "https://api.github.com/users/darkmatter/subscriptions",
"organizations_url": "https://api.github.com/users/darkmatter/orgs",
"repos_url": "https://api.github.com/users/darkmatter/repos",
"events_url": "https://api.github.com/users/darkmatter/events{/privacy}",
"received_events_url": "https://api.github.com/users/darkmatter/received_events",
"type": "Organization",
"user_view_type": "public",
"site_admin": false
},
"html_url": "https://github.com/darkmatter/dune",
"description": "Dune Analytics dbt project for LP Tracker",
"fork": false,
"url": "https://api.github.com/repos/darkmatter/dune",
"forks_url": "https://api.github.com/repos/darkmatter/dune/forks",
"keys_url": "https://api.github.com/repos/darkmatter/dune/keys{/key_id}",
"collaborators_url": "https://api.github.com/repos/darkmatter/dune/collaborators{/collaborator}",
"teams_url": "https://api.github.com/repos/darkmatter/dune/teams",
"hooks_url": "https://api.github.com/repos/darkmatter/dune/hooks",
"issue_events_url": "https://api.github.com/repos/darkmatter/dune/issues/events{/number}",
"events_url": "https://api.github.com/repos/darkmatter/dune/events",
"assignees_url": "https://api.github.com/repos/darkmatter/dune/assignees{/user}",
"branches_url": "https://api.github.com/repos/darkmatter/dune/branches{/branch}",
"tags_url": "https://api.github.com/repos/darkmatter/dune/tags",
"blobs_url": "https://api.github.com/repos/darkmatter/dune/git/blobs{/sha}",
"git_tags_url": "https://api.github.com/repos/darkmatter/dune/git/tags{/sha}",
"git_refs_url": "https://api.github.com/repos/darkmatter/dune/git/refs{/sha}",
"trees_url": "https://api.github.com/repos/darkmatter/dune/git/trees{/sha}",
"statuses_url": "https://api.github.com/repos/darkmatter/dune/statuses/{sha}",
"languages_url": "https://api.github.com/repos/darkmatter/dune/languages",
"stargazers_url": "https://api.github.com/repos/darkmatter/dune/stargazers",
"contributors_url": "https://api.github.com/repos/darkmatter/dune/contributors",
"subscribers_url": "https://api.github.com/repos/darkmatter/dune/subscribers",
"subscription_url": "https://api.github.com/repos/darkmatter/dune/subscription",
"commits_url": "https://api.github.com/repos/darkmatter/dune/commits{/sha}",
"git_commits_url": "https://api.github.com/repos/darkmatter/dune/git/commits{/sha}",
"comments_url": "https://api.github.com/repos/darkmatter/dune/comments{/number}",
"issue_comment_url": "https://api.github.com/repos/darkmatter/dune/issues/comments{/number}",
"contents_url": "https://api.github.com/repos/darkmatter/dune/contents/{+path}",
"compare_url": "https://api.github.com/repos/darkmatter/dune/compare/{base}...{head}",
"merges_url": "https://api.github.com/repos/darkmatter/dune/merges",
"archive_url": "https://api.github.com/repos/darkmatter/dune/{archive_format}{/ref}",
"downloads_url": "https://api.github.com/repos/darkmatter/dune/downloads",
"issues_url": "https://api.github.com/repos/darkmatter/dune/issues{/number}",
"pulls_url": "https://api.github.com/repos/darkmatter/dune/pulls{/number}",
"milestones_url": "https://api.github.com/repos/darkmatter/dune/milestones{/number}",
"notifications_url": "https://api.github.com/repos/darkmatter/dune/notifications{?since,all,participating}",
"labels_url": "https://api.github.com/repos/darkmatter/dune/labels{/name}",
"releases_url": "https://api.github.com/repos/darkmatter/dune/releases{/id}",
"deployments_url": "https://api.github.com/repos/darkmatter/dune/deployments",
"created_at": 1773746214,
"updated_at": "2026-04-27T14:52:28Z",
"pushed_at": 1781138714,
"git_url": "git://github.com/darkmatter/dune.git",
"ssh_url": "git@github.com:darkmatter/dune.git",
"clone_url": "https://github.com/darkmatter/dune.git",
"svn_url": "https://github.com/darkmatter/dune",
"homepage": null,
"size": 360,
"stargazers_count": 0,
"watchers_count": 0,
"language": "Python",
"has_issues": true,
"has_projects": true,
"has_downloads": true,
"has_wiki": true,
"has_pages": false,
"has_discussions": false,
"forks_count": 0,
"mirror_url": null,
"archived": false,
"disabled": false,
"open_issues_count": 0,
"license": null,
"allow_forking": false,
"is_template": false,
"web_commit_signoff_required": false,
"has_pull_requests": true,
"pull_request_creation_policy": "all",
"topics": [],
"visibility": "private",
"forks": 0,
"open_issues": 0,
"watchers": 0,
"default_branch": "main",
"stargazers": 0,
"master_branch": "main",
"organization": "darkmatter",
"custom_properties": {}
},
"pusher": {
"name": "czxtm",
"email": "1325802+czxtm@users.noreply.github.com"
},
"forced": false,
"organization": {
"login": "darkmatter",
"id": 17834193,
"node_id": "MDEyOk9yZ2FuaXphdGlvbjE3ODM0MTkz",
"url": "https://api.github.com/orgs/darkmatter",
"repos_url": "https://api.github.com/orgs/darkmatter/repos",
"events_url": "https://api.github.com/orgs/darkmatter/events",
"hooks_url": "https://api.github.com/orgs/darkmatter/hooks",
"issues_url": "https://api.github.com/orgs/darkmatter/issues",
"members_url": "https://api.github.com/orgs/darkmatter/members{/member}",
"public_members_url": "https://api.github.com/orgs/darkmatter/public_members{/member}",
"avatar_url": "https://avatars.githubusercontent.com/u/17834193?v=4",
"description": ""
},
"enterprise": {
"id": 469843,
"slug": "darkmatter",
"name": "darkmatter",
"node_id": "E_kgDOAAcrUw",
"avatar_url": "https://avatars.githubusercontent.com/b/469843?v=4",
"description": "",
"website_url": "darkmatter.io",
"html_url": "https://github.com/enterprises/darkmatter",
"created_at": "2025-09-07T16:01:00Z",
"updated_at": "2026-06-07T16:53:26Z"
},
"sender": {
"login": "czxtm",
"id": 1325802,
"node_id": "MDQ6VXNlcjEzMjU4MDI=",
"avatar_url": "https://avatars.githubusercontent.com/u/1325802?v=4",
"gravatar_id": "",
"url": "https://api.github.com/users/czxtm",
"html_url": "https://github.com/czxtm",
"followers_url": "https://api.github.com/users/czxtm/followers",
"following_url": "https://api.github.com/users/czxtm/following{/other_user}",
"gists_url": "https://api.github.com/users/czxtm/gists{/gist_id}",
"starred_url": "https://api.github.com/users/czxtm/starred{/owner}{/repo}",
"subscriptions_url": "https://api.github.com/users/czxtm/subscriptions",
"organizations_url": "https://api.github.com/users/czxtm/orgs",
"repos_url": "https://api.github.com/users/czxtm/repos",
"events_url": "https://api.github.com/users/czxtm/events{/privacy}",
"received_events_url": "https://api.github.com/users/czxtm/received_events",
"type": "User",
"user_view_type": "public",
"site_admin": false
},
"installation": {
"id": 131074261,
"node_id": "MDIzOkludGVncmF0aW9uSW5zdGFsbGF0aW9uMTMxMDc0MjYx"
},
"created": false,
"deleted": false,
"base_ref": null,
"compare": "https://github.com/darkmatter/dune/compare/19f28088c743...978bd0e3c193",
"commits": [
{
"id": "f3f9ffc508d14087d2b265dff90b2b85b2423fd7",
"tree_id": "e4118d54ffb5c8c147e0f3f6043feadea424f121",
"distinct": true,
"message": "fix: dedupe address book by normalized address\n\nSeed had case-variant duplicate of 0x12345b…0883. Removed dup row and\nrewrote stg_address_book dedup with row_number() — Trino has no\nDISTINCT ON (was Postgres-only syntax).",
"timestamp": "2026-06-10T17:45:01-07:00",
"url": "https://github.com/darkmatter/dune/commit/f3f9ffc508d14087d2b265dff90b2b85b2423fd7",
"author": {
"name": "Cooper Maruyama",
"email": "me@cooperm.com",
"date": "2026-06-10T17:45:01-07:00",
"username": "czxtm"
},
"committer": {
"name": "Cooper Maruyama",
"email": "me@cooperm.com",
"date": "2026-06-10T17:45:01-07:00",
"username": "czxtm"
},
"added": [],
"removed": [],
"modified": [
"models/staging/stg_address_book.sql",
"seeds/address_book.csv"
]
},
{
"id": "017dcfdb1c01c73e569b8e888ff435c98b881d23",
"tree_id": "01347d765679eaec79f96a278181ec3a00c2de32",
"distinct": true,
"message": "feat: declare Dune curated sources with freshness config",
"timestamp": "2026-06-10T17:45:01-07:00",
"url": "https://github.com/darkmatter/dune/commit/017dcfdb1c01c73e569b8e888ff435c98b881d23",
"author": {
"name": "Cooper Maruyama",
"email": "me@cooperm.com",
"date": "2026-06-10T17:45:01-07:00",
"username": "czxtm"
},
"committer": {
"name": "Cooper Maruyama",
"email": "me@cooperm.com",
"date": "2026-06-10T17:45:01-07:00",
"username": "czxtm"
},
"added": [],
"removed": [],
"modified": [
"models/staging/sources.yml"
]
},
{
"id": "6c435431fb5244a60b339ff4e75e7eb1c30a561a",
"tree_id": "1bf9a7caa31d4aa4ffe9447da63bfa84f05f6902",
"distinct": true,
"message": "fix: extend fct_matched_txs lookback to 14 days",
"timestamp": "2026-06-10T17:45:02-07:00",
"url": "https://github.com/darkmatter/dune/commit/6c435431fb5244a60b339ff4e75e7eb1c30a561a",
"author": {
"name": "Cooper Maruyama",
"email": "me@cooperm.com",
"date": "2026-06-10T17:45:02-07:00",
"username": "czxtm"
},
"committer": {
"name": "Cooper Maruyama",
"email": "me@cooperm.com",
"date": "2026-06-10T17:45:02-07:00",
"username": "czxtm"
},
"added": [],
"removed": [],
"modified": [
"models/marts/fct_matched_txs.sql"
]
},
{
"id": "c1c7277c070112b0d1cd78133fb75028496d4bf0",
"tree_id": "d0b117e615b0f7d5da138169b9156dc82e1563d3",
"distinct": true,
"message": "ci: enable hourly prod incremental schedule",
"timestamp": "2026-06-10T17:45:02-07:00",
"url": "https://github.com/darkmatter/dune/commit/c1c7277c070112b0d1cd78133fb75028496d4bf0",
"author": {
"name": "Cooper Maruyama",
"email": "me@cooperm.com",
"date": "2026-06-10T17:45:02-07:00",
"username": "czxtm"
},
"committer": {
"name": "Cooper Maruyama",
"email": "me@cooperm.com",
"date": "2026-06-10T17:45:02-07:00",
"username": "czxtm"
},
"added": [],
"removed": [],
"modified": [
".github/workflows/dbt_prod.yml"
]
},
{
"id": "978bd0e3c19380cbf910e475eafaaf40eeb1f7a1",
"tree_id": "94c555b4b88dd24f1cec3c412459e8b57a299137",
"distinct": true,
"message": "chore: track beads issues export, ignore .omo session state",
"timestamp": "2026-06-10T17:45:02-07:00",
"url": "https://github.com/darkmatter/dune/commit/978bd0e3c19380cbf910e475eafaaf40eeb1f7a1",
"author": {
"name": "Cooper Maruyama",
"email": "me@cooperm.com",
"date": "2026-06-10T17:45:02-07:00",
"username": "czxtm"
},
"committer": {
"name": "Cooper Maruyama",
"email": "me@cooperm.com",
"date": "2026-06-10T17:45:02-07:00",
"username": "czxtm"
},
"added": [
".beads/issues.jsonl"
],
"removed": [],
"modified": [
".gitignore"
]
}
],
"head_commit": {
"id": "978bd0e3c19380cbf910e475eafaaf40eeb1f7a1",
"tree_id": "94c555b4b88dd24f1cec3c412459e8b57a299137",
"distinct": true,
"message": "chore: track beads issues export, ignore .omo session state",
"timestamp": "2026-06-10T17:45:02-07:00",
"url": "https://github.com/darkmatter/dune/commit/978bd0e3c19380cbf910e475eafaaf40eeb1f7a1",
"author": {
"name": "Cooper Maruyama",
"email": "me@cooperm.com",
"date": "2026-06-10T17:45:02-07:00",
"username": "czxtm"
},
"committer": {
"name": "Cooper Maruyama",
"email": "me@cooperm.com",
"date": "2026-06-10T17:45:02-07:00",
"username": "czxtm"
},
"added": [
".beads/issues.jsonl"
],
"removed": [],
"modified": [
".gitignore"
]
}
}