DATE | CRAFTING_TXS | SOL_CRAFT_DAILY_ALL | SOL_CRAFT_TXS | |
|---|---|---|---|---|
1 | 2025-05-21 00:00:00.000 | 21527 | 0.5226 | 0.00002428 |
2 | 2025-05-20 00:00:00.000 | 22277 | 0.576314 | 0.00002587 |
3 | 2025-05-19 00:00:00.000 | 24235 | 0.5372 | 0.00002217 |
4 | 2025-05-18 00:00:00.000 | 23699 | 0.549472 | 0.00002319 |
5 | 2025-05-17 00:00:00.000 | 21248 | 0.533383 | 0.0000251 |
6 | 2025-05-16 00:00:00.000 | 26602 | 0.666784 | 0.00002507 |
7 | 2025-05-15 00:00:00.000 | 20098 | 0.485231 | 0.00002414 |
8 | 2025-05-14 00:00:00.000 | 19247 | 0.535471 | 0.00002782 |
9 | 2025-05-13 00:00:00.000 | 27681 | 0.744174 | 0.00002688 |
10 | 2025-05-12 00:00:00.000 | 22647 | 0.610451 | 0.00002696 |
11 | 2025-05-11 00:00:00.000 | 20615 | 0.571291 | 0.00002771 |
12 | 2025-05-10 00:00:00.000 | 19907 | 0.517251 | 0.00002598 |
13 | 2025-05-09 00:00:00.000 | 20095 | 0.536545 | 0.0000267 |
14 | 2025-05-08 00:00:00.000 | 20904 | 0.579743 | 0.00002773 |
15 | 2025-05-07 00:00:00.000 | 21704 | 0.592968 | 0.00002732 |
16 | 2025-05-06 00:00:00.000 | 21114 | 0.669611 | 0.00003171 |
17 | 2025-05-05 00:00:00.000 | 19917 | 0.576885 | 0.00002896 |
18 | 2025-05-04 00:00:00.000 | 21859 | 0.628408 | 0.00002875 |
19 | 2025-05-03 00:00:00.000 | 20066 | 0.538181 | 0.00002682 |
20 | 2025-05-02 00:00:00.000 | 19052 | 0.58487 | 0.0000307 |
AephiaRQ - Daily Crafting txs fees
Updated 13 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 13 hours ago
30
2KB
826s