Updated 2024-06-12
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
›
⌄
WITH Poly1 AS (
SELECT
'Polygon' as Blockchain
, Block_timestamp :: Date AS Day
, TX_HASH
, ORIGIN_FROM_ADDRESS
FROM
polygon.core.ez_token_transfers
WHERE 1=1
AND ORIGIN_TO_ADDRESS = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'
),
Poly2 AS (
SELECT
'Polygon' as Blockchain
, Block_timestamp :: Date AS Day
, TX_HASH
, ORIGIN_FROM_ADDRESS
FROM polygon.core.ez_decoded_event_logs
WHERE 1=1
AND ORIGIN_TO_ADDRESS='0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'
AND EVENT_NAME='LiFiGenericSwapCompleted'
AND TX_STATUS = 'SUCCESS'
)
SELECT
COUNT(DISTINCT p2.ORIGIN_FROM_ADDRESS) AS N_Users
, COUNT(DISTINCT p2.TX_HASH) AS N_Swaps
FROM Poly1 p1
JOIN Poly2 p2 ON p1.ORIGIN_FROM_ADDRESS = p2.ORIGIN_FROM_ADDRESS
AND p1.TX_HASH = p2.TX_HASH
QueryRunArchived: QueryRun has been archived