Query editor
withconstants as (select0x18084fba666a33d37592fa2633fd49a74dd93a88 as tbtc_contract, -- label: tBTC, contract decimals: 180x2260fac5e5542a773aa44fbcfedf7c193bc2c599 as wbtc_contract, -- label: wBTC, contract decimals: 80x3212b29E33587A00FB1C83346f5dBFA69A458923 as imbtc_contract, -- label: imBTC, contract decimals: 80x8daebade922df735c38c80c7ebd708af50815faa as tbtc_v1_contract, -- label: tBTC v1, contract decimals: 180x62199B909FB8B8cf870f97BEf2cE6783493c4908 as pbtc_contract, -- label: pBTC, contract decimals: 180xeb4c2781e4eba804ce9a9803c67d0893436bb27d as ren_contract, -- label: renBTC, contract decimals: 80x8064d9Ae6cDf087b1bcd5BDf3531bD5d8C537a68 as obtc_contract, -- label: oBTC, contract decimals: 180xfe18be6b3bd88a2d2a7f928d00292e7a9963cfc6 as sbtc_contract, -- label: sBTC, contract decimals: 180x0316EB71485b0Ab14103307bf65a021042c6d380 as hbtc_contract, -- label: hBTC, contract decimals: 180x9BE89D2a4cd102D8Fecc6BF9dA793be995C22541 as bbtc_contract, -- label: bBTC, contract decimals: 80x66eFF5221ca926636224650Fd3B9c497FF828F7D as multiBTC_contract, -- label: multiBTC, contract decimals: 80x0000000000000000000000000000000000000000 as null_address),relevant_data as (selectvalue as value,evt_block_time,contract_address,"from","to"FROMerc20_ethereum.evt_Transfer,constantswherecontract_address in (constants.tbtc_contract,constants.wbtc_contract,constants.imbtc_contract,constants.tbtc_v1_contract,constants.pbtc_contract,constants.ren_contract,constants.obtc_contract,constants.sbtc_contract,constants.hbtc_contract,constants.bbtc_contract,constants.multiBTC_contract) and ("from" = constants.null_addressor "to" = constants.null_address)),days AS (SELECTDAYFROMunnest (sequence(date('2018-11-23'), -- creation of wbtc Nov-24-2018date(current_date),interval '1' day)) as DAYS (DAY)),adjusted_value_data AS (