SpecterLeaderboard key
Updated 2024-07-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
WITH Matrix_log As (
SELECT BLOCK_TIMESTAMP, tx_hash,CONTRACT_ADDRESS, EVENT_NAME,
decoded_log as log, log:by AS Address
FROM polygon.core.fact_decoded_event_logs
where
Contract_address = '0x0f3284bfebc5f55b849c8cf792d39cc0f729e0bc'
And log:eventId = 'claimKey'
)
SELECT Address, MIN(To_Char(Block_timestamp, 'YYYY-MM-DD')) AS Start_date,
COUNT(*) AS key
FROM Matrix_log
GROUP BY Address
ORDER BY key desc
LIMIT 100;
QueryRunArchived: QueryRun has been archived