amelia-leeFIRSSSSSSSSSSSSSSSST
Updated 2022-12-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
⌄
WITH
CLAIM AS (SELECT * FROM ethereum.core.ez_token_transfers WHERE CONTRACT_ADDRESS = '0x44108f0223a3c3028f5fe7aec7f9bb2e66bef82f' AND FROM_ADDRESS = '0xe50b2ceac4f60e840ae513924033e753e2366487')
SELECT EVENT_NAME, COUNT (DISTINCT L.TX_HASH) AS TXN, COUNT (DISTINCT L.ORIGIN_FROM_ADDRESS) AS USERS
FROM ethereum.core.fact_event_logs L
LEFT JOIN CLAIM C ON C.TO_ADDRESS = L.ORIGIN_FROM_ADDRESS
WHERE L.TX_HASH NOT IN (SELECT TX_HASH FROM CLAIM) AND L.CONTRACT_ADDRESS = '0x44108f0223a3c3028f5fe7aec7f9bb2e66bef82f'
AND L.BLOCK_TIMESTAMP < CURRENT_DATE -1 AND EVENT_NAME IS NOT NULL
AND L.BLOCK_TIMESTAMP > C.BLOCK_TIMESTAMP
GROUP BY 1
/*
SELECT COUNT (DISTINCT TX_HASH) AS TXN, COUNT (DISTINCT TO_ADDRESS) AS USERS
FROM ethereum.core.ez_token_transfers WHERE CONTRACT_ADDRESS = '0x44108f0223a3c3028f5fe7aec7f9bb2e66bef82f' AND FROM_ADDRESS = '0xe50b2ceac4f60e840ae513924033e753e2366487'
*/
Run a query to Download Data