Abbas_ra21Daily Supply comparative
Updated 2024-05-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
›
⌄
select
date_trunc('{{Interval}}',BLOCK_TIMESTAMP) AS Date,
PLATFORM,
sum(
case
when Amount_USD is not null then Amount_USD
else Amount * Price
end
) AS Volume,
count(DISTINCT DEPOSITOR) AS Users,
count(*) AS Events
from
base.defi.ez_lending_deposits A
inner join base.price.ez_hourly_token_prices B on B.TOKEN_ADDRESS = A.TOKEN_ADDRESS
and HOUR = date_trunc('hour', BLOCK_TIMESTAMP)
and Date >= current_date - {{comparison_duration_D}}
group by
1,2
QueryRunArchived: QueryRun has been archived