No Data to Display
crypto_edgarJUP Trading & Pricing
Updated 2024-01-31
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
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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
0
2B
20s