freemartianBasepaint Paints Trades
    Updated 2023-11-29
    -- forked from Basepaint Brush Trades @ https://flipsidecrypto.xyz/edit/queries/0256f422-5f8c-4296-8369-8e71b3c309ff

    WITH datas AS(
    SELECT
    DISTINCT from_address AS user
    FROM base.core.fact_transactions
    UNION
    SELECT DISTINCT to_address AS user
    FROM base.core.fact_transactions
    ),

    paints AS (
    SELECT
    tx_hash,
    seller_address,
    buyer_address,
    price,
    platform_fee,
    creator_fee
    FROM base.nft.ez_nft_sales
    WHERE nft_address = '0xba5e05cb26b78eda3a2f8e3b3814726305dcac83'
    AND event_type = 'sale'
    ),

    users AS (
    SELECT
    DISTINCT user FROM datas
    WHERE user IN (SELECT seller_address FROM paints) OR user IN (SELECT buyer_address FROM paints)
    ),

    first_users_activities AS(
    SELECT
    user,
    block_timestamp,
    Run a query to Download Data