Query editor
-- Fluid LaaS daily diagnostic: previous full UTC day USDC<->USDT swap volume, all Solana venues-- source: dex_solana.trades. Sep 28 2026: trailing-24h caught Dune spellbook lag (half a day missing) -> full UTC day + last_trade freshness gate.selectproject || ' v' || cast(version as varchar) as venue,sum(amount_usd) as volume_usd,count(*) as fills,max(block_time) as last_tradefrom dex_solana.tradeswhere block_time >= date_trunc('day', now()) - interval '1' dayand block_time < date_trunc('day', now())and ((token_bought_mint_address = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'and token_sold_mint_address = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB')or(token_sold_mint_address = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'and token_bought_mint_address = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'))group by 1order by 2 desc