Query editor
-- Mayan ERC20 Forwards (direct)WITH erc20_fwd AS (SELECTevt_block_date AS block_date, chain, evt_tx_hash,token AS token_address,CAST(amount AS double) AS amount_rawFROM mayan_multichain.mayanforwarder_evt_forwardederc20WHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAY),-- Mayan Swap+Forward ERC20 (swap first, then bridge)swap_erc20_fwd AS (SELECTevt_block_date AS block_date, chain, evt_tx_hash,tokenIn AS token_address,CAST(amountIn AS double) AS amount_rawFROM mayan_multichain.mayanforwarder_evt_swapandforwardederc20WHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAY),-- Mayan Swap+Forward ETHswap_eth_fwd AS (SELECTevt_block_date AS block_date, chain, evt_tx_hash,0x0000000000000000000000000000000000000000 AS token_address,CAST(amountIn AS double) AS amount_rawFROM mayan_multichain.mayanforwarder_evt_swapandforwardedethWHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAY),-- Combine all Mayan eventsall_mayan AS (SELECT * FROM erc20_fwdUNION ALLSELECT * FROM swap_erc20_fwdUNION ALLSELECT * FROM swap_eth_fwd),-- Price everythingpriced AS (SELECTm.block_date,m.chain,m.evt_tx_hash,m.amount_raw / POWER(10, COALESCE(tk.decimals, 18)) * p.price AS amount_usdFROM all_mayan mLEFT JOIN tokens.erc20 tkON tk.blockchain = m.chain AND tk.contract_address = m.token_addressLEFT JOIN prices.usd_daily pON p.blockchain = m.chain AND p.contract_address = m.token_address AND p.day = m.block_date)SELECTblock_date,COUNT(DISTINCT evt_tx_hash) AS tx_count,COALESCE(SUM(amount_usd), 0) AS daily_volume_usd,SUM(COALESCE(SUM(amount_usd), 0)) OVER (ORDER BY block_date) AS cumulative_volume_usdFROM pricedGROUP BY 1ORDER BY 1