Query editor
WITH removals AS (SELECTt.block_time,t.amountFROM tokens.transfers tWHERE t.blockchain = 'ethereum'AND t.contract_address = 0xB0076DE78Dc50581770BBa1D211dDc0aD4F2a241AND t."from" = 0x000000000004444c5dc75cb358380d2e3de08a90AND EXISTS (SELECT 1FROM uniswap_v4_multichain.poolmanager_evt_ModifyLiquidity rWHERE r.chain = 'ethereum'AND r.liquidityDelta < 0AND r.evt_tx_hash = t.tx_hash)),bounds AS (SELECTdate(min(block_time)) AS min_day,date(max(block_time)) AS max_dayFROM removals),date_spine AS (SELECT dayFROM boundsCROSS JOIN UNNEST(sequence(min_day, max_day, interval '1' day)) AS t(day)),daily AS (SELECTdate_trunc('day', block_time) AS day,SUM(amount) AS amountFROM removalsGROUP BY 1)SELECTs.day,d.amountFROM date_spine sLEFT JOIN daily dON s.day = d.dayORDER BY 1