connorhMissing points
    Updated 2021-05-04
    -- pull all ctoken addresses and corresponding name
    WITH ctoks as (
    SELECT
    DISTINCT contract_address as address,
    CASE WHEN contract_address = '0x6c8c6b02e7b2be14d4fa6022dfd6d75921d90e4e' THEN 'cBAT'
    WHEN contract_address = '0x70e36f6bf80a52b3b46b3af8e106cc0ed743e8e4' THEN 'cCOMP'
    WHEN contract_address = '0x5d3a536e4d6dbd6114cc1ead35777bab948e3643' THEN 'cDAI'
    WHEN contract_address = '0x4ddc2d193948926d02f9b1fe9e1daa0718270ed5' THEN 'cETH'
    WHEN contract_address = '0x158079ee67fce2f58472a96584a73c7ab9ac95c1' THEN 'cREP'
    WHEN contract_address = '0xf5dce57282a584d2746faf1593d3121fcac444dc' THEN 'cSAI'
    WHEN contract_address = '0x35a18000230da775cac24873d00ff85bccded550' THEN 'cUNI'
    WHEN contract_address = '0x39aa39c021dfbae8fac545936693ac917d5e7563' THEN 'cUSDC'
    WHEN contract_address = '0xf650c3d88d12db855b8bf7d11be6c55a4e07dcc9' THEN 'cUSDT'
    WHEN contract_address = '0xc11b1268c1a384e55c48c2391d8d480264a3a7f4' THEN 'cWBTC'
    WHEN contract_address = '0xccf4429db6322d5c611ee964527d42e5d685dd6a' THEN 'cWBTC2'
    WHEN contract_address = '0xb3319f5d18bc0d84dd1b4825dcde5d5f7266d407' THEN 'cZRX' end project_name
    FROM ethereum.events_emitted
    WHERE contract_address in (
    '0x6c8c6b02e7b2be14d4fa6022dfd6d75921d90e4e', -- cbat
    '0x70e36f6bf80a52b3b46b3af8e106cc0ed743e8e4', -- ccomp
    '0x5d3a536e4d6dbd6114cc1ead35777bab948e3643', -- cdai
    '0x4ddc2d193948926d02f9b1fe9e1daa0718270ed5', -- cETH
    '0x158079ee67fce2f58472a96584a73c7ab9ac95c1', -- cREP
    '0xf5dce57282a584d2746faf1593d3121fcac444dc', -- csai
    '0x35a18000230da775cac24873d00ff85bccded550', -- cuni
    '0x39aa39c021dfbae8fac545936693ac917d5e7563', -- cusdc
    '0xf650c3d88d12db855b8bf7d11be6c55a4e07dcc9', -- cusdt
    '0xc11b1268c1a384e55c48c2391d8d480264a3a7f4', -- cwbtc
    '0xccf4429db6322d5c611ee964527d42e5d685dd6a', -- cwbtc2
    '0xb3319f5d18bc0d84dd1b4825dcde5d5f7266d407' -- czrx
    )
    AND block_timestamp > getdate() - interval '31 days'
    ),
    ctok_decimals AS (
    SELECT DISTINCT
    contract_address,
    Run a query to Download Data