No Data to Display
jackguySubmissions per user
Updated 2024-01-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with tab1 as (
SELECT
DISTINCT tx_hash
from polygon.core.fact_transactions
WHERE to_address IN (lower('0x496804C528146315E136570daAAC5A1509F739e3'), lower('0xf630258aeC30cE84e91f29a5579082d2BA2374aD'))
)
SELECT
decoded_log:fulfiller as user,
count(DISTINCT decoded_log:requestId) as submissions
FROM polygon.core.fact_decoded_event_logs
WHERE tx_hash in (SELECT * FROM tab1)
AND event_name LIKE 'RequestFulfilled'
AND block_timestamp > current_date - 14
GROUP BY 1
ORDER BY 2 DESC
Last run: about 1 year agoAuto-refreshes every 3 hours
0
2B
10s