Phones Ordered | Total Sales Revenue | |
---|---|---|
1 | 55232 | 24853988.537814 |
piperSolana Saga 2 Pre-Orders: Revenue Summary copy
Updated 2025-01-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
-- 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
1
25B
68s