crypto_edgarJUP Trading & Pricing
    Updated 2024-01-31
    WITH
    JUP_TRADES AS (
    SELECT
    BLOCK_TIMESTAMP,
    SWAPPER,
    SWAP_FROM_AMOUNT,
    SWAP_FROM_MINT,
    SWAP_TO_AMOUNT,
    SWAP_TO_MINT
    FROM
    solana.defi.fact_swaps
    WHERE
    SUCCEEDED
    AND BLOCK_TIMESTAMP >= '2024-01-26'
    AND SWAP_FROM_MINT = 'JUPyiwrYJFskUPiHa7hkeR8VUtAeFoSYbKedZNsDvCN'
    OR SWAP_TO_MINT = 'JUPyiwrYJFskUPiHa7hkeR8VUtAeFoSYbKedZNsDvCN'
    ),
    JUP_SOL_TRADES AS (
    SELECT
    BLOCK_TIMESTAMP,
    CASE
    WHEN SWAP_FROM_MINT = 'So11111111111111111111111111111111111111112' THEN SWAP_FROM_AMOUNT
    WHEN SWAP_TO_MINT = 'So11111111111111111111111111111111111111112' THEN SWAP_TO_AMOUNT
    ELSE 0
    END AS SOL_VOLUME
    FROM
    JUP_TRADES
    ),
    JUP_TRADES_USD AS (
    SELECT
    BLOCK_TIMESTAMP,
    DATE_TRUNC('Hour', BLOCK_TIMESTAMP) AS HOUR,
    CASE
    WHEN SWAP_FROM_MINT = 'So11111111111111111111111111111111111111112' THEN SWAP_FROM_AMOUNT
    WHEN SWAP_TO_MINT = 'So11111111111111111111111111111111111111112' THEN SWAP_TO_AMOUNT
    ELSE 0
    Last run: about 1 year ago
    No Data to Display
    0
    2B
    20s