adambalaMetrics on True Freeze
Updated 2023-04-13
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
›
⌄
with a as
(select
date(BLOCK_TIMESTAMP) as date ,
count(distinct TX_HASH) as transactions,
count(distinct ORIGIN_FROM_ADDRESS) as users ,
sum(EVENT_INPUTS:value /pow(10,18)) as frETH_amount
from ethereum.core.fact_event_logs
where
ORIGIN_FUNCTION_SIGNATURE ='0x0f221cab'
and ORIGIN_TO_ADDRESS='0xa4b41efc1b6f73355c90119aeefddb1ffcf907b0'
and CONTRACT_NAME is null group by 1 having frETH_amount is not null),
b as (
select
date(BLOCK_TIMESTAMP) as date ,
count(distinct TX_HASH) as transactions,
count(distinct ORIGIN_FROM_ADDRESS) as users ,
sum(EVENT_INPUTS:value /pow(10,18)) as frETH_amount
from ethereum.core.fact_event_logs
where
ORIGIN_FUNCTION_SIGNATURE ='0xbe5021ec'
and ORIGIN_TO_ADDRESS='0xa4b41efc1b6f73355c90119aeefddb1ffcf907b0'
and CONTRACT_NAME ='WETH9'
and CONTRACT_ADDRESS ='0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
and EVENT_NAME ='Transfer' group by 1
)
select * from a
Run a query to Download Data