Query editor
with date_series as (selectdayfrom unnest(sequence((timestamp '2024-08-18 00:00:00'),(current_date),interval '1' day)) as t(day)),-- vault_label_json as (select-- http_get('https://raw.githubusercontent.com/euler-xyz/euler-labels/refs/heads/master/1/vaults.json') as eth_json,-- http_get('https://raw.githubusercontent.com/euler-xyz/euler-labels/refs/heads/master/8453/vaults.json') as base_json,-- http_get('https://raw.githubusercontent.com/euler-xyz/euler-labels/refs/heads/master/146/vaults.json') as sonic_json),-- vault_labels as (select-- 'ethereum' as blockchain,-- from_hex(key) as vault,-- json_extract_scalar(value, '$.name') as name,-- json_extract_scalar(value, '$.description') as description,-- json_extract_scalar(value, '$.entity') as entity-- from vault_label_json,-- unnest(try_cast(json_extract(eth_json, '$') as map(varchar, json))) as key_value(key, value)-- union all-- select-- 'base' as blockchain,-- from_hex(key) as vault,-- json_extract_scalar(value, '$.name') as name,-- json_extract_scalar(value, '$.description') as description,-- json_extract_scalar(value, '$.entity') as entity-- from vault_label_json,-- unnest(try_cast(json_extract(base_json, '$') as map(varchar, json))) as key_value(key, value)-- union all-- select-- 'sonic' as blockchain,-- from_hex(key) as vault,-- json_extract_scalar(value, '$.name') as name,-- json_extract_scalar(value, '$.description') as description,-- json_extract_scalar(value, '$.entity') as entity-- from vault_label_json,-- unnest(try_cast(json_extract(sonic_json, '$') as map(varchar, json))) as key_value(key, value)),vault_labels as (selectblockchain,from_hex(vault) as vault,name,description,entityfrom dune."0xpibs".euler_vault_labels),base_assets as (select distinctchain as blockchain,contract_address as vault_address,asset as asset_token,dtoken as debt_token,row_number() over (partition by chain, asset order by evt_block_time) as market_idfrom euler_v2_multichain.evault_evt_evaultcreated),pt_markets as (select distinctblockchain,market,pt