Query editor
with--this is all to get the contract_address and blockchain of the inputted paramsselected_tokens as (SELECTsymbol, contract_address, blockchain, decimalsFROM (SELECTupper(tk.symbol) as symbol, tk.contract_address, tk.blockchain, tk.decimals, COALESCE(count(*),0) as transfersFROM tokens.erc20 tkLEFT JOIN evms.erc20_transfers tr ON tk.blockchain = tr.blockchainAND tk.contract_address = tr.contract_addressAND tr.evt_block_time > now() - interval '5' day --should be good enough time filterAND tr.blockchain = '{{3. Blockchain}}'WHERE ('{{1. Token Symbol}}' = upper(tk.symbol) OR try(from_hex('{{2. Token Contract}}')) = tk.contract_address)and tk.blockchain = '{{3. Blockchain}}'group by 1,2,3,4order by count(*) desclimit 1)UNION ALLSELECTnull as symbol, from_hex(trim(c.address)) as contract_address, '{{3. Blockchain}}' as blockchain, 18 as decimalsFROM unnest(split('{{2. Token Contract}}',',')) as c(address)WHERE try(from_hex(trim(c.address))) is not nulland lower(c.address) != 'none'and try(from_hex(trim(c.address))) not in (SELECT distinct contract_address FROM tokens.erc20))--now we grab balances and latest transfers for a set of tokens, erc20_balances as (WITH erc20_in as (SELECTto as address, SUM(tr.value/pow(10,tk.decimals)) as tokens_funded, SUM((case when tr.evt_block_time >= now() - interval '{{4. Days}}' day then tr.value else cast(0 as uint256) end)/pow(10,tk.decimals)) as tokens_funded_daysFROM evms.erc20_transfers trJOIN selected_tokens tk ON tk.blockchain = tr.blockchain and tk.contract_address = tr.contract_addressGROUP BY 1),erc20_out as (SELECT"from" as address, SUM(tr.value/pow(10,tk.decimals)) as tokens_spent, SUM((case when tr.evt_block_time >= now() - interval '{{4. Days}}' day then tr.value else cast(0 as uint256) end)/pow(10,tk.decimals)) as tokens_spent_daysFROM evms.erc20_transfers trJOIN selected_tokens tk ON tk.blockchain = tr.blockchain and tk.contract_address = tr.contract_addressGROUP BY 1)SELECT