TX_HASH | BLOCK_TIMESTAMP | TX_SIGNER | CHEF_FEE | CHEF_ID | DONATED_AT | DONOR_ID | ID | MATCHING_POOL | PROJECT_ID | PROTOCOL_FEE | TOTAL_AMOUNT | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 66wtFa21DfWY2DNK3wrwDFqhAmcSfMDzCYiLSX15zQMt | 2024-05-16 15:49:03.899 | davidmo.near | 1715874543899 | davidmo.near | 313 | false | agentswithbenefits.near | 0.025 | 1.25 | ||
2 | DMq4mLEuq2k2PCHdANbe6nXamr8zdWKgXQcHTNjDUMdC | 2024-05-10 00:12:48.094 | yearofchef.near | 1715299968094 | yearofchef.near | 204 | false | agentswithbenefits.near | 0.0005 | 0.025 | ||
3 | wvXXXcWgvTRZeLuUAy4G5VLXBfaHRpbFDVQsJPxUyLG | 2024-05-20 22:58:55.630 | efiz.near | 1716245935630 | efiz.near | 654 | false | agentswithbenefits.near | 0.002 | 0.1 | ||
4 | 2AvUwEWwHpcMpmnJ8XYLPKXnnSnmkESnap4dLUyi1cRk | 2024-05-18 02:17:44.287 | smartbread.near | 1715998664287 | smartbread.near | 398 | false | agentswithbenefits.near | 0.004 | 0.2 | ||
5 | 4cFAcUfwRLa9ns8MeXgQ4VSKWDZujM8KUVcUknrFYWHF | 2024-05-17 01:25:16.530 | bestram.near | 1715909116530 | bestram.near | 346 | false | agentswithbenefits.near | 0.004 | 0.2 | ||
6 | DV2dhSFn3tYH2xS7nqAib2NdpTC4ha9rL2jWFy7NA2a2 | 2024-05-08 05:42:59.560 | vandal.near | 1715146979560 | vandal.near | 168 | false | agentswithbenefits.near | 0.01 | 0.5 | ||
7 | BFUuidWR4vPvWr9x5G7GZYGA5WJqBETvoKcLE6MuGphQ | 2024-05-11 09:29:04.094 | magicbuild.near | 1715419744094 | magicbuild.near | 238 | false | agentswithbenefits.near | 0.002 | 0.1 | ||
8 | A3R4wSFMLh66yxZGX1KNbJR7edPoovo2S2zAYEpxxHtQ | 2024-04-30 04:32:15.770 | yearofchef.near | 1714451535770 | yearofchef.near | 9 | false | agentswithbenefits.near | 0 | 1 | ||
9 | BqensJVc6TQZj4eeAMfsmCMQjdCf4omgaf49CMVM6RSx | 2024-03-13 22:11:40.220 | agentswithbenefits.near | agentswithbenefits.near | ||||||||
10 | DV5t29msAJDGEg9ftuXMx5P91JoVL2zTq1gKiyzTmGat | 2024-04-24 12:06:27.136 | plugrel.near | agentswithbenefits.near |
datavortexeveryday-yellow
Updated 2025-04-28
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
›
⌄
⌄
⌄
SELECT
tx_hash,
block_timestamp,
tx_signer,
TO_DOUBLE(receipt_status_value:SuccessValue.chef_fee::STRING) / 1e24 AS chef_fee,
receipt_status_value:SuccessValue.chef_id::STRING AS chef_id,
receipt_status_value:SuccessValue.donated_at::STRING AS donated_at,
receipt_status_value:SuccessValue.donor_id::STRING AS donor_id,
receipt_status_value:SuccessValue.id::STRING AS id,
receipt_status_value:SuccessValue.matching_pool::STRING AS matching_pool,
receipt_status_value:SuccessValue.project_id::STRING AS project_id,
TO_DOUBLE(receipt_status_value:SuccessValue.protocol_fee::STRING) / 1e24 AS protocol_fee,
TO_DOUBLE(receipt_status_value:SuccessValue.total_amount::STRING) / 1e24 AS total_amount
FROM near.core.ez_actions
WHERE
tx_receiver = 'oss.v1.potfactory.potlock.near'
AND receipt_receiver_id = 'oss.v1.potfactory.potlock.near'
AND receipt_status_value:SuccessValue.project_id::STRING = 'agentswithbenefits.near'
--AND receipt_status_value:SuccessValue.total_amount::STRING IS NOT NULL
--AND TRY_TO_DOUBLE(receipt_status_value:SuccessValue.total_amount::STRING) IS NOT NULL
/*
select receipt_status_value from near.core.ez_actions
where tx_hash = '2uSXFkBE9ThxVZ8eRJHESB9ABDcbWFw4ebH3KTKjKv61'
and tx_receiver = 'ai.v1.potfactory.potlock.near'
and tx_signer = 'xclaim.near'
and receipt_receiver_id = 'ai.v1.potfactory.potlock.near'
*/
/*
select * from near.core.ez_token_transfers
where tx_hash = '4H5Um9o66sAKZATVZCiT3pGPvg2vHVhrY5pX2y4KAFzz'
Last run: 30 days ago
10
2KB
3s