0xallyzachpolygon first interactions
Updated 2023-06-14
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
›
⌄
-- forked from ethereum first interactions @ https://flipsidecrypto.xyz/edit/queries/b144f311-d8fc-4988-94df-1cf0270b8f3f
WITH all_users AS (
SELECT DISTINCT
nft_to_address AS user_address
FROM polygon.core.ez_nft_transfers
WHERE nft_address LIKE LOWER('0xDb46d1Dc155634FbC732f92E853b10B288AD5a1d')
UNION ALL
SELECT DISTINCT
from_address AS user_address
FROM bsc.core.fact_transactions
WHERE to_address LIKE LOWER('0x2723522702093601e6360CAe665518C4f63e9dA6')
UNION ALL
SELECT DISTINCT
from_address AS user_address
FROM ethereum.core.fact_transactions
WHERE to_address IN (
LOWER('0xdD2ec94890E2D92E131A89F73bFe124137E0C10E'),
LOWER('0xcE4F341622340d56E397740d325Fd357E62b91CB'),
LOWER('0xd9c225efcc4162173a7369a14fd559de4e4aadae'),
LOWER('0x8cc6517e45db7a0803fef220d9b577326a12033f'),
LOWER('0x57f1887a8BF19b14fC0dF6Fd9B2acc9Af147eA85'),
LOWER('0xE3b1D32e43Ce8d658368e2CBFF95D57Ef39Be8a6'),
LOWER('0xA1207F3BBa224E2c9c3c6D5aF63D0eb1582Ce587'),
LOWER('0xA7b39296258348C78294F95B872b282326A97BDF')
)
UNION ALL
SELECT DISTINCT
from_address AS user_address
FROM arbitrum.core.fact_transactions
Run a query to Download Data