Query editor
WITH daily_trades AS (SELECTblock_date,SUM(CASEWHEN token_bought_mint_address = 'Ex5DaKYMCN6QWFA4n67TmMwsH8MJV68RX6YXTmVM532C'THEN token_bought_amountELSE 0END) + SUM(CASEWHEN token_sold_mint_address = 'Ex5DaKYMCN6QWFA4n67TmMwsH8MJV68RX6YXTmVM532C'THEN token_sold_amountELSE 0END) as daily_volumeFROM dex_solana.tradesWHERE (token_bought_mint_address = 'Ex5DaKYMCN6QWFA4n67TmMwsH8MJV68RX6YXTmVM532C'OR token_sold_mint_address = 'Ex5DaKYMCN6QWFA4n67TmMwsH8MJV68RX6YXTmVM532C')AND block_time >= CURRENT_DATE - INTERVAL '90' DAYGROUP BY block_date),token_transfers AS (SELECTfrom_token_account,to_token_account,amountFROM tokens_solana.transfersWHERE token_mint_address = 'Ex5DaKYMCN6QWFA4n67TmMwsH8MJV68RX6YXTmVM532C'AND block_time >= TIMESTAMP '2020-01-01'),supply_calc AS (SELECTSUM(CASEWHEN from_token_account IS NULL OR from_token_account = ''THEN CAST(amount AS double)ELSE 0END) - SUM(CASEWHEN to_token_account IS NULL OR to_token_account = ''THEN CAST(amount AS double)ELSE 0END) as circulating_supplyFROM token_transfers)SELECTdt.block_date,dt.daily_volume,sc.circulating_supply,(dt.daily_volume / sc.circulating_supply) * 100 as volume_pct_of_supplyFROM daily_trades dtCROSS JOIN supply_calc scORDER BY dt.block_date DESC