Query editor
with index as (select *from dune.pibbles.result_euler_finance_index),constants as (select365.2425 * 86400 as seconds,1e27 as one,1e4 as config_scale),vault as (selectindex.day,index.blockchain,index.vault_address,index.asset_token,index.name,index.debt_token,index.price,sum(coalesce(fee_amount, 0)) as fee_amount,sum(sum(fee_amount)) over (partition by index.blockchain, index.vault_address order by index.day) as fee_amount_cumulative,sum(coalesce(available_amount, 0)) as available_amount,sum(sum(available_amount)) over (partition by index.blockchain, index.vault_address order by index.day) as available_amount_cumulative,sum(coalesce(available_amount, 0) + coalesce(borrow_amount, 0)) as supplied_amount,sum(sum(available_amount + coalesce(borrow_amount, 0))) over (partition by index.blockchain, index.vault_address order by index.day) as supplied_amount_cumulative,sum(coalesce(interest_amount / power(10, 27), 0)) as interest_amount,sum(sum(interest_amount / power(10, 27))) over (partition by index.blockchain, index.vault_address order by index.day) as interest_amount_cumulative,sum(coalesce(borrow_amount, 0)) as borrow_amount,sum(sum(coalesce(borrow_amount, 0))) over (partition by index.blockchain, index.vault_address order by index.day) as borrow_amount_cumulative,sum(sum(coalesce(borrow_amount, 0))) over (partition by index.blockchain, index.vault_address order by index.day) / sum(sum(coalesce(available_amount, 0) + coalesce(borrow_amount, 0))) over (partition by index.blockchain, index.vault_address order by index.day) as utilisation,sum(coalesce(lp_amount, 0)) as lp_amount,sum(sum(lp_amount)) over (partition by index.blockchain, index.vault_address order by index.day) as lp_amount_cumulative,index.price * sum(fee_amount) as fee_amount_usd,index.price * sum(sum(fee_amount)) over (partition by index.blockchain, index.vault_address order by index.day) as fee_amount_cumulative_usd,index.price * sum(coalesce(available_amount, 0)) as available_amount_usd,index.price * sum(sum(available_amount)) over (partition by index.blockchain, index.vault_address order by index.day) as available_amount_cumulative_usd,index.price * sum(coalesce(available_amount, 0) + coalesce(borrow_amount, 0)) as supplied_amount_usd,index.price * sum(sum(available_amount + coalesce(borrow_amount, 0))) over (partition by index.blockchain, index.vault_address order by index.day) as supplied_amount_cumulative_usd,index.price * sum(coalesce(interest_amount / power(10, 27), 0)) as interest_amount_usd,index.price * sum(sum(interest_amount / power(10, 27))) over (partition by index.blockchain, index.vault_address order by index.day) as interest_amount_cumulative_usd,index.price * sum(coalesce(borrow_amount, 0)) as borrow_amount_usd,index.price * sum(sum(borrow_amount)) over (partition by index.blockchain, index.vault_address order by index.day) as borrow_amount_cumulative_usdfrom indexleft join (selectdate_trunc('day', evt_block_time) as day,chain as blockchain,contract_address as vault_address,accumulatedFees as fee_amount_cumulative,case when accumulatedFees = 0 then 0 else cast(accumulatedFees as double) - lag(cast(accumulatedFees as double)) ignore nulls over (partition by chain, contract_address order by evt_block_time) end as fee_amount,cash as available_amount_cumulative,cast(cash as double) - lag(cast(cash as double)) ignore nulls over (partition by chain, contract_address order by evt_block_time) as available_amount,interestAccumulator as interest_amount_cumulative,cast(interestAccumulator as double) - lag(cast(interestAccumulator as double)) ignore nulls over (partition by chain, contract_address order by evt_block_time) as interest_amount,totalBorrows as borrow_amount_cumulative,cast(totalBorrows as double) - lag(cast(totalBorrows as double)) ignore nulls over (partition by chain, contract_address order by evt_block_time) as borrow_amount,totalShares as lp_amount_cumulative,cast(totalShares as double) - lag(cast(totalShares as double)) ignore nulls over (partition by chain, contract_address order by evt_block_time) as lp_amountfrom euler_v2_multichain.evault_evt_vaultstatus) vaulton index.day = vault.dayand index.blockchain = vault.blockchainand index.vault_address = vault.vault_addressgroup by 1, 2, 3, 4, 5, 6, 7),