nitsStake details min, max stats
Updated 2022-09-06Copy Reference Fork
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
34
35
36
›
⌄
with lido as
(SELECT count(DISTINCT tx_hash) as total_txs,
avg(amount) as avg_amt, avg(amount_usd) as avg_amt_usd,
median(amount) as median_amt, avg(amount_usd) as median_amt_usd,
max(amount) as max_amt, max(amount_usd) as max_amt_usd,
min(amount) as min_amt, min(amount_usd) as min_amt_usd,
count(DISTINCT origin_from_address) as unique_depositors, 'lido' as platform
from ethereum.core.ez_eth_transfers
where eth_to_address ilike '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'),
stakewise as
(SELECT count(DISTINCT tx_hash) as total_txs,
avg(amount) as avg_amt, avg(amount_usd) as avg_amt_usd,
median(amount) as median_amt, avg(amount_usd) as median_amt_usd,
max(amount) as max_amt, max(amount_usd) as max_amt_usd,
min(amount) as min_amt, min(amount_usd) as min_amt_usd,
count(DISTINCT origin_from_address) as unique_depositors, 'stakewise' as platform
from ethereum.core.ez_eth_transfers
where eth_to_address ilike '0xC874b064f465bdD6411D45734b56fac750Cda29A'),
str as
(SELECT count(DISTINCT tx_hash) as total_txs,
avg(amount) as avg_amt, avg(amount_usd) as avg_amt_usd,
median(amount) as median_amt, avg(amount_usd) as median_amt_usd,
max(amount) as max_amt, max(amount_usd) as max_amt_usd,
min(amount) as min_amt, min(amount_usd) as min_amt_usd,
count(DISTINCT origin_from_address) as unique_depositors, 'Ankr' as platform
from ethereum.core.ez_eth_transfers
where eth_to_address ilike '0x84db6eE82b7Cf3b47E8F19270abdE5718B936670')
,
direct as
(SELECT count(DISTINCT tx_hash) as total_txs,
avg(amount) as avg_amt, avg(amount_usd) as avg_amt_usd,
median(amount) as median_amt, avg(amount_usd) as median_amt_usd,
max(amount) as max_amt, max(amount_usd) as max_amt_usd,
min(amount) as min_amt, min(amount_usd) as min_amt_usd,
count(DISTINCT origin_from_address) as unique_depositors, 'direct' as platform
from ethereum.core.ez_eth_transfers
Run a query to Download Data