SELECT

DATE(block_timestamp) AS date,

COUNT(proposal_id) AS proposals,

SUM(amount / POWER(10, 6)) AS total_deposited -- Assuming 6 as a placeholder for the decimal value

FROM

axelar.gov.fact_governance_proposal_deposits

WHERE

block_timestamp >= DATEADD(year, -10, CURRENT_TIMESTAMP())

GROUP BY

DATE(block_timestamp)

),

staking_reward_activity AS (

SELECT

DATE(block_timestamp) AS date,

COUNT(tx_id) AS reward_claims,

SUM(amount / POWER(10, 6)) AS total_rewards -- Assuming 6 as a placeholder for the decimal value

FROM

axelar.gov.fact_staking_rewards

WHERE

block_timestamp >= DATEADD(year, -10, CURRENT_TIMESTAMP())

GROUP BY

DATE(block_timestamp)

),

combined_activity AS (

SELECT

pa.date,

pa.proposals AS daily_proposals,

pa.total_deposited AS daily_deposit_amount,

COALESCE(sra.reward_claims, 0) AS daily_reward_claims,

COALESCE(sra.total_rewards, 0) AS daily_reward_amount

FROM

proposal_activity pa

LEFT JOIN

staking_reward_activity sra ON pa.date = sra.date