VALUE:PARSED:INFO:DESTINATION | TXS | ATLAS_RENTAL | |
|---|---|---|---|
1 | 5a4MpT9evb7p8m1YpLnubfgs1ZYKv67RGcSMQYVBguCA | 1 | 8991 |
2 | BNkd2hxaBPSAkS7bghwURKKQLMScTRSvDDrmYWGWSdFP | 1 | 157.5 |
3 | 4JgWwPZZwGpCuKJrkE7aTK89dhPB7cGSjkUNnUCoSoHj | 1 | 69300 |
4 | E1C7geqeNRsfRDpB6T2qw7NUBVPdnkjk9T4fF1v8Xwn6 | 2 | 1125 |
5 | 3UyaS8xJHsDJBuFYVVZLVnj3UyCF96H3NxmxGF5qqYZo | 1 | 900 |
6 | 46Njbi6gzpymuFg3iTbpUNvt5DyNberq2nLQZPWJnXuk | 1 | 11700 |
7 | ERLDUznFEGNNcVXVJ82pLGC2jv1vz8qSXhGLTbRHJz7R | 1 | 3240 |
8 | 4CtarUtnKBuvKvKbDD3h6tfGvTaqCRMEoybFAAJmY4id | 1 | 3915 |
9 | HLm5gKXUAdNbdfmfpLa4HNtfyFriRZuzXSDxscqU6mVB | 1 | 6912 |
10 | HXgKw9EvPcG6vLxkp1JWr1JtWPPi5r8msKPeMBewRMir | 1 | 5400 |
11 | CX4A2k1fu51VG1rwYQgE2PEHTfjD91R4FKNnwG7s2VeG | 1 | 9720 |
12 | DSiA6Q4zGHmSMb6e5CpbknDWm7M8rpuWXmL1vxmWja8F | 1 | 6480 |
13 | GmAQSkU24oT6MrbR3MXT5g2yb6bbbsg5Tw5wS2YW9k8b | 1 | 19440 |
14 | EXZJmMcKGvPzcF2Y5zTBn7BAnxo6s3i2vdoi9n4gCaCx | 1 | 17280 |
15 | A42C5oomNKEuhMjKKHhhw53gDBUFrEbYm3NLP9R5phVd | 1 | 172800 |
16 | A9EnMd91s2PoeHcdN7SHnez9puWK2C4ym7oqaJzpKXaN | 2 | 388800 |
17 | AZzDRDXLGkd9K8eriPCnTme4FQHWCZjDvMQfPeYgDA2f | 1 | 54000 |
18 | 4eHn83A5g586UTC6fG3J86Zca2RjiufrUirLha8LRTuL | 1 | 3600 |
19 | BaVLTzQUc1bxpT6MwWqgqSJw6DWiBm6KJvVFKhbKdA3Z | 1 | 27000 |
20 | 6HJ32UMqTgWRVuWrRW1vcp5AyTxrPvQu67RC5QT6K42a | 1 | 9450 |
steven-sabol-dir-of-economyordinary-aqua
Updated 2025-03-21
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
›
⌄
-- ,pay_rentals AS (
select
--fe.*
-- date_trunc('day',block_timestamp::date) as date,
value:parsed:info:destination,
count(tx_id) as txs,
sum(value:parsed:info:amount) / POW(10,8) as atlas_rental
FROM solana.core.fact_events fe
inner join solana.core.fact_transactions ft USING(block_timestamp, tx_id, succeeded)
, lateral flatten(input => inner_instruction:instructions)
WHERE program_id = 'SRSLY1fq9TJqCk1gNSE7VZL2bztvTn9wm4VR8u8jMKT' --Fleet Rentals
AND ft.log_messages::string LIKE '%AcceptRental%'
AND succeeded = 'true'
and value:parsed:info:amount > 0
AND block_timestamp > current_date-30 AND block_timestamp < current_date
group by 1
-- SELECT
-- date_trunc('day', block_timestamp::date) AS date,
-- 'Marketplace Fees' as name,
-- -1*sum(value:parsed:info:amount) as value
-- from solana.core.fact_events, lateral flatten(input => inner_instruction:instructions)
-- WHERE program_id = 'SRSLY1fq9TJqCk1gNSE7VZL2bztvTn9wm4VR8u8jMKT'
-- and value:parsed:info:destination = '4JNeLiZwa9AQz6iqfRXAbtZesNrfAHcM6cA7GHCicu6G'
-- AND date_trunc('day', block_timestamp) > current_date - 45
-- -- '2023-06-01' --AND date_trunc('day', block_timestamp) < '2023-01-01'
-- GROUP BY 1,2
Last run: about 1 month ago
...
1258
69KB
133s