crypto_gostvital-bronze
    Updated 2024-12-11
    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
    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
    ...
    100000
    5MB
    6s