DISTINCT_SIGNER_COUNT | DISTINCT_TX_COUNT | TOTAL_AMOUNT | |
|---|---|---|---|
1 | 29 | 29 | 6.966666667 |
datavortexunexpected-pink
Updated 10 days 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
›
⌄
⌄
/*
SELECT
receipt_status_value:SuccessValue.chef_fee::STRING 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,
receipt_status_value:SuccessValue.protocol_fee::STRING AS protocol_fee,
receipt_status_value:SuccessValue.total_amount::STRING AS total_amount
FROM near.core.ez_actions
WHERE tx_hash = '4H5Um9o66sAKZATVZCiT3pGPvg2vHVhrY5pX2y4KAFzz'
AND tx_receiver = 'ai.v1.potfactory.potlock.near'
AND tx_signer = 'louishoang.tg'
AND receipt_receiver_id = 'ai.v1.potfactory.potlock.near';
*/
SELECT
COUNT(DISTINCT tx_signer) AS distinct_signer_count,
COUNT(DISTINCT tx_hash) AS distinct_tx_count,
SUM(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 ='bosmobile.near'
AND receipt_status_value:SuccessValue.total_amount::STRING IS NOT NULL
Last run: 10 days ago
1
21B
4s