Query editor
WITH evm_events AS (SELECT evt_block_date AS block_date, 'evm' AS chain_type, CAST(evt_tx_hash AS varchar) AS tx_idFROM mayan_multichain.mayanforwarder_evt_forwardederc20WHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNION ALLSELECT evt_block_date, 'evm', CAST(evt_tx_hash AS varchar)FROM mayan_multichain.mayanforwarder_evt_forwardedethWHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNION ALLSELECT evt_block_date, 'evm', CAST(evt_tx_hash AS varchar)FROM mayan_multichain.mayanforwarder_evt_swapandforwardederc20WHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAYUNION ALLSELECT evt_block_date, 'evm', CAST(evt_tx_hash AS varchar)FROM mayan_multichain.mayanforwarder_evt_swapandforwardedethWHERE evt_block_date >= CURRENT_DATE - INTERVAL '90' DAY),solana_swift AS (SELECT call_block_date AS block_date, 'solana_swift' AS chain_type, call_tx_id AS tx_idFROM mayan_solana.swift_call_initorderWHERE call_block_date >= CURRENT_DATE - INTERVAL '90' DAY),solana_mctp AS (SELECT call_block_date AS block_date, 'solana_mctp' AS chain_type, call_tx_id AS tx_idFROM mayan_solana.mctp_call_settle_orderWHERE call_block_date >= CURRENT_DATE - INTERVAL '90' DAY),solana_volume AS (SELECTo.call_block_date AS block_date,o.call_tx_id AS tx_id,SUM(t.amount_usd) AS amount_usdFROM mayan_solana.swift_call_initorder oINNER JOIN tokens_solana.transfers tON t.tx_id = o.call_tx_idAND t.block_date = o.call_block_dateAND t.token_mint_address = o.account_mintFromAND t.action = 'transfer'WHERE o.call_block_date >= CURRENT_DATE - INTERVAL '30' DAYAND o.account_mintFrom IN ('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v','7vfCXTUXx5WJV5JADk17DUJ4ksgau7utNKj4b963voxs')GROUP BY 1, 2),all_txs AS (SELECT block_date, chain_type, tx_id FROM evm_eventsUNION ALLSELECT block_date, chain_type, tx_id FROM solana_swiftUNION ALLSELECT block_date, chain_type, tx_id FROM solana_mctp),daily_counts AS (SELECTblock_date,COUNT(DISTINCT tx_id) AS total_tx_count,COUNT(DISTINCT CASE WHEN chain_type = 'evm' THEN tx_id END) AS evm_tx_count,COUNT(DISTINCT CASE WHEN chain_type = 'solana_swift' THEN tx_id END) AS solana_swift_count,COUNT(DISTINCT CASE WHEN chain_type = 'solana_mctp' THEN tx_id END) AS solana_mctp_countFROM all_txs