Carl Cervone

Two blockers: - https://github.com/voteagora/agora-next/issues/556#issuecomment-2407252522 - won't have actual attestations flowing until after Oct 14

Included here with initial ~60 attestations that meet requirements: https://github.com/opensource-observer/insights/pull/60

Longlist created via this query: ```sql select project_name, array_agg(event_source) as chains, sum(transaction_count_6_months) as sum_transaction_count_6_months, sum(active_contract_count_90_days) as sum_active_contract_count, max(address_count_90_days) as max_address_count_90_days from `opensource-observer.oso.onchain_metrics_by_project_v1` group by 1 order by 3 desc ```

Shortlist: - layer-zero - layer3xyz - worldcoin - stargate-finance - 0xproject - velodrome - op - holograph - axelar - synapse - synthetix - kwenta - thales - fraxfinance -...

Sunny Awards [post](https://docs.google.com/document/d/1FIcfAcr8eoUsdhA99v3KpIQc435O6z0tj6kRfUIeY18/edit) Draft list of [metrics](https://docs.google.com/spreadsheets/d/1GhhpL4ItIRLNBAkUmUHT0aTD9lSSNDvoPjEPIaN5S4k/edit?gid=0#gid=0)

Latest list of potential metrics https://docs.google.com/spreadsheets/d/1pqPgr1jJk8_5ILpkAaZ7vr_ZKjkm5hzMuszzNKSqRhU/edit?usp=sharing

Updated requirements here: https://docs.google.com/document/d/1gzs6ps2be-gaEmnkNWu5j0gfYAUByfet_Lc-MF4nQVY/edit?usp=sharing

update: this will now be satisfied via a static CSV / JSON

API endpoint: ``` curl 'https://ezrf-impact.vercel.app/api/trpc/projects.list?input=%7B%22json%22%3A%7B%22limit%22%3A1000%2C%22cursor%22%3A0%7D%7D' \ -H 'content-type: application/json' \ -H 'round-id: the-sunnys' | pbcopy ```

All the analysis scripts are in the Insights repo. Here's a [write-up](https://docs.google.com/document/d/1W1lMqPQNpBp96Kf_k64-pY5CJflzQEW-xOd2K0eKsLE/edit?usp=sharing)