oscarqphishing_token_creation_part_2
Updated 2025-01-01
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
›
⌄
-- forked from phishing_token_creation_all @ https://flipsidecrypto.xyz/studio/queries/45d5bbbe-51c7-466a-9cbd-d57c971c5082
SELECT
pc.address,
pc.symbol,
pc.name,
pc.creator_address,
pc.created_block_timestamp,
'bsc' AS blockchain
FROM
bsc.core.dim_contracts pc
LEFT JOIN
bsc.defi.dim_dex_liquidity_pools t1 ON pc.address = t1.pool_address
WHERE
(LEN(pc.symbol) > 9 OR LEN(pc.name) > 9)
AND pc.created_block_timestamp BETWEEN CAST('{{initial_date}}' AS timestamp) AND CAST('{{final_date}}' AS timestamp)
AND t1.pool_address IS NULL
AND (pc.symbol LIKE '%.%' OR pc.name LIKE '%.%')
UNION ALL
SELECT
pc.address,
pc.symbol,
pc.name,
pc.creator_address,
pc.created_block_timestamp,
'polygon' AS blockchain
FROM
polygon.core.dim_contracts pc
LEFT JOIN
polygon.defi.dim_dex_liquidity_pools t1 ON pc.address = t1.pool_address
WHERE
(LEN(pc.symbol) > 9 OR LEN(pc.name) > 9)
AND pc.created_block_timestamp BETWEEN CAST('{{initial_date}}' AS timestamp) AND CAST('{{final_date}}' AS timestamp)
AND t1.pool_address IS NULL
QueryRunArchived: QueryRun has been archived