DATE | PLAYER_PROFILE | FLEET | RENTAL_DAILY_PP | |
|---|---|---|---|---|
1 | 2025-06-09 00:00:00.000 | 6qCT5fUbMDUf2cyL4Bzu8qpojzHiGEfygaJWUsEpVgxJ | DKQgXNFKUyn6qnsZKUdFx6rPd3PjbBkEdm4g8ZESxqUN | 31456.23192126 |
2 | 2025-06-09 00:00:00.000 | Eyf2QJ8yTCu3ZXBz2V3x1J4xQ8twekMgGHChH4g6qA8 | HxAt9ujnUvPyH4xNexPgrPwWiH5ts3HGKd4pkLen8oBe | 55528.97436349 |
3 | 2025-06-09 00:00:00.000 | 6ngQnQ3DWJu3uW7hSZiwvLP9AF7g5AtsC4hhPJNCczFe | 3URVxfJst3cQokNb5T3MTP72zaKmEgcei47gx5PBFnZv | 41813.29052077 |
4 | 2025-06-09 00:00:00.000 | Eyf2QJ8yTCu3ZXBz2V3x1J4xQ8twekMgGHChH4g6qA8 | 3GewAmbfXfN3EekmmcX4dVdZJ1J1FXEra8AVZ12nmDak | 55528.97436349 |
5 | 2025-06-09 00:00:00.000 | Cdeu33QnaRP4WSfyy71BDq8kf4gXKJDLw145AAz5eSVS | CipTKfcA91VrnSLRuFrvTGzDqh7kqE58rcfFj5T9UFKF | 809.86093749 |
6 | 2025-06-09 00:00:00.000 | 6m6pZaxDyhZbD81dV96h25ifcEev2i4oxkyUQ9C8TpzL | g6e7Nv9AdRiV3v8K6fS32Xb9mwjXLUqSbMGg4oKAPUe | 540 |
7 | 2025-06-09 00:00:00.000 | 6ngQnQ3DWJu3uW7hSZiwvLP9AF7g5AtsC4hhPJNCczFe | Bg7djJ5yY95Eoogqzq97APgmvH2DWiJJ69zt6CdXLydo | 41813.29052077 |
8 | 2025-06-09 00:00:00.000 | EgsDNawFAPQELxAFyGyKCy19R1dxvHwv8SpNeL2RtY7Z | 3vaLRLasonJPRRtVMvX7FRMydcNUzQVcC4tqnohpKPse | 3780.21913203 |
9 | 2025-06-09 00:00:00.000 | FLAgMPTtz1ATevuq7ho6gmW6M9XzH7kRYf98GXxnWw4p | yvA9q8Dww4x7Fey62JqYvm9KhQi4v339BdaVENUn8qj | 260.89125 |
10 | 2025-06-09 00:00:00.000 | BbNz6uXKiyGRQZHR9FdPS1agh6QFDo6LkCUmTB2TBkWf | Hj4NzNgtPd97nsPeGLTGbvMgraXwNMGrhf4HkayGuYi3 | 1080.0125 |
11 | 2025-06-09 00:00:00.000 | 6Ca249RFFboehzvidJS3KLn7N39oGGoxohXnzjBCTf3h | AuCU6wUqbkqKs14Bjv6W3mMhutHnjuvYPdMMbaFgfRNL | 4428.57083332 |
12 | 2025-06-09 00:00:00.000 | 7n6Cri3PX7MxpyN2CXYjq3S8xzrBTUjtjcAVxoU3Y9D3 | EWQuPxwtbBNvHbtoeGxg97gkj6ked1rjA1UTMJPpgWCi | 539.99166665 |
13 | 2025-06-09 00:00:00.000 | 8r8yMmVstoEqoxR95wnox23zPqF14TZJCJ8Pm2SaZoun | 6nKZaeCd1AXB13fYyS998EmyAitC9XDwsKMWqnqQhLVx | 449.78645833 |
14 | 2025-06-09 00:00:00.000 | 6cSZ6CaRLRs5LG7hJnbJ2LUZPMwRNRDUZ2UGaachovZH | CvJvQWKBkgQFoChVAwahrg4aGfdKGEBjxSsB3i6cBoH | 7507.36739581 |
15 | 2025-06-09 00:00:00.000 | Fkh4JGVkQ3rKHjFQ1ZDjmj2QhHC3CuXpeEbHCsSLEZhQ | CTfziWrjKxY3MEe4DKpADWVTWYs5doqYYxBSUEFKEZPx | 2047.23177083 |
16 | 2025-06-09 00:00:00.000 | C5JxQEG8MaEW1yaFCyTx4W3byn4igVZirqjwc3uWXMWP | 4Ur5MJshNziMAiP5CvqQ2PUJJiBQiwCVJfHBaVbZxAuU | 831.96148148 |
17 | 2025-06-09 00:00:00.000 | FxQfrmBjoJnCkpN94jCxrTWsi5u4iYwaXXdgH6YXiUW6 | Cbtt44As6JfFKqXDBbBqXDPf6EhoS4eWFZ2vezr91GWc | 20616.54214131 |
18 | 2025-06-09 00:00:00.000 | HGQb6qsBFyDG1gCkufNV5iUtWRfLB8ypF1Z9KsMuYAig | 6UxC1capdjuEqgapvCzyzFugfJtjCF5jdvE8Z3LgQVEH | 6080.06979164 |
19 | 2025-06-09 00:00:00.000 | 4izccJWvLaJ1zccuz7ZCdwKGN9E9EpMej4kLAgkZd13B | EwpSn4vimSJUs5AQSh7SGdR917wuAJtosykbdM1wmwsK | 5699.49872684 |
20 | 2025-06-09 00:00:00.000 | 9HGyZwkBBbawfXhtmb3Wzvb2W8krhm4pwHSk7bYnv7s7 | 2fBKMXXTsFcr9H9J8dV2H72jAdmgd7nYV5vPJpkJGuGp | 899.60416666 |
AephiaRQ - Fleet Rentals pay_rental
Updated 5 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 profile_wallets AS (
SELECT
*
from $query('0ad41d79-7bb8-4c48-b8e5-84298cf10a82')
)
,lender_income AS (
SELECT
--fe.*
--/*
date_trunc('day', block_timestamp::date) as date
,tx_id
,pw.player_profile as player_profile
,instruction:accounts[10] as fleet
,value:parsed:info:amount / POW(10,8) as pay_rental
,sum(pay_rental) OVER (partition by date, player_profile) as rental_daily_pp
--*/
from profile_wallets pw
,solana.core.fact_events fe
, lateral flatten(input => inner_instruction:instructions)
WHERE program_id = 'AgThdyi1P5RkVeZD2rQahTvs8HePJoGFFxKtvok5s2J1'
AND value:parsed:type = 'transfer'
AND instruction:accounts[5] = 'SRSLY1fq9TJqCk1gNSE7VZL2bztvTn9wm4VR8u8jMKT'
AND instruction:accounts[8] IN (pw.wallet)
AND instruction:accounts[11] = 'GAMEzqJehF8yAnKiTARUuhZMvLvkZVAsCVri5vSfemLr'
AND block_timestamp > current_date-30 AND block_timestamp < current_date
group by 1,2,3,4,5
)
Last run: about 5 hours ago
...
29076
4MB
6s