Query editor
with tab as (select date_trunc('day', evt_block_time) dt,sum(cast(amount0Out as double) / pow(10, 18)) tkn_out,sum(cast(amount1In as double) / pow(10, 18)) chi_in,sum(case when "to" = 0xD1C6d0e8eFB021eD6f1feaBB2A0f43b69917c321 then cast(amount0Out as double) / pow(10, 18) else 0 end) mint_tkn_out,sum(case when "to" = 0xD1C6d0e8eFB021eD6f1feaBB2A0f43b69917c321 then cast(amount1In as double) / pow(10, 18) else 0 end) mint_chi_infrom tokan_scroll.Pair_evt_Swapwhere contract_address = 0x838D141BdBECeAA2EB1C576b6a4309f26f795CF2group by 1), tkn_share as (select *,mint_tkn_out / tkn_out tkn_out_share,mint_chi_in / chi_in chi_in_share,mint_chi_in / ts.total_supply total_supply_sharefrom tableft join dune.defi_team.result_chi_total_supply ts on ts.block_hr >= dt and ts.prev_hr < dt)select *,AVG(tkn_out_share) OVER (ORDER BY dt ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) AS tkn_out_share_ma7, -- 7-day moving averageAVG(tkn_out_share) OVER (ORDER BY dt ROWS BETWEEN 19 PRECEDING AND CURRENT ROW) AS tkn_out_share_ma20 -- 20-day moving averagefrom tkn_shareorder by dt desc