PIXEL_SPENT | BUYS | NUM_BUYERS | TOTAL_PIXEL_SPENT | TOTAL_AXES_BOUGHT | |
|---|---|---|---|---|---|
1 | 20 | 21965 | 12302 | 439300 | 8786000 |
2 | 100 | 4760 | 1756 | 476000 | 16184000 |
3 | 400 | 4528 | 752 | 1811200 | 72448000 |
4 | 1000 | 198 | 57 | 198000 | 6960024 |
5 | 1500 | 1771 | 1768 | 2656500 | 1771 |
6 | 2000 | 21 | 6 | 42000 | 1680000 |
7 | 5000 | 12 | 4 | 60000 | 2400000 |
permaryPickaxe shop
Updated 2025-03-23
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: 11 days ago
7
208B
19s