Carl Cervone

@ravenac95 Nutrina is still awaiting auth per latest on their GitHub issue

Yes, I've reviewed and this covers everything. Let's do it.

first major round of model renames and moves #1344

I've currently generated the first 8 that have already been reviewed and accepted by badgeholders [here](https://docs.google.com/document/d/1hZ35HC_FRwX5hhNmskRpA3AKSop0A9wDj6JEtz3K3zY/edit?usp=sharing). I'm going to add this as a blogpost that we can update as new...

Sent as a CSV file powered by this query: ``` SELECT project_name, * EXCEPT (project_id, project_name) FROM `oso.rf4_impact_metrics_by_project` WHERE trusted_transaction_share > 0.05 and project_name != 'op' ORDER by trusted_recurring_users DESC...

FYI, I created a hacky script to do some of these checks for the BuidlBox dataset. It worked pretty well (scanned about 8K projects). https://github.com/opensource-observer/insights/blob/main/scripts/github.py

For now at least, we need to take a final version of [this model](https://github.com/opensource-observer/oso/blob/main/warehouse/dbt/models/marts/superchain/rf4_repo_stats_by_project.sql) and adding a field [in here](https://github.com/opensource-observer/oso/blob/main/warehouse/dbt/models/marts/superchain/rf4_project_verification.sql)

Deprioritizing. I spent some time trying to get it from the various sites: - https://gap.karmahq.xyz/arbitrum - https://www.arbitrumhub.io/grant-hub/foundation-grants/ - https://arbitrumfoundation.notion.site/53ad99f665d946adb58bf92e82438fd5?v=efcd2d955fa54bcfaabaa46812732206 - https://new.questbook.app/dashboard/?grantId=0x4494cf7375aa61c9a483259737c14b3dba6c04e6&chainId=10&role=community&proposalId=0x62b - https://app.grantships.fun/projects ... But data is not straightforward to...

Limiting this to ~150 so projects on Optimism for now

@ryscheng here's what I've done: 1. Manually linked the Github repos for 177 of the top Optimism projects included in [this list](https://github.com/duneanalytics/spellbook/blob/main/models/contracts/optimism/contracts_optimism_contract_creator_address_list.sql) -- note, this is the source of the...