-- -- 总存入量
-- SELECT
-- SUM(AMOUNT) AS total_deposit_amount,
-- SUM(AMOUNT_USD) AS total_deposit_amount_usd
-- FROM
-- base.defi.ez_lending_deposits
-- WHERE
-- PLATFORM = 'Moonwell'
-- AND TOKEN_SYMBOL = 'cbBTC';
-- 每日新增存入量
SELECT
DATE(BLOCK_TIMESTAMP) AS date,
SUM(AMOUNT) AS daily_deposit_amount,
SUM(AMOUNT_USD) AS daily_deposit_amount_usd
FROM
base.defi.ez_lending_deposits
WHERE
PLATFORM = 'Moonwell'
AND TOKEN_SYMBOL = 'cbBTC'
GROUP BY
DATE(BLOCK_TIMESTAMP)
ORDER BY
date;