Query editor
/* Success! If you're still running into issues, check out https://dune.com/docs/query/syntax-differences/ or reach out in the #dune-sql Discord channel. */SELECTblock_time,sell_token,buy_token,units_sold,units_bought,CAST(usd_value AS DOUBLE) as usd_value,fee,fee_usd,CONCAT('<a href="https://etherscan.io/tx/',cast(tx_hash as varchar),'" target="_blank">',cast(tx_hash as varchar),'</a>') AS transactionFROMcow_protocol_{{blockchain}}.tradesWHEREblock_time BETWEEN timestamp '2025-06-15' AND timestamp '2025-07-31'ORDER BYblock_time DESC