Query editor
with deposits as (SELECTDATE_TRUNC('{{Time interval}}', dep.call_block_time) as day,CASEWHEN aa.token_mint_address = '3NZ9JMVBmGAqocybic2c7LQCJScmgsAZ6vQqTDzcqmJh' then 'WBTC'WHEN aa.token_mint_address = 'bSo13r4TkiE4KumL71LsHTPpL2euBYLFx6h9HP3piy1' then 'bSOL'ELSE tk.symbolEND AS symbol,sum(dep.amount/(pow(10,COALESCE(tk.decimals,8))))*AVG(COALESCE(p.price,dp.price)) as usd_amount_deposited,sum(dep.amount/(pow(10,COALESCE(tk.decimals,8)))) as amount_depositedFROM drift_v2_solana.drift_call_deposit depLEFT JOIN solana_utils.token_accounts aa ON aa.address = dep.account_userTokenAccountLEFT JOIN tokens_solana.fungible tk ON tk.token_mint_address = aa.token_mint_addressLEFT JOIN prices.usd p ON p.blockchain = 'solana' and toBase58(contract_address) = aa.token_mint_addressand date_trunc('{{Time interval}}', dep.call_block_time) = date_trunc('{{Time interval}}', p.minute)LEFT JOIN (SELECTday,token_mint_address,avg(median_price) as priceFROM dune.dune.result_dex_prices_solanaGROUP BY 1,2) dp ON dp.token_mint_address = aa.token_mint_address and date_trunc('day', dep.call_block_time) = dp.dayWHERE aa.token_mint_address is not nullAND dep.marketIndex is not nullAND date_trunc('{{Time interval}}', dep.call_block_time) >= date_trunc('{{Time interval}}', NOW())- interval '{{Trading Num Days}}' DAYgroup by 1,2)SELECTday,symbol,usd_amount_deposited,amount_deposited,SUM(usd_amount_deposited) OVER (PARTITION BY symbol ORDER BY day) AS cum_volumeFROM depositsORDER BY 1 DESC