sarathbridger destinations_opt1
Updated 2022-09-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH
eth as (
SELECT
block_timestamp,
TX_HASH,
ORIGIN_FROM_ADDRESS
FROM
ethereum.core.fact_event_logs
WHERE
ORIGIN_TO_ADDRESS ilike '0x99C9fc46f92E8a1c0deC1b1747d010903E884bE1'
AND block_timestamp > CURRENT_DATE - INTERVAL '1 month'
AND TX_STATUS = 'SUCCESS'
)
, opt as (
SELECT
block_timestamp,
TX_HASH,
ORIGIN_FUNCTION_SIGNATURE,
EVENT_NAME,
ORIGIN_FROM_ADDRESS,
ORIGIN_TO_ADDRESS,
CONTRACT_NAME
FROM
optimism.core.fact_event_logs
WHERE
TX_STATUS = 'SUCCESS'
)
SELECT
CASE WHEN EVENT_NAME is null THEN 'Uncategorized' ELSE EVENT_NAME END as Actions,
COUNT(*) as cnt
FROM opt ntx
JOIN eth tx on ntx.block_timestamp BETWEEN tx.block_timestamp AND tx.block_timestamp + INTERVAL '24 hour'
GROUP BY 1
ORDER BY 2 DESC
Run a query to Download Data