campسپردهPOLYGON
Updated 2022-07-13Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select --block_timestamp::date as date,
symbol,
count(distinct tx_hash) as transaction,
count(distinct DEPOSITOR) as depositors,
sum(amount) as amount,
sum(AMOUNT_USD) as amount_usd
from flipside_prod_db.crosschain.ez_lending
where symbol in ('USDC','USDT','USDN','DAI','UST','FEI','FRAX','BUSD','TUSD','sUSD') and block_timestamp::date<='2022-07-11' and block_timestamp::date>='2022-06-06'
and PLATFORM='sushi' and action = 'Deposit' and BLOCKCHAIN='polygon'
group by 1--,2
order by 1,2 asc
Run a query to Download Data