No Data to Display
flipperjo0Arbitrum Check
Updated 3 hours ago
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 initial_addresses AS (
SELECT DISTINCT to_address
FROM arbitrum.core.ez_token_transfers
WHERE LOWER(contract_address) IN (
-- My Tokens --
LOWER('0xb1f6078fc1bc983f0ef549a44cfdf3d562b87e87'),
LOWER('0xcc2212fd511b5e13b52e0a89026adfb72114436a'),
LOWER('0x085712b410c637edc85ecf631857c74f5cdcd91e'),
LOWER('0xefb79d04aae9c1619aeea423f2685230a1d8d200'),
LOWER('0x72781516934b14ba8437e706B8b6E8c1bf81e840'),
LOWER('0xa6f061037B1a51Ec3d805CC3754F78d73507f57B'),
LOWER('0xed0055e681cd14dbe5e55d2421c8a9570c366cff'),
LOWER('0x7df5fa4290ffd07b158ea3e53cb234cd8cf3f4a3')
-- Competitors --
-- LOWER('0x5cbbd16a3ec33fbdbf7c000bd3eac377560b0adc'),
-- LOWER('0xd01a2c474f998ff7b402e81041576592d879577c'),
-- LOWER('0x06d81db8464bc020051acfea2d734e90da611e1a'),
-- LOWER('0xde7169fe7285aeb4a4a8aa6b4a33f425c1e843f9')
)
AND to_address IS NOT NULL
),
token_transfers AS (
SELECT
block_timestamp,
tx_hash,
from_address,
to_address,
amount,
amount_usd,
contract_address,
symbol,
'ERC20' AS transfer_type
FROM arbitrum.core.ez_token_transfers
WHERE to_address IN (SELECT to_address FROM initial_addresses)
AND amount_usd > 1
Last run: about 3 hours ago
0
2B
42s