SELECT

trunc(block_timestamp,'day') as date,'Stakewise' as platform,count(distinct tx_hash) as transactions,sum(amount) as eth_amount, count(distinct origin_from_address) as depositors, sum(eth_amount) over (order by date) as cum_eth_amount, sum(depositors) over (order by date) as cum_depositors

FROM ethereum.core.ez_token_transfers

WHERE contract_address = lower('0xFe2e637202056d30016725477c5da089Ab0A043A') AND from_address = '0x0000000000000000000000000000000000000000'

and date >='2023-01-01'

GROUP BY date

), tab2 as (

SELECT

trunc(block_timestamp,'day') as date,'Ankr' as platform,count(distinct tx_hash) as transactions,sum(raw_amount / power(10, 18)) as eth_amount, count(distinct origin_from_address) as depositors, sum(eth_amount) over (order by date) as cum_eth_amount, sum(depositors) over (order by date) as cum_depositors

FROM ethereum.core.ez_token_transfers

WHERE contract_address = lower('0xE95A203B1a91a908F9B9CE46459d101078c2c3cb') AND from_address = '0x0000000000000000000000000000000000000000'

and date >='2023-01-01'

GROUP BY date

), tab3 as (

SELECT

trunc(block_timestamp,'day') as date,'Rocketpool' as platform,count(distinct tx_hash) as transactions,sum(raw_amount / power(10, 18)) as eth_amount, count(distinct origin_from_address) as depositors, sum(eth_amount) over (order by date) as cum_eth_amount, sum(depositors) over (order by date) as cum_depositors

FROM ethereum.core.ez_token_transfers

WHERE contract_address = lower('0xae78736Cd615f374D3085123A210448E74Fc6393') AND from_address = '0x0000000000000000000000000000000000000000'

and date >='2023-01-01'

GROUP BY date

), tab4 as (

SELECT

trunc(block_timestamp,'day') as date,'Lido' as platform,count(distinct tx_hash) as transactions,sum(raw_amount / power(10, 18)) as eth_amount, count(distinct origin_from_address) as depositors, sum(eth_amount) over (order by date) as cum_eth_amount, sum(depositors) over (order by date) as cum_depositors

FROM ethereum.core.ez_token_transfers

WHERE contract_address = lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84') AND from_address = '0x0000000000000000000000000000000000000000'

and date >='2023-01-01'

GROUP BY date

),

tab5 as (

SELECT

trunc(block_timestamp,'day') as date,'Cream Finance' as platform, count(distinct tx_hash) as transactions,sum(raw_amount / power(10, 18)) as eth_amount,

count(distinct origin_from_address) as depositors,sum(eth_amount) over (order by date) as cum_eth_amount, sum(depositors) over (order by date) as cum_depositors

FROM ethereum.core.ez_token_transfers

WHERE (contract_address = lower('0xcBc1065255cBc3aB41a6868c22d1f1C573AB89fd') or contract_address=lower('0x49D72e3973900A195A155a46441F0C08179FdB64')) AND from_address = '0x0000000000000000000000000000000000000000'

and date >='2023-01-01'