piperSolana Saga 2 Pre-Orders: Revenue Summary copy
    Updated 2025-01-25
    -- forked from cache__only / Solana Saga 2 Pre-Orders: Revenue Summary @ https://flipsidecrypto.xyz/cache__only/q/nuDKA6EuvENA/solana-saga-2-pre-orders-revenue-summary

    -- forked from Solana Saga 2 Pre-Orders: Order Count @ https://flipsidecrypto.xyz/edit/queries/34fac64a-f744-4405-b11a-d1b9e3b2d23a

    WITH preorders AS (

    SELECT
    solana.core.fact_transfers.block_timestamp, solana.core.fact_transfers.tx_id, solana.core.fact_transfers.amount
    FROM
    solana.core.fact_transfers
    WHERE
    solana.core.fact_transfers.block_timestamp >= '2024-01-16'
    AND solana.core.fact_transfers.mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
    AND solana.core.fact_transfers.tx_to = '5EiuwvpjXx44QRi5ro48DwBkUeaQ3VHNKVtkLdZJy9P3'
    AND solana.core.fact_transfers.amount between 440 AND 460
    AND solana.core.fact_transfers.index = '2'
    )

    SELECT COUNT(preorders.tx_id) AS "Phones Ordered", SUM(preorders.amount) AS "Total Sales Revenue"
    FROM preorders



    Last run: 23 days ago
    Phones Ordered
    Total Sales Revenue
    1
    5523224853988.537814
    1
    25B
    68s