Query editor
with--this is all to get the contract_address and blockchain of the inputted paramsselected_tokens as (SELECTname, contract_address, blockchain, standardFROM (SELECTCOALESCE(upper(tk.name), upper(tk.symbol)) as name, tk.contract_address, tk.blockchain, tk.standard, sum(COALESCE(amount_usd,0)) as trade_valueFROM tokens.nft tkLEFT JOIN nft.trades trd ON tk.blockchain = trd.blockchainAND tk.contract_address = trd.nft_contract_addressAND trd.block_time > now() - interval '5' day --should be good enough time filterAND trd.blockchain = '{{3. Blockchain}}'WHERE('{{1. NFT Collection Name}}' = COALESCE(upper(tk.name), upper(tk.symbol))ORtry(from_hex('{{2. NFT Contract}}')) = tk.contract_address)and tk.blockchain = '{{3. Blockchain}}'group by 1,2,3,4order by count(*) desclimit 1)UNION ALLSELECTnull as name, from_hex(trim(c.address)) as contract_address, '{{3. Blockchain}}' as blockchain, case when (SELECt distinct contract_address FROM nft.transfersWHERE blockchain = '{{3. Blockchain}}'and contract_address = from_hex(trim(c.address))and token_standard = 'erc1155') is not nullthen 'erc1155'else 'erc721'end as standardFROM unnest(split('{{2. NFT 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.nft))--now we grab balances and latest transfers for a set of tokens, nft_balances as (WITH nft_in as (SELECTto as address, sum(amount) as tokens_funded, SUM(case when tr.block_time >= now() - interval '{{4. Days}}' day then amount else cast(0 as uint256) end) as tokens_funded_daysFROM nft.transfers trJOIN selected_tokens tk ON tk.blockchain = tr.blockchain and tk.contract_address = tr.contract_addressGROUP BY 1),