DATE | CRAFTING_TXS | SOL_CRAFT_DAILY_ALL | SOL_CRAFT_TXS | |
|---|---|---|---|---|
1 | 2025-04-09 00:00:00.000 | 21212 | 0.72817 | 0.00003433 |
2 | 2025-04-08 00:00:00.000 | 20773 | 0.581775 | 0.00002801 |
3 | 2025-04-07 00:00:00.000 | 18365 | 0.67191 | 0.00003659 |
4 | 2025-04-06 00:00:00.000 | 19414 | 0.631153 | 0.00003251 |
5 | 2025-04-05 00:00:00.000 | 20130 | 0.592311 | 0.00002942 |
6 | 2025-04-04 00:00:00.000 | 19939 | 0.652373 | 0.00003272 |
7 | 2025-04-03 00:00:00.000 | 20036 | 0.643653 | 0.00003212 |
8 | 2025-04-02 00:00:00.000 | 21063 | 0.678352 | 0.00003221 |
9 | 2025-04-01 00:00:00.000 | 20259 | 0.698196 | 0.00003446 |
10 | 2025-03-31 00:00:00.000 | 21141 | 0.698202 | 0.00003303 |
11 | 2025-03-30 00:00:00.000 | 21581 | 0.674567 | 0.00003126 |
12 | 2025-03-29 00:00:00.000 | 21699 | 0.616032 | 0.00002839 |
13 | 2025-03-28 00:00:00.000 | 21249 | 0.719983 | 0.00003388 |
14 | 2025-03-27 00:00:00.000 | 20976 | 0.720295 | 0.00003434 |
15 | 2025-03-26 00:00:00.000 | 22311 | 0.750023 | 0.00003362 |
16 | 2025-03-25 00:00:00.000 | 22338 | 0.694035 | 0.00003107 |
17 | 2025-03-24 00:00:00.000 | 21243 | 0.684704 | 0.00003223 |
18 | 2025-03-23 00:00:00.000 | 21268 | 0.634186 | 0.00002982 |
19 | 2025-03-22 00:00:00.000 | 22017 | 0.710631 | 0.00003228 |
20 | 2025-03-21 00:00:00.000 | 21875 | 0.689621 | 0.00003153 |
AephiaRQ - Daily Crafting txs fees
Updated 18 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 starbase_player AS (
SELECT
player_profile
,starbase_player
FROM $query('62a2c594-afe5-4164-9a14-81fb22953bdc')
)
,fees AS (
SELECT
date_trunc('day', block_timestamp::date) as date
,fe.tx_id
---
,count(distinct(tx_id)) as txs
--,max(ft.fee) / 1000000000 as max_fee
--,txs::int * max_fee::float as sol_payed
,ft.fee / 1000000000 as sol_payed
--,sum(ft.fee) OVER (partition by date, starbase, asset) / 1000000000 as sum_sol_payed
,sum(sol_payed) OVER (partition by date) as sol_craft_daily_all
,sum(txs) OVER (partition by date) as crafting_txs
from starbase_player s
--,crafting c
,solana.core.fact_events fe
inner join solana.core.fact_transactions ft USING(block_timestamp, tx_id)
WHERE program_id IN ('SAGE2HAwep459SNq61LHvjxPk4pLPEJLoMETef7f7EE')
AND log_messages::string LIKE '%Crafting%'
--AND succeeded = 'true'
AND s.starbase_player IN (instruction:accounts[1], instruction:accounts[2])
Last run: about 14 hours ago
30
2KB
520s