arabianhorses-jZtVNa2023-08-17 11:42 AM
Updated 2023-08-17
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
hashes AS (
SELECT TX_HASH FROM external.tokenflow_starknet.decoded_events
WHERE CHAIN_ID = 'mainnet'
AND NAME = 'Transfer'
AND PARAMETERS[1]:value = '0xc377d07b442932b4c0b8cfa3f2579efe593a63b07fa3424dbf3d40b12576c5' --marketFeeCollector
AND TIMESTAMP BETWEEN '2023-08-14 15:29:00' AND '2023-08-16 16:31:00'
AND CONTRACT = '0x049d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7' --starkgateETH
)
, userAddresses AS (
SELECT
PARAMETERS[0]:value AS userAddress --buyer
, TX_HASH AS hash
FROM external.tokenflow_starknet.decoded_events
WHERE CHAIN_ID = 'mainnet'
AND PARAMETERS[1]:value != '0xc377d07b442932b4c0b8cfa3f2579efe593a63b07fa3424dbf3d40b12576c5' --marketFeeCollector
AND CONTRACT = '0x049d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7' --starkgateETH
AND TX_HASH IN (SELECT TX_HASH FROM hashes)
UNION ALL
SELECT
PARAMETERS[1]:value AS userAddress --seller
, TX_HASH AS hash
FROM external.tokenflow_starknet.decoded_events
WHERE CHAIN_ID = 'mainnet'
AND PARAMETERS[1]:value != '0xc377d07b442932b4c0b8cfa3f2579efe593a63b07fa3424dbf3d40b12576c5' --marketFeeCollector
AND CONTRACT = '0x049d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7' --starkgateETH
AND TX_HASH IN (SELECT TX_HASH FROM hashes)
)
SELECT userAddress, MAX(hash) FROM userAddresses GROUP BY 1
Run a query to Download Data