Query editor
SELECT date_trunc('day', evt_block_time) as time,CASEWhen perpv2_tokens.token_address IS NOT NULL THEN perpv2_tokens.symbolELSE CONCAT('0x', SUBSTRING(funding_settled."baseToken":: text, 3))END as market,SUM("fundingPayment") * 1e-18 as total_funding_payment,SUM(SUM("fundingPayment") * 1e-18) OVER (PARTITION BY "baseToken" ORDER BY date_trunc('day', evt_block_time)) as cumulative_fundingFROM perp_v2."ClearingHouse_evt_FundingPaymentSettled" as funding_settled left join dune_user_generated."shogun_perpv2_tokens" as perpv2_tokensON funding_settled."baseToken" = perpv2_tokens.token_addressWHERE trader = CONCAT('\x',SUBSTRING('{{wallet address}}' from 3))::bytea and(CASEWHEN '{{time period}}' = 'Day' THEN date_trunc('day', evt_block_time) >= NOW() - interval '1 day'WHEN '{{time period}}' = 'Week' THEN date_trunc('day', evt_block_time) >= NOW() - interval '1 week'WHEN '{{time period}}' = 'Month' THEN date_trunc('day', evt_block_time) >= NOW() - interval '1 month'WHEN '{{time period}}' = 'Year' THEN date_trunc('day', evt_block_time) >= NOW() - interval '1 year'WHEN '{{time period}}' = 'All-Time' THEN 1=1END)GROUP BY 1, 2, "baseToken"ORDER BY time desc, market