Query editor
select *,tx_count/sum(tx_count) over (partition by day) as percentagefrom (select date_trunc('day', block_time) as day,casewhen "from" in (select distinct trader from dune."21co".result_2961524) then 'From FT MEV'when "from" not in (select distinct trader from dune."21co".result_2961524) then 'Not From FT MEV'end as type,cast(count(distinct hash) as double) as tx_countfrom base.transactionswhere-- "to" = 0xcf205808ed36593aa40a44f10c7f7c2f67d4a4d4-- andsuccess = falsegroup by 1,2)awhere day>=date('2023-08-10')