Query editor
with total as (SELECTblock_date as period,SUM(token_balance_change) AS fee-- SUM(SUM(token_balance_change)) over(order by block_date) AS total_feeFROMsolana.account_activityWHEREblock_date >= date('2024-05-01')AND tx_successAND token_balance_owner = '23vEM5NAmK68uBHFM52nfNtZn7CgpHDSmAGWebsjg5ft'AND token_mint_address = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'AND token_balance_change > 0GROUP BY 1-- ORDER BY 1 DESCUNION ALLselect date_trunc('day', evt_block_time) as period,sum(value/1e6) as feefrom erc20_ethereum.evt_transferwhereevt_block_time >= date('2024-04-01')and to = 0xbf07aFF5114BAd83720A8b9Fc7585aFd2ef9E4C2and contract_address = 0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48group by 1UNION ALLselect date_trunc('day', evt_block_time) as period,sum(value/1e6) as feefrom erc20_base.evt_transferwhereevt_block_time >= date('2024-04-01')and to = 0xbf07aFF5114BAd83720A8b9Fc7585aFd2ef9E4C2and contract_address = 0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913group by 1UNION ALLselect date_trunc('day', evt_block_time) as period,sum(value/1e6) as feefrom erc20_polygon.evt_transferwhereevt_block_time >= date('2024-04-01')and to = 0xbf07aFF5114BAd83720A8b9Fc7585aFd2ef9E4C2and contract_address = 0x3c499c542cEF5E3811e1192ce70d8cC03d5c3359group by 1)selectperiod,sum(fee) as daily_fee,sum(sum(fee)) over(order by period) as total_feefrom totalgroup by 1order by 1 desc