Query editor
WITH address_list AS(SELECTCAST('\x00' AS bytea) AS address),not_address_list AS(SELECTCAST('\x0000000000000000000000000000000000000000' AS bytea) AS address),contract_address AS(SELECTCAST('\xae7ab96520de3a18e5e111b5eaab095312d7fe84' AS bytea) AS address),transfers AS(SELECTDATE_TRUNC('day', evt_block_time) AS time,evt_tx_hash AS tx_hash,tr."from" AS address,0 AS amount_in,-tr.value AS amount_outFROM lido."steth_evt_Transfer" trWHERE "contract_address" IN (SELECT address FROM contract_address) AND "from" NOT IN (SELECT address FROM not_address_list)UNION ALLSELECTDATE_TRUNC('day', evt_block_time) AS time,evt_tx_hash AS tx_hash,tr."to" AS address,tr.value AS amount_in,0 AS amount_outFROM lido."steth_evt_Transfer" trWHERE "contract_address" IN (SELECT address FROM contract_address) AND "to" NOT IN (SELECT address FROM not_address_list)),namespace AS --UPDATED 2021/06/30 17:42(SELECT distincta.address,Casewhen COALESCE(NULLIF(ln.name,''),c."namespace",'depositor')='yearn_finance' then 'depositor'when COALESCE(NULLIF(ln.name,''),c."namespace",'depositor')='lido: wsteth token' then 'depositor'else COALESCE(NULLIF(ln.name,''),c."namespace",'depositor')end AS namespace/*CASEWHEN a.address IN ('\x1f629794b34ffb3b29ff206be5478a52678b47ae') THEN '1inch Liquidity Pool'WHEN a.address IN ('\xe069cb01d06ba617bcdf789bf2ff0d5e5ca20c71','\x111111125434b319222CdBf8C261674aDB56F3ae') THEN '1inch.exchange'