MrftiTensor users sales analysis
    Updated 2025-02-11
    with price_tbl AS (
    SELECT
    hour :: date as date,
    AVG(price) as price
    from
    solana.price.ez_prices_hourly
    where
    symbol = 'SOL'
    GROUP BY
    1
    ),
    tbl AS (
    SELECT
    marketplace,
    date_trunc (day ,block_timestamp) as "Date",
    tx_id ,
    purchaser,
    seller,
    sales_amount,
    sales_amount * price as "sale volume"
    FROM
    solana.nft.fact_nft_sales a
    JOIN price_tbl b ON a.block_timestamp :: date = b.date
    where
    marketplace in ('tensorswap'--,'magic eden v1', 'magic eden v2', 'Magic Eden')
    )
    and succeeded = 'true'
    )


    SELECT
    CASE
    when marketplace IN ('magic eden v1', 'magic eden v2', 'Magic Eden') then 'Magic Eden'
    when marketplace IN ('tensorswap') then 'Tensor'
    END as "Marketplace",
    CASE when "sale volume" <1 then 'Lower than 1$ NFTs'
    Last run: about 1 month agoAuto-refreshes every 12 hours
    Marketplace
    Tier
    Total volume (USD)
    Total volume (SOL)
    Total sales
    Total buyer
    Total seller
    1
    TensorLower than 1$ NFTs949426.87831676921571.6377083644151236460028240815
    2
    Tensor1-5$ NFTs5245680.32877923107014.3396421861957013165284172728
    3
    Tensor5-10$ NFTs12835995.6048788284225.7136066261689461133595116711
    4
    Tensor50-100$ NFTs43517916.70824421039270.2259747461626311140689799
    5
    Tensor10-50$ NFTs59706919.52228081385855.146124992658458237380191277
    6
    Tensor100-500$ NFTs222984588.7722635319070.014805921017160158309116094
    7
    Tensormore than 500$ NFTs419376158.4616228553043.239855212638456317051642
    7
    577B
    19s