clayopBASIC_Duplicated_Deposit
Updated 2023-09-01
999
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 upbit as(
SELECT
DISTINCT FROM_ADDRESS AS DEPOSIT_ADDRESS
FROM
ethereum.core.ez_token_transfers
WHERE
CONTRACT_ADDRESS = LOWER('0xF25c91C87e0B1fd9B4064Af0F427157AaB0193A7')
AND TO_ADDRESS IN (
'0x653a20e7fbc1be7d6c437f8b16600fbf052d6c82',
'0x74426384e69f3fadd11751a9aaa017c282994119',
'0x1938a448d105d26c40a52a1bfe99b8ca7a745ad0'
)
AND FROM_ADDRESS NOT IN (
'0x653a20e7fbc1be7d6c437f8b16600fbf052d6c82',
'0x74426384e69f3fadd11751a9aaa017c282994119',
'0x1938a448d105d26c40a52a1bfe99b8ca7a745ad0'
)
),
from_to AS (
SELECT DISTINCT
FROM_ADDRESS,
TO_ADDRESS,
SUM(AMOUNT) AS AMOUNT
FROM
ethereum.core.ez_token_transfers
WHERE
CONTRACT_ADDRESS = LOWER('0xF25c91C87e0B1fd9B4064Af0F427157AaB0193A7')
AND DATE(BLOCK_TIMESTAMP) >= '2022-07-01'
AND TO_ADDRESS IN (
SELECT
DEPOSIT_ADDRESS
FROM
upbit
)
AND FROM_ADDRESS NOT IN (
Run a query to Download Data