0-MIDstatis depos dep
Updated 2023-08-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with tab1 as (
select
count(distinct TO_ADDRESS) as "DEPOSITORS"
,count(distinct tx_hash) as "DEPOSIT COUNT"
,sum(ETH_VALUE) as "ETH VALUE"
from base.core.fact_transactions
where FROM_ADDRESS in('0x80c67432656d59144ceff962e8faf8926599bcf8','0xe4edb277e41dc89ab076a1f049f4a3efa700bce8','0xd9d74a29307cc6fc8bf424ee4217f1a587fbc8dc')
)
select
"DEPOSIT COUNT"/"DEPOSITORS" as avg
from tab1
Run a query to Download Data