SpecterLeaderboard key
    Updated 2024-07-27
    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