jackguy2023-03-07 06:38 PM
Updated 2023-03-08
99
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
›
⌄
--SELECT
-- date_trunc('day', block_timestamp) AS day,
-- 'Borrow' AS action,
-- borrower_address,
-- symbol,
-- borrowed_tokens,
-- tx_hash
-- FROM ethereum.aave.ez_borrows
--where symbol in ('SNX', 'UNI', 'MKR', '', '')
--LIMIT 100
SELECT
*,
sum(net_volume) over (partition by token order by net_volume) as cume_deposit
FROM (
SELECT
date_trunc('day', block_timestamp) as day,
CASE
when contract_address LIKE lower('0x5BdB050A92CADcCfCDcCCBFC17204a1C9cC0Ab73') then 'UNI'
when contract_address LIKE lower('0x267EB8Cf715455517F9BD5834AeAE3CeA1EBdbD8') then 'SNX'
when contract_address LIKE lower('0xba728eAd5e496BE00DCF66F650b6d7758eCB50f8') then 'MKR'
end as token,
sum(CASE
when from_address LIKE '0x0000000000000000000000000000000000000000' then RAW_AMOUNT / power(10, 18)
ELSE -1 * RAW_AMOUNT / power(10, 18) END
) as net_volume
FROM ethereum.core.ez_token_transfers
WHERE contract_address in (
lower('0xba728eAd5e496BE00DCF66F650b6d7758eCB50f8') --,
-- lower('0x267EB8Cf715455517F9BD5834AeAE3CeA1EBdbD8'),
-- lower('0x5BdB050A92CADcCfCDcCCBFC17204a1C9cC0Ab73')
) GROUP BY 1,2
)
Run a query to Download Data