Query editor
WITH monthly_transfers AS (-- ERC20 transfersSELECTDATE_TRUNC('month', evt_block_time) AS month,evt_tx_hash,contract_address AS token_address,"from","to",value AS amountFROM erc20_arbitrum.evt_TransferWHERE "to" = 0x21568459854adcda462f6d9c11ce4f157dc70f93UNION ALL-- ERC1155 batch transfersSELECTDATE_TRUNC('month', evt_block_time) AS month,evt_tx_hash,contract_address AS token_address,"from","to",SUM(value) AS amountFROM erc1155_arbitrum.evt_TransferBatchCROSS JOIN UNNEST(ids, "values") AS t(id, value)WHERE "to" = 0x21568459854adcda462f6d9c11ce4f157dc70f93GROUP BY DATE_TRUNC('month', evt_block_time), evt_tx_hash, contract_address, "from", "to"),monthly_revenue AS (SELECTmonth,COUNT(*) AS total_transfers,SUM(amount) AS total_amount_raw,SUM(amount * 0.05) AS total_revenue_raw,SUM((amount / POWER(10, COALESCE(t.decimals, 18))) * 0.05) AS total_revenue_normalized,COUNT(DISTINCT token_address) AS distinct_tokens_receivedFROM monthly_transfersLEFT JOIN tokens.erc20 AS t ON monthly_transfers.token_address = t.contract_addressGROUP BY month)SELECTmonth,total_transfers,total_amount_raw,total_revenue_raw,total_revenue_normalized,SUM(total_revenue_normalized) OVER (ORDER BY month) AS cumulative_total_revenue_normalized,distinct_tokens_receivedFROM monthly_revenueORDER BY month;