flyingfishWhat tokens are Jupiter Users setting orders on copy
Updated 2023-12-12
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
›
⌄
-- forked from What tokens are Jupiter Users setting orders on @ https://flipsidecrypto.xyz/edit/queries/f34aaa9c-4b11-43ae-bc74-d687947e8578
-- forked from Jupiter Limit Sell Orders Overall Stats @ https://flipsidecrypto.xyz/edit/queries/57fc5f37-6044-4bd0-80f4-fd8523c9778a
with all_events AS (
SELECT
-- block_timestamp::date AS date
decoded_instruction:accounts[5]:pubkey AS token_to_sell
, token_name
, symbol
, count(DISTINCT tx_id) AS total_initialize_orders
FROM solana.core.ez_events_decoded
LEFT JOIN solana.core.dim_tokens ON token_to_sell = token_address
WHERE 1 = 1
AND block_timestamp > current_date - 31
AND block_timestamp < current_date
AND program_id = 'jupoNjAxXgZ4rjzxzPMP4oxduvQsQtZzyknqvzYNrNu'
AND decoded_instruction:name = 'initializeOrder'
GROUP BY all
)
SELECT * FROM all_events
ORDER BY total_initialize_orders DESC
LIMIT 10
Run a query to Download Data