date(BLOCK_TIMESTAMP) AS DAY,

CONTRACT_ADDRESS,

sum(AMOUNT_DELEGATED) AS Amount

from ethereum.maker.ez_delegations where TX_EVENT='delegate' and TX_STATUS='SUCCESS'

group by 1,2

select

date(BLOCK_TIMESTAMP) AS DAY,

CONTRACT_ADDRESS,

-sum(AMOUNT_DELEGATED) AS Amount

from ethereum.maker.ez_delegations where TX_EVENT='undelegate' and TX_STATUS='SUCCESS'

group by 1,2),

delegates as (

select lower('0xafaff1a605c373b43727136c995d21a7fcd08989') AS address, 'Hasu' as name

union all

select lower('0x4d3ac33ab1dd7b0f352b8e590fe8b62c4c39ead5') AS address, 'ACREinvest' as name

union all

select lower('0x84b05b0a30b6ae620f393d1037f217e607ad1b96') AS address, 'Flipside Crypto' as name

union all

select lower('0x8804d391472126da56b9a560aef6c6d5aaa7607b') AS address, 'Doo' as name

union all

select lower('0xB4b82978FCe6d26A22deA7E653Bb9ce8e14f8056') AS address, 'Schuppi' as name

union all

select lower('0xad2fda5f6ce305d2ced380fdfa791b6a26e7f281') AS address, 'PaperImperium' as name

union all

select lower('0x00daec2c2a6a3fcc66b02e38b7e56dcdfa9347a1') AS address, 'Planet X' as name

union all

select lower('0x92e1Ca8b69A44bB17aFA92838dA68Fc41f12250a') AS address, 'Feedblack Loops' as name

union all

select lower('0x0f4Be9f208C552A6b04d9A1222F385785f95beAA') AS address, 'ElPro' as name

union all

select lower('0x688d508f3a6b0a377e266405a1583b3316f9a2b3') AS address, 'ElPro' as name

union all

select lower('0x45127ec92b58c3a89e89f63553073adcaf2f1f5f') AS address, 'MonetSupply' as name

union all