Nige7777test
Updated 2021-11-10
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
›
⌄
with cte_wbtc2 as (
select
supplier
,date_trunc('hour', block_timestamp) hour
,supplied_base_asset
from compound.deposits d
where
d.ctoken in
(
'0xccf4429db6322d5c611ee964527d42e5d685dd6a' --'cWBTC2'
)
--and date_trunc('day', block_timestamp) >= '2021-03-01T00:00:00Z'
and supplier=
'0xd28bfaea8c886ff6424141278a928f3cde2741f1'
),
cte_wbtc as (
select
supplier
,recieved_amount
,date_trunc('hour', block_timestamp) hour
from compound.redemptions r
where
r.ctoken in
(
'0xc11b1268c1a384e55c48c2391d8d480264a3a7f4' -- 'cWBTC'
)
and supplier=
'0xd28bfaea8c886ff6424141278a928f3cde2741f1'
)
select * from cte_wbtc2 b2
inner join cte_wbtc b1 on b2.supplier = b1.supplier
Run a query to Download Data