Query editor
WITH token_contract_addresses (address) AS (VALUES(TRY_CAST('8bdhP1UQMevciC9oJ7NrvgDfoW8XPXPfbkkm6vKtMS7N' AS VARCHAR)),(TRY_CAST('CnMm4mcDchmrckNZQH2SNW3bQjPYfgqytvKM2ZGyB6nd' AS VARCHAR)),(TRY_CAST('6qFgkbgwLsNyyefumvLhdnUk6LfxjaY3yAPQHHZk8CCw' AS VARCHAR)),(TRY_CAST('GfEcXBNQncS9EYQFtv9o2ZdUT7EG3kpsWENtkQMFyBeG' AS VARCHAR)),(TRY_CAST('8hrZax9eVqdLB1duN2fJ3ji4FwbddPsb96uauEMroBm8' AS VARCHAR))),price_info AS (SELECTcontract_address,symbol,price,ROW_NUMBER() OVER (PARTITION BY contract_address ORDER BY hour DESC) as rnFROM dex_solana.price_hourWHERE contract_address IN (SELECT address FROM token_contract_addresses)),latest_price_info AS (SELECTcontract_address,symbol,priceFROM price_infoWHERE rn = 1),supply_info AS (SELECTtoken_mint_address,SUM(token_balance) as supplyFROM solana_utils.latest_balancesWHERE token_mint_address IN (SELECT address FROM token_contract_addresses)GROUP BY token_mint_address),dex_trades AS (SELECTtoken_bought_mint_address AS contract_address,DATE_TRUNC('day', tr.block_time) AS day,tr.block_time,tr.amount_usd AS volume_usd,trader_idFROM dex_solana.trades trINNER JOIN token_contract_addresses tc ON tc.address = tr.token_bought_mint_addressWHERE tr.block_time >= NOW() - INTERVAL '1' DAYUNION ALLSELECTtoken_sold_mint_address AS contract_address,DATE_TRUNC('day', tr.block_time) AS day,tr.block_time,tr.amount_usd AS volume_usd,trader_idFROM dex_solana.trades trINNER JOIN token_contract_addresses tc ON tc.address = tr.token_sold_mint_addressWHERE tr.block_time >= NOW() - INTERVAL '1' DAY),trade_metrics AS (SELECTcontract_address,COUNT(*) AS num_trades,COUNT(DISTINCT trader_id) AS num_traders,SUM(volume_usd) AS volume_usd,