mz0111KASHI 1
Updated 2022-12-02
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
date_trunc('day', BLOCK_TIMESTAMP) AS date ,
Count(TX_HASH) AS "deposit number",
SUM(ASSET_AMOUNT_USD) AS "volume",
SYMBOL
FROM crosschain.defi.ez_lending
WHERE BLOCKCHAIN = 'ethereum'
AND symbol in ('USDC', 'USDT', 'DAI', 'UST')
AND date >= CURRENT_DATE - 90
AND ACTION = 'Deposit'
group by 1,4
order by 1
Run a query to Download Data