Query editor
with nike as (select date_trunc('month', block_time) as month,count(usd_amount) as total_txns, sum(usd_amount) as total_volume from nft.tradeswhere nft_contract_address in('\x86825dFCa7A6224cfBd2DA48e85DF2fc3Aa7C4B1', '\xF661D58cfE893993b11D53d11148c4650590C692', '\x9A06Ef3a841316a9e2c1C93B9c21a7342abE484F','\x212590B0DAc9502e0591b79db4ceDeb6356dcc36', '\x348FC118bcC65a92dC033A951aF153d14D945312', '\x49cF6f5d44E70224e2E23fDcdd2C053F30aDA28B','\x6d4bbC0387dD4759EEe30f6A482AC6dC2Df3Facf', '\x9930929903f9C6C83D9E7c70D058d03c376A8337', '\xb7bE4001BfF2c5F4a61dd2435E4c9A19D8d12343','\xd3f69F10532457D35188895fEaA4C20B730EDe88', '\xc541fC1Aa62384AB7994268883f80Ef92AAc6399', '\x0972290a80333D19c6703073c3E57134A4cA0127','\xAE3d8D68B4F6c3Ee784b2b0669885a315BA77C08', '\x1bB6edF7b129967d512086FbDf489ED659580916')group by 1)select month, total_txns, total_volume from nikewhere month > now() - interval '9 months'order by month asc