date_trunc('day', block_timestamp) as date,

SUM(CASE WHEN block_timestamp::date >= current_date - interval '7 days' THEN SUPPLIED_USD ELSE 0 END) AS total_deposits_7_days,

AVG(CASE WHEN block_timestamp::date >= current_date - interval '7 days' THEN SUPPLIED_USD ELSE NULL END) AS average_deposits_7_days,

COUNT(DISTINCT CASE WHEN block_timestamp::date >= current_date - interval '7 days' THEN TX_HASH ELSE NULL END) AS transactions_7_days,

COUNT(DISTINCT CASE WHEN block_timestamp::date >= current_date - interval '7 days' THEN DEPOSITOR_ADDRESS ELSE NULL END) AS depositors_7_days,

AVG(CASE WHEN block_timestamp::date >= current_date - interval '7 days' THEN token_price ELSE NULL END) AS token_price_7_days,

SUM(CASE WHEN block_timestamp::date >= current_date - interval '30 days' THEN SUPPLIED_USD ELSE 0 END) AS total_deposits_30_days,

AVG(CASE WHEN block_timestamp::date >= current_date - interval '30 days' THEN SUPPLIED_USD ELSE NULL END) AS average_deposits_30_days,

COUNT(DISTINCT CASE WHEN block_timestamp::date >= current_date - interval '30 days' THEN TX_HASH ELSE NULL END) AS transactions_30_days,

COUNT(DISTINCT CASE WHEN block_timestamp::date >= current_date - interval '30 days' THEN DEPOSITOR_ADDRESS ELSE NULL END) AS depositors_30_days,

AVG(CASE WHEN block_timestamp::date >= current_date - interval '30 days' THEN token_price ELSE NULL END) AS token_price_30_days,

SUM(CASE WHEN block_timestamp::date >= current_date - interval '60 days' THEN SUPPLIED_USD ELSE 0 END) AS total_deposits_60_days,

AVG(CASE WHEN block_timestamp::date >= current_date - interval '60 days' THEN SUPPLIED_USD ELSE NULL END) AS average_deposits_60_days,

COUNT(DISTINCT CASE WHEN block_timestamp::date >= current_date - interval '60 days' THEN TX_HASH ELSE NULL END) AS transactions_60_days,

COUNT(DISTINCT CASE WHEN block_timestamp::date >= current_date - interval '60 days' THEN DEPOSITOR_ADDRESS ELSE NULL END) AS depositors_60_days,

AVG(CASE WHEN block_timestamp::date >= current_date - interval '60 days' THEN token_price ELSE NULL END) AS token_price_60_days,

SUM(CASE WHEN block_timestamp::date >= current_date - interval '90 days' THEN SUPPLIED_USD ELSE 0 END) AS total_deposits_90_days,

AVG(CASE WHEN block_timestamp::date >= current_date - interval '90 days' THEN SUPPLIED_USD ELSE NULL END) AS average_deposits_90_days,

COUNT(DISTINCT CASE WHEN block_timestamp::date >= current_date - interval '90 days' THEN TX_HASH ELSE NULL END) AS transactions_90_days,

COUNT(DISTINCT CASE WHEN block_timestamp::date >= current_date - interval '90 days' THEN DEPOSITOR_ADDRESS ELSE NULL END) AS depositors_90_days,

AVG(CASE WHEN block_timestamp::date >= current_date - interval '90 days' THEN token_price ELSE NULL END) AS token_price_90_days

FROM ethereum.aave.ez_deposits

WHERE block_timestamp::date >= '2023-01-01'

AND SYMBOL = 'AAVE'

GROUP BY 1;