MLDZMNTop traders on Phoenix
Updated 2023-09-05
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 price_tab as (SELECT
recorded_hour::date as day,
token_address,
avg(close) as token_price
FROM solana.price.ez_token_prices_hourly
where day>='2023-08-23'
group by 1,2
),
total as (select *,
CASE
when ARRAY_CONTAINS('4DoNfFBfF7UokCC2FQzriy7yHK6DY6NVdYpuekQ5pRgg'::VARIANT, instruction:accounts) then 'SOL/USDC'
when ARRAY_CONTAINS('FZRgpfpvicJ3p23DfmZuvUgcQZBHJsWScTf2N2jK8dy6'::VARIANT, instruction:accounts) then 'mSOL/SOL'
when ARRAY_CONTAINS('Ew3vFDdtdGrknJAVVfraxCA37uNJtimXYPY4QjnfhFHH'::VARIANT, instruction:accounts) then 'wETH/USDC'
when ARRAY_CONTAINS('2t9TBYyUyovhHQq434uAiBxW6DmJCg7w4xdDoSK6LRjP'::VARIANT, instruction:accounts) then 'jitoSOL/SOL'
when ARRAY_CONTAINS('GBMoNx84HsFdVK63t8BZuDgyZhSBaeKWB4pHHpoeRM9z'::VARIANT, instruction:accounts) then 'BONK/USDC'
when ARRAY_CONTAINS('FicF181nDsEcasznMTPp9aLa5Rbpdtd11GtSEa1UUWzx'::VARIANT, instruction:accounts) then 'BONK/SOL'
end as markets
from solana.core.fact_events
where succeeded = True
and (program_id = 'PhoeNiXZ8ByJGLkxNfZRnkUfjvmuYqLR89jjFHGqdXY'
or ARRAY_CONTAINS('PhoeNiXZ8ByJGLkxNfZRnkUfjvmuYqLR89jjFHGqdXY'::VARIANT, instruction:accounts)) -- not all swaps done on Phoenix
and BLOCK_TIMESTAMP>='2023-08-23'
and signers[0] not in ('phxBcughCYKiYJxx9kYEkyqoAUL2RD3vyxSaL1gZRNG','Ba964S79RCU36fyVybAeeDLnrR1gwYQKo8qCpFiKJJAd',
'JEEToN4w2cDyMJeFp7MA9kz2CLauChbsmo51kUDUxx9A','wowK1ivqmU9WhHnghiJQ4UUySndzvrUAJinjMUw54eX','GCRzo5mX7eZj4f4tNHLXB74HrDfzJhZpxTQ3dbbsKNsu',
'LUKAzPV8dDbVykTVT14pCGKzFfNcgZgRbAXB8AGdKx3','D3VukrhsSXNM8f2wqx595cJaQtS22enTm9EgfumJT7Gv') -- signers for cancelling orders
),
t_tab as (select
*
from solana.core.fact_transfers
where tx_id in (select tx_id from total)
and (tx_to in ('irWZsBWNZ8jbGncWgn7i4mu7bzXKKyW4QPsphtbosGQ','8g4Z9d6PqGkgH31tMW6FwxGhwYJrXpxZHQrkikpLJKrG','5vkFwKVxAmZWgQ2b4xYJBdBzjkFvPxSCTdLeEs48BsGf',
'J6vHZDKghn3dbTG7pcBLzHMnXFoqUEiHVaFfZxojMjXs','9Zdp9hUEfJ6wD4UbVrTKTbMhXtTzLqsvmAQrNzMCdNAF','51LAUnnqk8PTPribSTRb5rmF867dz5mEQbpxfk13Nu1C')
Run a query to Download Data