DATE | PLAYER_PROFILE | CARGO_FLEET | FUEL_PAYED | FUEL_CARGO_DAILY_CF | FUEL_CARGO_DAILY_PP | |
|---|---|---|---|---|---|---|
1 | 2025-03-10 00:00:00.000 | 4MRcKGcFz3wczWdHh8LmFPdwZ9uE3Wwo35idVfKu3RjB | 4XBJaWLJQkwUXW8esbscxDeiZ3xtuQ59jBNqLyb8kH8t | 4689360 | 4689360 | 6030420 |
2 | 2025-03-10 00:00:00.000 | 7jKp5e9jgjHn6mLaoHNpzze4ZC31uixfJABsj85SjC8m | 8rK4EjNoBLhBRibsG72Mc7UaEdMydcmYjewUKisZSXs4 | 914345 | 914345 | 2056381 |
3 | 2025-03-10 00:00:00.000 | AkjPESf57jfa4KQc3k1YjrZbbV3S6HwUXjuPCbs87jbp | FEbVToVDkdN2npga6xfxR7FMvJWQDS3aq2b8dD1CyqTR | 241413 | 241413 | 241413 |
4 | 2025-03-15 00:00:00.000 | HuTDmiJu4m7v9iJHjYjwpdyK4c8kAXkhyrecb729h4Yo | Gb47e6MUshyNFacoL3oBqNV5eDZSRw4GYqCdN79BKs3h | 1297482 | 1297482 | 1297482 |
5 | 2025-03-15 00:00:00.000 | BdNQKJw17jawL4qsKcydLHMMpUk7szcbf7oPAdF5sbFN | 4XBJaWLJQkwUXW8esbscxDeiZ3xtuQ59jBNqLyb8kH8t | 4038633 | 4038633 | 25124542 |
6 | 2025-03-20 00:00:00.000 | 9WBBWz4PJ1MadPk91KJAsXWRmFfUK9WbytSRvERz7sMm | EP9puYSgRLBmCa1CGTmZUTdCgPzZ3Mj5NVC59pZPRbws | 2374515 | 2374515 | 3254103 |
7 | 2025-03-20 00:00:00.000 | GW28A2tCCd2Z976wLxYSEtEpRcay5EgscyuXLN5fBMEe | BtcMaFQ4pcB8cHYR5eLX3vAZyMjCF2MAgCj5aMYr2g2P | 2898360 | 2898360 | 5255899 |
8 | 2025-03-21 00:00:00.000 | 4yMpTZKkug7cgTPQERDBZ35qo4pUV6KANN1RZVyszdYZ | C4v7N8oraBpV4ACZa9q5HawmHkhrKTaZsGR9Fu787QML | 1703291 | 1703291 | 25659924 |
9 | 2025-03-21 00:00:00.000 | HeRYysmTv3gxpBrngirUau5UnwJ6ZxULSCU7sCFmLpXf | 2GFNKqYbVQD9qbEEig5PHEo2RjYc8Ax6nw37RmYs6s71 | 2057389 | 2057389 | 33722438 |
10 | 2025-03-21 00:00:00.000 | FTZpQHfqWkk9W9uvP9VXu9EDJYezbWJdYqpcKJ9iYtpF | k4mbsAN2N7cz4EPhBasaRTMqG1DHtpAjQKfDaDn3aeS | 1369525 | 1369525 | 25361953 |
11 | 2025-03-19 00:00:00.000 | FGymLRyvMYVEA1eV2FcB7v7e3rcNN1XNE34MNhrSCw61 | qaH3K7nZZ4GaCH1a6p2dXwWCBM5abkqFomtXJBC3mA3 | 5672910 | 5672910 | 5672910 |
12 | 2025-03-26 00:00:00.000 | ARgWiVzPsdTFr5xUus8DpCkK63BsS5xAc54StfFTRvu | HYVAof2756zH7WBZCSsQmZHvVYEyLffS97k4GR9VVHtM | 5411680 | 5411680 | 51409345 |
13 | 2025-03-24 00:00:00.000 | AJ2snfS7NfLDJtiBfvG9Kodi51X17rvYx4t6H4MoSTyd | 3v8gBRRwMfBXD2RojYXaC3t4MLf7C3WWZdJrJtLVdjBm | 1201088 | 1201088 | 15257735 |
14 | 2025-03-24 00:00:00.000 | 4yMpTZKkug7cgTPQERDBZ35qo4pUV6KANN1RZVyszdYZ | DDdAJk2KZZtJNVa7J1qdRzMW4tgfvJLrjMhU5Ct12uwy | 3341962 | 3341962 | 22964127 |
15 | 2025-03-18 00:00:00.000 | 4yMpTZKkug7cgTPQERDBZ35qo4pUV6KANN1RZVyszdYZ | 6a39kT6DVEJVrsjbxvL7fen4UXaiS7V9bbVRwzD6zm9c | 3954264 | 3954264 | 23973071 |
16 | 2025-03-18 00:00:00.000 | 4yMpTZKkug7cgTPQERDBZ35qo4pUV6KANN1RZVyszdYZ | 5SfP3ZSf1G7YXH1UjmLiymJgTTpraQK5XyhWjX5W9SXo | 1264241 | 1264241 | 23973071 |
17 | 2025-03-18 00:00:00.000 | 8nzmGP2QjgRkS3MoMSmiHhqK6ocXz84Z7ULrQBuVcAXf | 8YSPuqEqtgEjGQBEZ9ZfSGxmiUFbPn1Yes5XqUTKs4W7 | 1886662 | 1886662 | 14674822 |
18 | 2025-03-18 00:00:00.000 | 8nzmGP2QjgRkS3MoMSmiHhqK6ocXz84Z7ULrQBuVcAXf | JDrWj6tAgMRbMuWcRJbUzMxUzGydsr1HJkH26QkG3tJh | 911442 | 911442 | 14674822 |
19 | 2025-03-26 00:00:00.000 | DFwrispFQs1bW9FZ6CLNXa3ZQcEtJAB9aTcuZcWqrFtC | Gg4TRJxqg8phhbGAcPUwxiS2R1iQbduydZ2UWXKS8h53 | 584792 | 584792 | 9067757 |
20 | 2025-03-29 00:00:00.000 | DFwrispFQs1bW9FZ6CLNXa3ZQcEtJAB9aTcuZcWqrFtC | AA36fx9q1o3MquWxDQ98YjPPvSv2gw8wNrgFrT9acx5V | 2422368 | 2422368 | 10614926 |
AephiaRQ - Cargo fleets | costs result
Updated 9 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 cargo_fleets AS (
SELECT
player_profile::string as player_profile
,cargo_fleet::string as cargo_fleet
FROM $query('922b409d-44d2-4c5d-b9f5-bffbc4b42b39')
)
,costs AS (
SELECT
date_trunc('day', block_timestamp::date) as date
,c.player_profile
,c.cargo_fleet
,sum(case when value:parsed:info:mint = 'fueL3hBZjLLLJHiFH9cqZoozTG3XQZ53diwFPwbzNim'
then value:parsed:info:amount
end) as fuel_payed
,sum(fuel_payed) OVER (partition by date, player_profile, cargo_fleet) as fuel_cargo_daily_cf
,sum(fuel_payed) OVER (partition by date, player_profile) as fuel_cargo_daily_pp
from cargo_fleets c,
solana.core.fact_events
, lateral flatten(input => inner_instruction:instructions)
WHERE program_id IN ('SAGE2HAwep459SNq61LHvjxPk4pLPEJLoMETef7f7EE')
AND succeeded = 'true'
AND value:parsed:type = 'burn'
AND instruction:accounts[3] = c.cargo_fleet
AND block_timestamp > current_date-30 AND block_timestamp < current_date
group by 1,2,3
)
Last run: about 9 hours ago
...
8808
1MB
13s