Zanyar_98CREAM Finance Liquid Staking TVL
Updated 2022-09-05
9
1
2
3
4
5
6
7
8
›
⌄
WITH CURRENT_ETH_PRICE AS (
SELECT PRICE FROM ethereum.core.fact_hourly_token_prices
WHERE SYMBOL= 'WETH' AND TOKEN_ADDRESS = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' ORDER BY HOUR DESC LIMIT 1
)
SELECT SUM(AMOUNT) "CREAM Finance Liquid Staking TVL (ETH)", (SUM(AMOUNT) * (SELECT PRICE FROM CURRENT_ETH_PRICE)) "CREAM Finance Liquid Staking TVL ($)"
FROM ethereum.core.ez_eth_transfers
WHERE ETH_TO_ADDRESS IN('0xcbc1065255cbc3ab41a6868c22d1f1c573ab89fd', '0x49d72e3973900a195a155a46441f0c08179fdb64')
Run a query to Download Data