MLDZMNTop traders on Phoenix
    Updated 2023-09-05
    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