DATE | CRAFTING_TXS | SOL_CRAFT_DAILY_ALL | SOL_CRAFT_TXS | |
|---|---|---|---|---|
1 | 2025-05-10 00:00:00.000 | 19896 | 0.516377 | 0.00002595 |
2 | 2025-05-09 00:00:00.000 | 20085 | 0.536495 | 0.00002671 |
3 | 2025-05-08 00:00:00.000 | 20903 | 0.579738 | 0.00002773 |
4 | 2025-05-07 00:00:00.000 | 21702 | 0.592958 | 0.00002732 |
5 | 2025-05-06 00:00:00.000 | 21107 | 0.665476 | 0.00003153 |
6 | 2025-05-05 00:00:00.000 | 19917 | 0.576885 | 0.00002896 |
7 | 2025-05-04 00:00:00.000 | 21860 | 0.628413 | 0.00002875 |
8 | 2025-05-03 00:00:00.000 | 20065 | 0.537425 | 0.00002678 |
9 | 2025-05-02 00:00:00.000 | 19052 | 0.58487 | 0.0000307 |
10 | 2025-05-01 00:00:00.000 | 19771 | 0.582473 | 0.00002946 |
11 | 2025-04-30 00:00:00.000 | 18629 | 0.531984 | 0.00002856 |
12 | 2025-04-29 00:00:00.000 | 19445 | 0.595853 | 0.00003064 |
13 | 2025-04-28 00:00:00.000 | 19573 | 0.623842 | 0.00003187 |
14 | 2025-04-27 00:00:00.000 | 20800 | 0.56235 | 0.00002704 |
15 | 2025-04-26 00:00:00.000 | 20296 | 0.590686 | 0.0000291 |
16 | 2025-04-25 00:00:00.000 | 20997 | 0.606819 | 0.0000289 |
17 | 2025-04-24 00:00:00.000 | 21674 | 0.658834 | 0.0000304 |
18 | 2025-04-23 00:00:00.000 | 21521 | 0.741691 | 0.00003446 |
19 | 2025-04-22 00:00:00.000 | 20249 | 0.637588 | 0.00003149 |
20 | 2025-04-21 00:00:00.000 | 20515 | 0.632114 | 0.00003081 |
AephiaRQ - Daily Crafting txs fees
Updated 37 minutes 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: 39 minutes ago
30
2KB
651s