USER_ADDRESS | |
---|---|
1 | 112uNfcC8iwX9P2TkRdJKyPatg6a4GNcr9NC5mTc2z3 |
2 | 11JZ2cCGYN2SQK6fWi23ttcXdReGAfs6Q6JNBEow3KG |
3 | 11Jx9XhFR4vyHHY1aWUGHrvesGCMKd76hNnu3R3FbNR |
4 | 11PeaAzXSsUtsAjD6XnHfnpvz9oMehpktM9cmc6RPBD |
5 | 11PtiWvwCMZ4XKFBnnNDeXQiBE5jBM5zWFCfRfd3EzW |
6 | 11Rp7hTrECW2sVfG6mp79vSo9Q5drZPkb4SUW5NFJfs |
7 | 11WisEqmDQjvP4XWR1HrUW8zDFGbEK6aVEcdkuQxYaz |
8 | 11byBUxiAhexD8R9t9pksr4guX6wKFhtuVdMZiDTeYo |
9 | 11cxWEfhcCs2g4hnFkz2wVDQvPKU5kHP5YX5yiE3Wdt |
10 | 11keciEgMCD2eKP8B6ZWaZH7yzQ8iBx5sXszBQT46uG |
11 | 11kkjAjRAnmS2j4LjdBdnnXPdWSi9YG61L7WBXgRb3e |
12 | 11nKeDbBRHjpgUttUGLJ2FujZTxvxSAstJG8UsLKyhP |
13 | 121C7swA7MaembPRxGgC4eQ6TFiPYsy3PPZpUyWF5yNT |
14 | 121GT9ioNtSwhEV1kDWMS6mzzWq77a5KoPHwmqAPeX1q |
15 | 121H2JwGqzxGrw8k1A6W7r5ydYPxD7FbMx9oXdtDmWXe |
16 | 121HQqLEzHN4jawTHjYVdzZfb8Li6HS8dS7h3sitcZRi |
17 | 121MSGpPmNTTDyV1xMocb6WKZEdrDHFfeR4zAnwphGfA |
18 | 121PcvEyXLc9pFrUopcetQnc8eunBMMVz5e7CrjYa4TG |
19 | 121Pt8E8sEYhkTdF5TPVerF12Cba1PBQEApsLQtWnvqE |
20 | 121V8rkWnm2CU6pbBJf8Gcd49EEvm29jDo7t4za1hNEs |
crypto_gostvital-bronze
Updated 2024-12-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
WITH early_supporters AS (
SELECT
DISTINCT purchaser AS user_address
FROM
solana.nft.fact_nft_sales
WHERE
block_timestamp::date >= '2021-09-01' AND block_timestamp::date <= '2022-06-30'
AND marketplace ILIKE '%magic eden%'
)
SELECT
user_address
FROM
early_supporters
ORDER BY
user_address;
Last run: 3 months ago
...
100000
5MB
6s