MuzeJupiter Routes Pools
Updated 2023-05-13
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 Jupiter Routers Volume @ https://flipsidecrypto.xyz/edit/queries/7c32f153-501d-4598-9513-697fb4a31f4c
-- forked from Jupiter Routers Total @ https://flipsidecrypto.xyz/edit/queries/cb51c164-f959-418d-8c9e-e69b752c6619
-- forked from Jupiter Routers @ https://flipsidecrypto.xyz/edit/queries/ee760154-fa3d-4fa9-9ff5-a1088a7e1751
-- forked from Volume @ https://flipsidecrypto.xyz/edit/queries/bd0285ba-7d5a-44de-9bd7-0e8c2932aeb3
with prices as (
select
date_trunc('day', recorded_hour) as day,
avg( close ) as price,
token_address,
token_name
from solana.core.ez_token_prices_hourly
where token_name not in ( 'Cope Token', 'Solminter' ) -- skewing data
group by 1,3,4
),
base as (
select
date_trunc('{{Date_Trunc}}', a.block_timestamp) as date,
instruction :accounts[0] ::string as dex,
a.tx_id,
swap_from_mint,
swap_to_mint
-- concat(swap_from_mint, ' - ', swap_to_mint) as symbol
from solana.core.fact_events a
left join solana.core.fact_swaps b on a.tx_id = b.tx_id
and a.block_timestamp = b.block_timestamp
where a.program_id in (
-- 'JUP4Fb2cqiRUcaTHdrPC8h2gNsA2ETXiPDD33WcGuJB',
'JUP3c2Uh3WA4Ng34tw6kPd2G4C5BB21Xo36Je1s32Ph',
'JUP2jxvXaqu7NQY1GmNF4m1vodw12LVXYxbFL2uJvfo'
Run a query to Download Data