DIRECTION | COUNT(WALLET_ADDRESS) | |
|---|---|---|
1 | Decrease | 132 |
2 | Increase | 193828 |
3 | Hold | 370115 |
4 | Sell All | 14 |
5 | Partial Hold | 4856 |
BlazeJUP direction
Updated 2024-02-11
999
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 PYTH direction @ https://flipsidecrypto.xyz/edit/queries/fb4e112e-e5aa-4aab-92b7-91f78a3debc1
WITH airdrops AS (
SELECT DISTINCT
block_timestamp,
tx_id
FROM solana.core.fact_events
WHERE succeeded
AND program_id = 'meRjbQXFNf5En86FXT2YPz1dQzLj4Yb3xK8u1MVgqpb'
),
claimers AS (
SELECT
tx_to as wallet_address,
sum(amount) AS total_pyth
FROM solana.core.fact_transfers
JOIN airdrops USING (block_timestamp, tx_id)
WHERE lower(mint) = lower('JUPyiwrYJFskUPiHa7hkeR8VUtAeFoSYbKedZNsDvCN')
GROUP BY 1
),
new_wallets as(
select signer as wallet_address
from solana.core.ez_signers
where
lower(first_program_id)= lower('meRjbQXFNf5En86FXT2YPz1dQzLj4Yb3xK8u1MVgqpb')
and first_tx_date>'2024-01-30'
),
swaps as(
select
c.wallet_address,
sum(case
when lower(swap_from_mint)=lower('JUPyiwrYJFskUPiHa7hkeR8VUtAeFoSYbKedZNsDvCN') then swap_from_amount
else 0
end) as send,
sum(case
when lower(swap_to_mint)=lower('JUPyiwrYJFskUPiHa7hkeR8VUtAeFoSYbKedZNsDvCN') then swap_to_amount
else 0
Last run: about 1 year ago
5
92B
328s