DATE_TRUNC('week', day) AS week,

AVG(total_value_pooled/2) AS Rune_pooled,

AVG(total_value_pooled_usd/2) AS Rune_pooled_usd,

AVG(total_value_bonded) AS Rune_bonded,

AVG(total_value_bonded_usd) AS Rune_bonded_usd,

AVG(total_value_locked) AS avg_total_value_locked,

AVG(total_value_locked_usd) AS avg_total_value_locked_usd,

67 AS ratio_line -- Ligne fixe à 0.67

FROM thorchain.defi.fact_daily_tvl

GROUP BY DATE_TRUNC('week', day)

ORDER BY week ASC;