SpecterTransaction Over time
Updated 2024-07-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
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
DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS event_date,
COUNT(*) AS event_count
FROM Matrix_log
GROUP BY
event_date
ORDER BY
event_date DESC;
QueryRunArchived: QueryRun has been archived