Query editor
WITH deposits AS (SELECTdate_trunc('{{Time interval}}', evt_block_time) as day,t.symbol as token,reserve as contract_address,sum(amount/POW(10,decimals)) as amount,COUNT(DISTINCT onBehalfOf) AS users,COUNT(DISTINCT evt_tx_hash) AS txsFROM aave_v3_ethereum.Pool_evt_Supply depositsLEFT JOIN tokens.erc20 t ON deposits.reserve = t.contract_addressWHERE evt_block_time > now() - interval '{{Trading Num Days}}' DAYGROUP BY 1,2,3),borrows AS (SELECTdate_trunc('{{Time interval}}', evt_block_time) as day,t.symbol as token,reserve as contract_address,sum(amount/POW(10,decimals)) as amount,COUNT(DISTINCT onBehalfOf) AS users,COUNT(DISTINCT evt_tx_hash) AS txsFROM aave_v3_ethereum.Pool_evt_Borrow borrowsLEFT JOIN tokens.erc20 t ON borrows.reserve = t.contract_address AND blockchain = 'ethereum'WHERE evt_block_time > now() - interval '{{Trading Num Days}}' DAYGROUP BY 1,2,3),withdraw AS (SELECTdate_trunc('{{Time interval}}', evt_block_time) as day,t.symbol as token,reserve as contract_address,sum(amount/POW(10,decimals)) as amount,COUNT(DISTINCT user) AS users,COUNT(DISTINCT evt_tx_hash) AS txsFROM aave_v3_ethereum.Pool_evt_Withdraw withdrawLEFT JOIN tokens.erc20 t ON withdraw.reserve = t.contract_address AND blockchain = 'ethereum'WHERE evt_block_time > now() - interval '{{Trading Num Days}}' DAYGROUP BY 1,2,3),repay AS (SELECTdate_trunc('{{Time interval}}', evt_block_time) as day,t.symbol as token,reserve as contract_address,sum(amount/POW(10,decimals)) as amount,COUNT(DISTINCT repayer) AS users,COUNT(DISTINCT evt_tx_hash) AS txsFROM aave_v3_ethereum.Pool_evt_Repay repayLEFT JOIN tokens.erc20 t ON repay.reserve = t.contract_address AND blockchain = 'ethereum'WHERE evt_block_time > now() - interval '{{Trading Num Days}}' DAYGROUP BY 1,2,3),p AS (SELECTdate_trunc('{{Time interval}}', minute) as day,contract_address,