Ariofriend tech stats 1
Updated 2024-05-11
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
›
⌄
with eth_tvl as (
select
a.day,
sum(mint) as mint,
sum(redemption) as redemption,
sum(coalesce(mint, 0) + coalesce(redemption, 0)) as amount
from
(
select
date_trunc('day', BLOCK_TIMESTAMP) as day,
sum(Value) as mint
from
base.core.fact_traces b
where
(
LOWER(TYPE) NOT IN ('delegatecall', 'callcode', 'staticcall')
or TYPE is null
)
AND TX_STATUS = 'SUCCESS'
AND TO_ADDRESS = '0xcf205808ed36593aa40a44f10c7f7c2f67d4a4d4'
group by
1
) a
left join (
select
date_trunc('day', BLOCK_TIMESTAMP) as day,
sum(Value * -1) as redemption
from
base.core.fact_traces
where
(
LOWER(TYPE) NOT IN ('delegatecall', 'callcode', 'staticcall')
or TYPE is null
)
AND TX_STATUS = 'SUCCESS'
AND FROM_ADDRESS = '0xcf205808ed36593aa40a44f10c7f7c2f67d4a4d4'
QueryRunArchived: QueryRun has been archived