PIXEL_SPENT | BUYS | NUM_BUYERS | TOTAL_PIXEL_SPENT | TOTAL_AXES_BOUGHT | |
|---|---|---|---|---|---|
1 | 20 | 22970 | 12536 | 459400 | 9186000 |
2 | 100 | 5061 | 1840 | 506100 | 17204000 |
3 | 400 | 4825 | 786 | 1930000 | 77200000 |
4 | 1000 | 220 | 64 | 220000 | 7600030 |
5 | 1500 | 1899 | 1825 | 2848500 | 1898 |
6 | 2000 | 25 | 9 | 50000 | 2000000 |
7 | 5000 | 36 | 9 | 180000 | 7200000 |
permaryPickaxe shop
Updated 2025-04-03
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 purchase as (
select
from_address as player,
date_trunc ('day', block_timestamp) as date,
tx_hash as hash
from ronin.core.fact_transactions
where origin_function_signature = '0xefef39a1'
),
pixel_purchase as (
select
tx_hash as hash,
amount
from ronin.core.ez_token_transfers
where contract_address= '0x7eae20d11ef8c779433eb24503def900b9d28ad7'
),
pickaxe_buys as (
select
tx_hash as hash,
DECODED_LOG:id::STRING AS id,
DECODED_LOG:value::STRING AS amount
from ronin.core.ez_decoded_event_logs
where contract_address ='0x9fa2b2b2b314f0486a15c48810b736ae83d5cc53'
and topic_0 ='0xc3d58168c5ae7397731d063d5bbf3d657854427343f4c083240f7aacaa2d0f62'
),
buy_data as (
select p.date,
((p.player)) as buyers,
p.hash,
(pp.amount) as pixel_spent,
(a.amount) as axes_bought
from purchase p
left join pixel_purchase pp on p.hash = pp.hash
left join pickaxe_buys a on p.hash = a.hash
Last run: 19 days ago
7
209B
18s