SELECT BLOCK_TIMESTAMP, tx_hash,CONTRACT_ADDRESS, EVENT_NAME,

decoded_log as log, log:by AS Address

FROM polygon.core.fact_decoded_event_logs

Contract_address = '0x0f3284bfebc5f55b849c8cf792d39cc0f729e0bc'

And log:eventId = 'claimKey'

SELECT Date_trunc('Day',BLOCK_TIMESTAMP) AS Date, Address, Count(*)

FROM Matrix_log

GROUP BY Address, Date

ORDER By Date DESC

LIMIT 10;