Query editor
WITH combo_eth_erc_txs AS (SELECT *FROM dune.coldfire_team.result_base_bridge_deposit_withdrawal_transactions_eth_erc_20_s_w_usd_value)SELECTdate_trunc('day', block_time) as "date", direction, SUM(amt_usd) AS sum_usdFROM combo_eth_erc_txsWHERE block_time > timestamp '2023-07-29 00:00'GROUP BY 1,2ORDER BY "date" ASC