DATE | BORROWS | COIN | |
---|---|---|---|
1 | 2019-05-07 00:00:00.000 | compound | |
2 | 2019-05-08 00:00:00.000 | compound | |
3 | 2019-05-09 00:00:00.000 | compound | |
4 | 2019-05-10 00:00:00.000 | compound | |
5 | 2019-05-13 00:00:00.000 | compound | |
6 | 2019-05-14 00:00:00.000 | compound | |
7 | 2019-05-15 00:00:00.000 | compound | |
8 | 2019-05-16 00:00:00.000 | compound | |
9 | 2019-05-17 00:00:00.000 | compound | |
10 | 2019-05-20 00:00:00.000 | compound | |
11 | 2019-05-21 00:00:00.000 | compound | |
12 | 2019-05-22 00:00:00.000 | compound | |
13 | 2019-05-23 00:00:00.000 | compound | |
14 | 2019-05-24 00:00:00.000 | compound | |
15 | 2019-05-25 00:00:00.000 | compound | |
16 | 2019-05-26 00:00:00.000 | compound | |
17 | 2019-05-27 00:00:00.000 | compound | |
18 | 2019-05-28 00:00:00.000 | compound | |
19 | 2019-05-29 00:00:00.000 | compound | |
20 | 2019-05-30 00:00:00.000 | compound |
pyor-subscriptionscumulative_originations_daily
Updated 2024-02-14Copy Reference Fork
9
1
2
3
4
›
⌄
select date(date_trunc('day', BLOCK_TIMESTAMP)) as date, sum(LOAN_AMOUNT_USD) as borrows, 'compound' as coin
from ethereum.compound.ez_borrows
group by 1
order by 1
Last run: over 1 year agoAuto-refreshes every 3 hours
1741
84KB
2s