DIS | USER_COUNT | USER_COUNT_PERCENTAGE | |
|---|---|---|---|
1 | D. $100 - $1,000 | 77 | 12.854758 |
2 | C. $10 - $100 | 145 | 24.207012 |
3 | more than 10,000 | 30 | 5.008347 |
4 | E. $1,000 - $10,000 | 49 | 8.180301 |
5 | A. less than $1 | 211 | 35.225376 |
6 | B. $1 - $10 | 87 | 14.524207 |
elsinaDistribution of User Volume
Updated 2025-02-07
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 dep as (
SELECT
tx_hash,
origin_from_address,
event_name,
contract_name
from
swell.core.ez_decoded_event_logs
where
event_name in ('Deposit') and
block_timestamp::date >= '2025-01-01'
),
eth_price as (
select
date_trunc('day', hour) as date,
avg(PRICE) usd_price
from crosschain.price.ez_prices_hourly
where
symbol ='ETH' and
BLOCKCHAIN = 'ethereum' and
date >= '2025-01-01' and
TOKEN_ADDRESS is NULL
group by 1
),
per_user as (
select
origin_from_address as user,
sum(value * usd_price) as volume
from swell.core.fact_transactions t left join dep d on t.tx_hash = d.tx_hash left join eth_price on block_timestamp::date = date
where
contract_name in ('Wrapped Ether', 'tsSwellETH')
group by 1
)
Last run: about 2 months ago
6
199B
5s