PERIOD | AMOUNT_RON | AMOUNT_USD | AVG_REVENUE_PER_DAY_RON | AVG_REVENUE_PER_DAY_USD | AVG_AMOUNT_USD | MEDIAN_AMOUNT_USD | |
|---|---|---|---|---|---|---|---|
1 | All Time | 439953.884120455 | 639501.846125234 | 5499.423551506 | 7993.773076565 | 0.6380980305 | 0.1514314145 |
2 | Last 24H | 84.424174839 | 44.493439785 | 42.21208742 | 22.246719893 | 0.1029940736 | 0.02928002539 |
0xHaM-dRevenue in Total
Updated 2025-04-10
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 revenue as (
select
block_timestamp,
value,
value*price as value_usd,
from ronin.core.fact_traces
join ronin.price.ez_prices_hourly on trunc(block_timestamp,'hour') = hour
where from_address = '0xa54b0184d12349cf65281c6f965a74828ddd9e8f'
and to_address = '0x3a62b1e24a2e734d9721ebb9064dfdb0504a7dbb'
and symbol = 'RON'
)
select
'All Time' as period,
sum(value) as amount_ron,
sum(value_usd) as amount_usd,
amount_ron/count(DISTINCT block_timestamp::date) as avg_revenue_per_day_ron,
amount_usd/count(DISTINCT block_timestamp::date) as avg_revenue_per_day_usd,
avg(value_usd) as avg_amount_usd,
median(value_usd) as median_amount_usd,
from revenue
group by 1
union All
select
'Last 24H' as period,
sum(value) as amount_ron,
sum(value_usd) as amount_usd,
amount_ron/count(DISTINCT block_timestamp::date) as avg_revenue_per_day_ron,
amount_usd/count(DISTINCT block_timestamp::date) as avg_revenue_per_day_usd,
avg(value_usd) as avg_amount_usd,
median(value_usd) as median_amount_usd,
from revenue
where block_timestamp::date >= CURRENT_DATE - INTERVAL '24 HOUR'
group by 1
order by 2 desc
Last run: about 2 months ago
2
195B
82s