EVENT_NAME | TYPE | TRANSACTIONS | |
|---|---|---|---|
1 | Stake | Crab ($50 - $100) | 24335 |
2 | Stake | Dolphin ($1,000 - $5,000) | 6185 |
3 | Stake | Fish ($500 - $1,000) | 5449 |
4 | Stake | Giant Squid (More than $100,000) | 482 |
5 | Stake | Octopus ($100 - $500) | 27661 |
6 | Stake | Plankton (Less than $10) | 368556 |
7 | Stake | Shark ($5,000 - $10,000) | 1413 |
8 | Stake | Shrimp ($10 - $50) | 104367 |
9 | Stake | Whale ($10,000 - $100,000) | 2099 |
10 | Unstake | Crab ($50 - $100) | 8870 |
11 | Unstake | Dolphin ($1,000 - $5,000) | 4676 |
12 | Unstake | Fish ($500 - $1,000) | 3631 |
13 | Unstake | Giant Squid (More than $100,000) | 433 |
14 | Unstake | Octopus ($100 - $500) | 12122 |
15 | Unstake | Plankton (Less than $10) | 48602 |
16 | Unstake | Shark ($5,000 - $10,000) | 1213 |
17 | Unstake | Shrimp ($10 - $50) | 32249 |
18 | Unstake | Whale ($10,000 - $100,000) | 1729 |
Afonso_DiazGrouping txns
Updated 4 hours ago
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
pricet as (
select
hour::date as date,
token_address,
avg(price) as token_price_usd
from
ronin.price.ez_prices_hourly
group by 1, 2
),
main as (
select
tx_hash,
block_timestamp,
utils.udf_hex_to_int(topics[3])::bigint as amount_unadj,
amount_unadj / pow(10, a.decimals) as amount,
amount * token_price_usd as amount_usd,
'0x' || right(topics[2], 40) as token_address,
a.symbol,
origin_from_address as user,
iff(topics[0] = '0x5dac0c1b1112564a045ba943c9d50270893e8e826c49be8e7073adc713ab7bd7', 'Stake', 'Unstake') as event_name
from
ronin.core.fact_event_logs
left join
ronin.core.dim_contracts a on address = '0x' || right(topics[2], 40)
left join
pricet b on block_timestamp::date = date and b.token_address = a.address
where
tx_succeeded
and origin_to_address = '0x05b0bb3c1c320b280501b86706c3551995bc8571'
and topics[0] in ('0x5dac0c1b1112564a045ba943c9d50270893e8e826c49be8e7073adc713ab7bd7', '0xd8654fcc8cf5b36d30b3f5e4688fc78118e6d68de60b9994e09902268b57c3e3')
)
select
Last run: about 4 hours ago
18
764B
26s