SpecterBTC success rate
Updated 2024-10-01
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
›
⌄
WITH predictions AS (
SELECT
event_name,
COUNT(DISTINCT tx_hash) AS count
FROM blast.core.ez_decoded_event_logs
WHERE contract_address = '0xa56a95f41e64bc76cde7423ab2a2ee1763bd8bcc'
AND event_name IN ('EnterMoon', 'EnterDoom', 'Claim')
AND block_timestamp >= '2024-02-29'
AND tx_status = 'SUCCESS'
GROUP BY event_name
),
totals AS (
SELECT
SUM(CASE WHEN event_name IN ('EnterMoon', 'EnterDoom') THEN count ELSE 0 END) AS total_predictions,
SUM(CASE WHEN event_name = 'Claim' THEN count ELSE 0 END) AS successful_predictions
FROM predictions
)
SELECT
total_predictions,
successful_predictions,
CASE
WHEN total_predictions = 0 THEN 0
ELSE (successful_predictions * 100.0 / total_predictions)
END AS overall_success_rate_percentage
FROM totals;
-- WHERE contract_address IN ('0x693b37a9859ce9465fb2aadeb03811a26a0c37c0',
-- '0xa56a95f41e64bc76cde7423ab2a2ee1763bd8bcc')
QueryRunArchived: QueryRun has been archived