connorhMissing points
Updated 2021-05-04
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- 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