Query editor
WITH daily_volume AS (SELECTDATE_TRUNC('day', block_time) AS day,SUM(CASEWHEN token_bought_mint_address = 'Ex5DaKYMCN6QWFA4n67TmMwsH8MJV68RX6YXTmVM532C' THEN token_bought_amountWHEN token_sold_mint_address = 'Ex5DaKYMCN6QWFA4n67TmMwsH8MJV68RX6YXTmVM532C' THEN token_sold_amountELSE 0END) AS daily_trading_volumeFROM dex_solana.tradesWHERE (token_bought_mint_address = 'Ex5DaKYMCN6QWFA4n67TmMwsH8MJV68RX6YXTmVM532C'OR token_sold_mint_address = 'Ex5DaKYMCN6QWFA4n67TmMwsH8MJV68RX6YXTmVM532C')AND block_time >= CURRENT_DATE - INTERVAL '90' dayGROUP BY DATE_TRUNC('day', block_time)),circulating_supply AS (SELECTSUM(CASEWHEN from_owner = '11111111111111111111111111111111' THEN amountELSE 0END) -SUM(CASEWHEN to_owner = '11111111111111111111111111111111' THEN amountELSE 0END) AS total_supplyFROM tokens_solana.transfersWHERE token_mint_address = 'Ex5DaKYMCN6QWFA4n67TmMwsH8MJV68RX6YXTmVM532C')SELECTdv.day,dv.daily_trading_volume,cs.total_supply AS circulating_supply,(dv.daily_trading_volume / cs.total_supply) * 100 AS pct_of_circulating_supplyFROM daily_volume dvCROSS JOIN circulating_supply csORDER BY dv.day DESC