DATE | TOTAL_PICKAXE_SALES | TOTAL_PICKAXES_BOUGHT | |
|---|---|---|---|
1 | 2024-12-15 00:00:00.000 | 2 | 16400 |
2 | 2024-12-16 00:00:00.000 | 1614 | 2477400 |
3 | 2024-12-17 00:00:00.000 | 2080 | 4600600 |
4 | 2024-12-18 00:00:00.000 | 1055 | 2703600 |
5 | 2024-12-19 00:00:00.000 | 534 | 1530000 |
6 | 2024-12-20 00:00:00.000 | 399 | 1223400 |
7 | 2024-12-21 00:00:00.000 | 390 | 976200 |
8 | 2024-12-22 00:00:00.000 | 440 | 969800 |
9 | 2024-12-23 00:00:00.000 | 13 | 8200 |
10 | 2024-12-24 00:00:00.000 | 5 | 17600 |
11 | 2024-12-25 00:00:00.000 | 7 | 37000 |
12 | 2024-12-26 00:00:00.000 | 4 | 4600 |
13 | 2024-12-27 00:00:00.000 | 4 | 1600 |
14 | 2024-12-28 00:00:00.000 | 6 | 2400 |
15 | 2024-12-29 00:00:00.000 | 2 | 800 |
16 | 2024-12-30 00:00:00.000 | 1 | 400 |
17 | 2024-12-31 00:00:00.000 | 1 | 400 |
18 | 2025-01-01 00:00:00.000 | 7 | 2800 |
19 | 2025-01-02 00:00:00.000 | 3 | 1200 |
20 | 2025-01-03 00:00:00.000 | 2 | 16400 |
permaryDaily Pickaxe Sales
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,
SUM(amount) AS pixel_spent -- Summing pixel spent per transaction
FROM ronin.core.ez_token_transfers
WHERE contract_address= '0x7eae20d11ef8c779433eb24503def900b9d28ad7'
GROUP BY 1
),
pickaxe_buys AS (
SELECT
tx_hash AS hash,
SUM(DECODED_LOG:value::FLOAT) AS axes_bought -- Summing axes per transaction
FROM ronin.core.ez_decoded_event_logs
WHERE contract_address ='0x9fa2b2b2b314f0486a15c48810b736ae83d5cc53'
AND topic_0 ='0xc3d58168c5ae7397731d063d5bbf3d657854427343f4c083240f7aacaa2d0f62'
GROUP BY 1
),
buy_data AS (
SELECT
p.date,
p.player AS buyer,
p.hash,
COALESCE(pp.pixel_spent, 0) AS pixel_spent,
COALESCE(a.axes_bought, 0) AS axes_bought
FROM purchase p
Last run: 24 days ago
...
109
4KB
21s