DATE | PLAYER_PROFILE | FLEET | RENTAL_DAILY_PP | |
|---|---|---|---|---|
1 | 2025-05-29 00:00:00.000 | E6PtE1HaQCL4w6J94MR5PDMYa9rtssLodMPwvxF1ub4f | FYkc1kcY6LQKGTQ3nL77aZc9zpvR9pUfmrSUC2dJ94Z4 | 5858.13020834 |
2 | 2025-05-29 00:00:00.000 | 6qLAYUeHvxRBL1xq7DRKqF6BrFoyY8GKV27avVpdjCYQ | Bf4frq5oyagGBNH621SA6ShMoLeCnd3iEWXw7zTAwp2z | 636.32378471 |
3 | 2025-05-29 00:00:00.000 | F73SoNgoJ1WCYSpWaCzYky9JSwhY2JAA2ZwzutT3vAHt | 8HSZokWMSifH5RxnuYohqFLFML3GaTPEj8RbNS4z2aWp | 29067.4489583 |
4 | 2025-05-29 00:00:00.000 | 24sZv3YtibHmCbH59sHurUKDogwEQHoEJggn5gR6ob2W | CBqDU7bASGZeGGzEHzxXrJhqn11NSsd7L4b245mSb8un | 179.97708333 |
5 | 2025-05-29 00:00:00.000 | F5p2QY3XbNVwquGyHD2YBBVM3EK1aGJjfB7rrJvReLST | FYcwf7n4jcTsKYrhvcZqTqKHg1AnLjmxUqz82RbswdGc | 15615.44270841 |
6 | 2025-05-29 00:00:00.000 | AQvbLmY3JVVz2qPfsBmxMfDkhU36k2mnKfSGvsGNq9bA | FMvjPYobBRMoXeeyJVwCu146Pz6m573uKfzC6SqQAnaF | 71003.02818285 |
7 | 2025-05-29 00:00:00.000 | Fkh4JGVkQ3rKHjFQ1ZDjmj2QhHC3CuXpeEbHCsSLEZhQ | CTfziWrjKxY3MEe4DKpADWVTWYs5doqYYxBSUEFKEZPx | 2024.82552083 |
8 | 2025-05-29 00:00:00.000 | 5WY151bvHyZzAeezkRFTwygdmJM3EcFnoT6QwXbgtdev | 5PGVeQvmYWi4YueZNG3rAQCnnoj6A6oNPg735sKi21uq | 19191.16666665 |
9 | 2025-05-29 00:00:00.000 | 2UVkB6muRxaaRqumuvyhxVT3x64pgKWBfjZV84FXUVye | CGKRyZAdiudkNuBjtgjveoEREq4ZZUEUdw2K1EaD2AQm | 5534.39895831 |
10 | 2025-05-29 00:00:00.000 | AEiFikof7KvVqvCLUZkL2oUxB3xkk1qpRKKLCBukn64 | 13WxKShqgbiobm3ijvUj9gbnCBMusKyXoubJ6mXU9HUn | 1692.03916666 |
11 | 2025-05-29 00:00:00.000 | HfqLWP66Z6CCqquFEXZrmFPxYXnhpyyGDq9tGkpSagc7 | Bhq5SbGjJbHQRpA8NKTrBEnXgyS7CRH4P4ZGWAgMZQ1B | 18164.40542936 |
12 | 2025-05-29 00:00:00.000 | Hgb2UxFhAsYLGPdvK5oxTY87jbQkRxgeGoj54HE6CUm1 | D9gGE4Fq54WCGqPvbQ19do5CFLrkiK1D7Jjwb5gunCd7 | 27561.60833339 |
13 | 2025-05-29 00:00:00.000 | 6zsFQ3g6ZrbCZ1S4pmir2g2Wosebbm4CFz49aqvPRz77 | 5pdMjGHRC6k2m8mfnDaST6oehozj2fZBnC781UdKAQYZ | 1841.03925929 |
14 | 2025-05-29 00:00:00.000 | 2187Kyeid6AMMDMH6GQwbjgauuA2AUUmDxzJab9PLy4U | 8BN28wEe52MfFS4vHT7nJ7Ua38921Jac61yT8dLVQJ9p | 33997.98287032 |
15 | 2025-05-29 00:00:00.000 | 7n6Cri3PX7MxpyN2CXYjq3S8xzrBTUjtjcAVxoU3Y9D3 | EWQuPxwtbBNvHbtoeGxg97gkj6ked1rjA1UTMJPpgWCi | 539.93749999 |
16 | 2025-05-29 00:00:00.000 | 5uWN7Dt3audVaT5AcxLnt2Gu7CtcKeBXRhwoAxrHVcR4 | 7wLm3ioKEMSQUmY6WamsYa2uQhyj3JNggG3oD6fDzDff | 4364.43281249 |
17 | 2025-05-29 00:00:00.000 | Eyf2QJ8yTCu3ZXBz2V3x1J4xQ8twekMgGHChH4g6qA8 | DhDz2XgyyTD72pZQF8JL8AHKH6U2GFHTqTukn5SbXqD6 | 42961.56520824 |
18 | 2025-05-29 00:00:00.000 | CBe9YTX24cuDHKibrkgq4gSWyBzTUqw7hpoe6wmhy8sg | 9GaGPLEULpg5kFtb5jbZEC1jW3PZQDTSwbKt49HA2MTt | 899.92708333 |
19 | 2025-05-29 00:00:00.000 | AQvbLmY3JVVz2qPfsBmxMfDkhU36k2mnKfSGvsGNq9bA | 3xmgeP4kuMTniNnd9ffLgHhNemoC6xH3WmxSrBM6MzUe | 71003.02818285 |
20 | 2025-05-29 00:00:00.000 | Eyf2QJ8yTCu3ZXBz2V3x1J4xQ8twekMgGHChH4g6qA8 | 3gvvbmzxCopxfT2A8dQkuAN2CuRR4Kgck9GxxKPEDanD | 42961.56520824 |
AephiaRQ - Fleet Rentals pay_rental
Updated 16 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 16 hours ago
...
28890
4MB
7s