StangFAST04 - 1 - Jupiter V.3 [ token ]
Updated 2023-09-03
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
›
⌄
-- forked from 04 - 1 - Jupiter V.3 [ token ] @ https://flipsidecrypto.xyz/edit/queries/027ee63d-085f-4076-81ee-a76937b2b388
-- forked from 03 - Jupiter V.3 [ swap volume ] @ https://flipsidecrypto.xyz/edit/queries/ccce0d9e-2bc1-46aa-8e8b-914614b633f6
-- forked from 02 - Jupiter V.3 [ numeric ] @ https://flipsidecrypto.xyz/edit/queries/f0dbd696-f375-443a-9e31-b0472420e288
-- forked from 01 - Jupiter V.3 @ https://flipsidecrypto.xyz/edit/queries/2dd99fd8-0090-4fd4-b6b0-bed8ed375d52
--- JUP4Fb2cqiRUcaTHdrPC8h2gNsA2ETXiPDD33WcGuJB -- jupiter swap v4
--- JUP3c2Uh3WA4Ng34tw6kPd2G4C5BB21Xo36Je1s32Ph -- jupiter aggregator v3
--- JUP2jxvXaqu7NQY1GmNF4m1vodw12LVXYxbFL2uJvfo -- jupiter aggregator v2
--- JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4 -- jupiter v3
with
tkn_price AS
(
SELECT
date_trunc( 'day' , a.recorded_hour ) AS day
, avg( a.close ) AS price
, a.token_address AS tkn_id
, a.symbol AS token
FROM
solana.core.ez_token_prices_hourly a
GROUP BY 1 , 3 , 4
ORDER BY 1 DESC
)
,
jupiter AS
(
SELECT
a.block_timestamp AS time
, a.signers[0] AS uss
, a.tx_id AS txs
Run a query to Download Data