Dune Analytics - Githubissues

neo-empresarial / balancer-bigquery-analysis

Repository for Balancer protocol analysis on Google BigQuery.

0 stars 0 forks source link

Dune Analytics #3

Open Stefenon opened 3 years ago

Stefenon commented 3 years ago

[x] Create revenue breakdown by token and pool;
[x] Analyze how to insert swap fee on Balancer schema;
[x] Add balances.trades to Balancer schema with pool fees;
[x] Fix source breakdown queries (remove having, etc);
[x] Add version breakdown to Revenues dashboard;
[x] Fix balancer.liquidity data loss.

mendesfabio commented 3 years ago

Architect strategy to ETL from BigQuery to Pickle;
Analyze Active vs Lazy LPs.

mendesfabio commented 3 years ago

Misc Tasks

[x] Fix balancer.trades
[x] Fix Growth dashboard
[x] Add Heavy Traders breakdown
[x] Clean dashboards (add disclaimers or remove charts)

Revenues V2

Inputs

[x] Pool address
[x] LP address
[x] Improve UI

Charts

[x] Cumulative revenues,
[x] Pools breakdown
[x] Token breakdown
[x] LP revenues (all pools or specific pool)

mendesfabio commented 3 years ago

Misc Tasks

[ ] Add start and end date to required queries (VSE)
[x] Add stable pools to Balancer Pool queries (VSE)
[x] Fix Balancer Trades PR (we'll need to fix revenues when merged) (FSN)
[x] Fix BAL Liquidity query (FSN)

Balancer Pools Analysis dashboard

[x] Pools table to make it easier to input a poolId (FSN)
[x] Volume over time (VSE)
[x] TVL over time (FSN)
[x] Fees over time (VSE)
[x] Avg trade size (VSE)
[x] Source breakdown (VSE)
[x] Current # LPs (VSE)
[ ] New/Old LPs/Traders over time (FSN)