mz0111Distribution of ETH deposits in 'stkr'
Updated 2022-09-04
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
›
⌄
SELECT
CASE
WHEN volume BETWEEN 0 AND 0.5 THEN '0-0.5 Ether'
WHEN volume BETWEEN 0.5 AND 1 THEN '0.5-1 Ether'
WHEN volume BETWEEN 1 AND 5 THEN '1-5 Ether'
WHEN volume BETWEEN 5 AND 10 THEN '5-10 Ether'
WHEN volume BETWEEN 10 AND 20 THEN '10-20 Ether'
WHEN volume BETWEEN 20 AND 30 THEN '20-30 Ether'
WHEN volume BETWEEN 30 AND 40 THEN '30-40 Ether'
WHEN volume BETWEEN 40 AND 50 THEN '40-50 Ether'
WHEN volume > 50 THEN 'More than 50 Ether'
END AS volume_distribution,
count("Staker") as number_of_users
FROM
(SELECT
"Staker",
SUM("Total Amount of ETH Staked") as volume
FROM
( SELECT
'stkr' as "platform name",
origin_from_address as "Staker",
sum(event_inputs:value/1e18) as "Total Amount of ETH Staked"
from ethereum.core.fact_event_logs
where origin_to_address = lower('0x84db6eE82b7Cf3b47E8F19270abdE5718B936670')
and origin_function_signature in ('0x9fa65c56','0xeb834a2c') -- Stake and Claim Aeth C , Stake and Claim Aeth B
and event_inputs:from = lower('0x84db6eE82b7Cf3b47E8F19270abdE5718B936670')
group by 2
)
group by 1
)
group by 1
Run a query to Download Data