Dune — on-chain analytics is SQL over a decoded ledger
Dune turns raw chain data into SQL-queryable tables and shareable dashboards, and the real skill is not the query but knowing which decoded table answers the question without double-counting.
Not yet scoped.
Why
The PoC builds one dashboard — protocol volume, unique users, fee revenue — and documents the join and dedup decisions that separate a correct metric from a plausible-looking wrong one.
How it works
Not yet built.
Where it lands in Jayverse
Verex: document the join and dedup decision behind every volume, open-interest or fee metric before publishing it on gitboard. Which event table, how duplicate fills or cancels are handled — don't ship a plausible-looking number without that note.
gitboard: keep an internal decoded-table equivalent if Verex or DeFi activity is ever also published on Dune. So the two numbers can be reconciled; a public number that can't be traced back to Jayverse's own indexer is unverifiable.
Key expressions
Words and phrases from this page worth keeping, with the Korean meaning and the sentence they come from.
Expression
뜻 · 쓰이는 자리
decoded ledger
디코딩된(해석된) 원장 · 원시 체인 데이터를 사람이 읽을 수 있는 표 형태로 변환한 것 · "SQL over a decoded ledger"
double-counting
중복 집계 · 같은 값을 두 번 세어 지표가 부풀려지는 오류 · "answers the question without double-counting"
dedup
중복 제거 · 데이터에서 겹치는 항목을 걸러내는 작업 · "documents the join and dedup decisions"
plausible-looking
그럴듯해 보이는(하지만 틀린) · 얼핏 맞아 보이지만 실제로는 잘못된 결과 · "separate a correct metric from a plausible-looking wrong one"
shareable dashboard
공유 가능한 대시보드 · 여러 사람이 함께 볼 수 있도록 게시된 시각화 화면 · "SQL-queryable tables and shareable dashboards"