Query editor
withconstants as (select0x18084fba666a33d37592fa2633fd49a74dd93a88 as tbtc_contract,0x2260fac5e5542a773aa44fbcfedf7c193bc2c599 as wbtc_contract,0x3212b29E33587A00FB1C83346f5dBFA69A458923 as imbtc_contract,0x8daebade922df735c38c80c7ebd708af50815faa as tbtc_v1_contract,0x62199B909FB8B8cf870f97BEf2cE6783493c4908 as pbtc_contract,0xeb4c2781e4eba804ce9a9803c67d0893436bb27d as ren_contract,0x8064d9Ae6cDf087b1bcd5BDf3531bD5d8C537a68 as obtc_contract,0xfe18be6b3bd88a2d2a7f928d00292e7a9963cfc6 as sbtc_contract,0x0316EB71485b0Ab14103307bf65a021042c6d380 as hbtc_contract,0x9BE89D2a4cd102D8Fecc6BF9dA793be995C22541 as bbtc_contract,0x66eFF5221ca926636224650Fd3B9c497FF828F7D as multiBTC_contract,0x0000000000000000000000000000000000000000 as null_address),relevant_data as (select value, 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)),tbtc_table as (selectsum(transfer) as tbtcfrom(SELECTsum(cast(value as decimal)) / 1e18 as transferFROMrelevant_data,constantsWHEREcontract_address = constants.tbtc_contractAND "from" = constants.null_addressUNIONSELECTsum(cast(value as decimal)) * -1 / 1e18 as transferFROMrelevant_data,constantsWHEREcontract_address = constants.tbtc_contract