headitmanagerwETH Deposit Rate ==> sushi
    Updated 2022-06-14
    with osmosis as (select block_timestamp::date as date,sum(AMOUNT/1e18) as amount
    from osmosis.core.fact_liquidity_provider_actions left outer join osmosis.core.dim_labels
    ON osmosis.core.dim_labels.address = osmosis.core.fact_liquidity_provider_actions.currency
    where( label= 'Wrapped Ethereum' or label = 'Wrapped Ether') and action like 'pool_joined'
    group by date)
    , thorchain as ( select day, SUM(2 * (ASSET_LIQUIDITY * ASSET_PRICE_USD)) as deposit_usd
    from thorchain.daily_pool_stats
    where pool_name like '%ETH%'
    group by day)
    ,sushi as (select sum(eth_value) as amount,ethereum_core.fact_transactions.block_timestamp::date as date from ethereum_core.dim_dex_liquidity_pools
    inner join ethereum_core.fact_transactions
    on ethereum_core.fact_transactions.tx_hash=ethereum_core.dim_dex_liquidity_pools.creation_tx
    where platform='sushiswap' and pool_name like '%ETH%'
    group by date)
    select * from sushi
    Run a query to Download Data