Query editor
WITH meth_t_1_l2 AS(SELECTcontract_address,SUM(amount) as meth_amtFROM(SELECTtr."from" AS address,tr.contract_address,-(tr.value/1e18) AS amount -- assuming 18 decimalsFROM erc20_mantle.evt_transfer trWHERE "from" != 0x0000000000000000000000000000000000000000 -- exclude mint/burn addressesAND contract_address = 0xcDA86A272531e8640cD7F1a92c01839911B90bb0AND DATE_TRUNC('day', evt_block_time) < CURRENT_TIMESTAMP - INTERVAL '1' DAY-- contract_address of the erc20 token-- AND DATE_TRUNC('day', evt_block_time) < DATE('2024-09-04')UNION ALLSELECTtr."to" AS address,tr.contract_address,(tr.value/1e18) AS amount -- assuming 18 decimalsFROM erc20_mantle.evt_transfer trWHERE "to" != 0x0000000000000000000000000000000000000000 -- exclude mint/burn addressesAND contract_address = 0xcDA86A272531e8640cD7F1a92c01839911B90bb0AND DATE_TRUNC('day', evt_block_time) < CURRENT_TIMESTAMP - INTERVAL '1' DAY -- contract_address of the erc20 token-- AND DATE_TRUNC('day', evt_block_time) < DATE('2024-09-04')) xGROUP BY 1)SELECTt1.meth_amt AS "mETH Amt (L2)",round(t1.meth_amt * t2.price) as FDVFROM meth_t_1_l2 t1JOIN prices.usd_latest t2 on t1.contract_address = t2.contract_addressGROUP BY 1,2