Query editor
WITH erc20_forwards AS (SELECTevt_block_date AS block_date,chain,'forward_erc20' AS event_type,token AS token_address,amount AS amount_raw,evt_tx_hashFROM mayan_multichain.mayanforwarder_evt_forwardederc20WHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAY),erc20_swap_forwards AS (SELECTevt_block_date AS block_date,chain,'swap_forward_erc20' AS event_type,tokenIn AS token_address,amountIn AS amount_raw,evt_tx_hashFROM mayan_multichain.mayanforwarder_evt_swapandforwardederc20WHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAY),eth_forwards AS (SELECTevt_block_date AS block_date,chain,'forward_eth' AS event_type,evt_tx_hashFROM mayan_multichain.mayanforwarder_evt_forwardedethWHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAY),eth_swap_forwards AS (SELECTevt_block_date AS block_date,chain,'swap_forward_eth' AS event_type,amountIn AS amount_raw,evt_tx_hashFROM mayan_multichain.mayanforwarder_evt_swapandforwardedethWHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAY),-- Price ERC20 eventserc20_priced AS (SELECTe.block_date, e.chain, e.event_type, e.evt_tx_hash,CAST(e.amount_raw AS double) / POWER(10, COALESCE(t.decimals, 18)) * p.price AS amount_usdFROM (SELECT * FROM erc20_forwards UNION ALL SELECT * FROM erc20_swap_forwards) eLEFT JOIN tokens.erc20 t ON t.blockchain = e.chain AND t.contract_address = e.token_addressLEFT JOIN prices.usd_daily p ON p.blockchain = e.chain AND p.contract_address = e.token_address AND p.day = e.block_date),-- Price ETH swap forwards (has amountIn)eth_swap_priced AS (SELECTe.block_date, e.chain, e.event_type, e.evt_tx_hash,CAST(e.amount_raw AS double) / 1e18 * p.price AS amount_usdFROM eth_swap_forwards eLEFT JOIN prices.usd_daily pON p.blockchain = e.chainAND p.contract_address = 0x0000000000000000000000000000000000000000