Zanyar_98CREAM Finance Liquid Staking TVL
    Updated 2022-09-05
    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