oscarqTRADERS_WHITE_LIST
Updated 2024-07-27
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
›
⌄
WITH SELECTION AS (
SELECT
BLOCK_TIMESTAMP,
TX_HASH,
ORIGIN_FROM_ADDRESS AS PERSON,
ORIGIN_TO_ADDRESS,
CONTRACT_ADDRESS AS TOKEN_ADDRESS,
FROM_ADDRESS AS POOL_ADDRESS,
TO_ADDRESS AS PERSONCOMMON,
RAW_AMOUNT,
AMOUNT_USD,
SYMBOL
FROM
base.core.ez_token_transfers
WHERE
origin_to_address = '0x10547695106686d1bb4fdffe86aada2c2bac80f6'
)
SELECT
PERSON,
count(DISTINCT TOKEN_ADDRESS) AS token_count
FROM
SELECTION
GROUP BY
PERSON
ORDER BY
token_count DESC
QueryRunArchived: QueryRun has been archived