headitmanagerwETH Deposit Rate ==> sushi
Updated 2022-06-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
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