Query editor
WITH wtrades AS (SELECT * FROM dune_user_generated.filtered_wt),r AS (SELECT * FROM dune_user_generated.looksrare_rewards_wt),c AS (SELECT * FROM dune_user_generated.looksrare_claim),w AS (SELECT * FROM dune_user_generated.looksrare_fee_wt)SELECT address, trades, pairs, volume, "cumulative volume", rewards as "LR reward",sum(rewards) over (order by volume asc rows between unbounded preceding and current row) as "(cumulative)",looks as "LR airdrop", weth as "weth harvest", "cumulative trades"FROM (SELECTCONCAT('<a href="https://zapper.fi/account/', CONCAT('0x', ENCODE(f.address, 'hex')), '" target="_blank">',substring(concat(f.address),2,6), '</a>') as address, trades, pairs, "Volume A" as volume,sum("Volume A") over (order by "Volume A" asc rows between unbounded preceding and current row) as "cumulative volume",sum(trades) over (order by "Volume A" asc rows between unbounded preceding and current row) as "cumulative trades", r.rewards, c.looks, w.wethFROM wtrades as fLEFT JOIN r ON r.address=f.addressLEFT JOIN c ON c.address=f.addressLEFT JOIN w ON w.address=f.address) as resORDER BY volume DESC