AMOUNT_USD | RANK | YOU_ARE_IN | TOTAL_USERS | |
|---|---|---|---|---|
1 | 461518.53 | 10995 | 0.0589 | 18672601 |
hrst79rank
Updated 2 days ago
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
pump_tokens as (
select
DISTINCT decoded_instruction:args:symbol::varchar as symbol,
Decoded_instruction:accounts [0] :pubkey :: string as address
from
solana.core.fact_decoded_instructions
where
program_id ='6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P'
and event_type = 'create'
and block_timestamp >= '2024-01-14'
),
traders as (
SELECT
DISTINCT signers[0] as swapper,
FROM
solana.core.fact_decoded_instructions
WHERE
program_id = '6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P'
and block_timestamp >= '2024-01-14'
)
,
pre_final as (
SELECT
DISTINCT swapper,
'buy' as action,
swap_to_mint as token_Address,
swap_from_amount_usd as amount
from
solana.defi.ez_dex_swaps a join pump_tokens b on a.swap_to_mint = b.address
where
a.program_id = '6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P'
and swap_from_symbol = 'SOL'
and swap_to_symbol is NULL
and swapper in (select swapper from traders)
Last run: about 11 hours ago
1
35B
101s