PERIOD | No Creators | Tokens created | Init Amount[RON] | Init Amount[USD] | Avg Init Amount[RON] | Median Init Amount[RON] | |
|---|---|---|---|---|---|---|---|
1 | All Time | 9112 | 23508 | 1720667.66877611 | 2591015.13457298 | 73.194983358 | 2 |
2 | Last 24H | 55 | 68 | 527.36 | 273.43313328 | 7.755294118 | 0 |
0xHaM-dToken Creation
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 token_create as (
select
a.BLOCK_TIMESTAMP,
a.TX_HASH,
a.origin_from_address,
a.DECODED_LOG:creator::string as creator,
a.DECODED_LOG:description::string as description,
a.DECODED_LOG:price as price,
a.DECODED_LOG:mcapInEth as mcapInEth,
a.DECODED_LOG:name::string as name,
a.DECODED_LOG:symbol::string as symbol,
a.DECODED_LOG:token::string as token_add,
b.VALUE as AMOUNT,
b.VALUE*price as AMOUNT_USD,
from ronin.core.ez_decoded_event_logs a
join ronin.core.fact_traces b using(TX_HASH)
join ronin.price.ez_prices_hourly on trunc(a.BLOCK_TIMESTAMP,'hour') = hour
where a.contract_address = '0xa54b0184d12349cf65281c6f965a74828ddd9e8f'
and a.ORIGIN_TO_ADDRESS = '0xa54b0184d12349cf65281c6f965a74828ddd9e8f'
and a.EVENT_NAME = 'TokenCreated'
and b.TRACE_ADDRESS = 'ORIGIN'
and a.TX_SUCCEEDED = 'TRUE'
and symbol = 'RON'
)
select
'All Time' as period,
count(DISTINCT creator) as "No Creators",
count(DISTINCT token_add) as "Tokens created",
sum(amount) as "Init Amount[RON]",
sum(amount_usd) as "Init Amount[USD]",
avg(amount) as "Avg Init Amount[RON]",
median(amount) as "Median Init Amount[RON]"
from token_create
group by 1
union all
Last run: about 2 months ago
2
127B
110s