count (tx_id) as Number_of_NFT,

sum (amount) as MNDE_locked_per_whale,

count (1) over (order by MNDE_locked_per_whale) as unique_purchasers,

sum (Number_of_NFT) over (order by MNDE_locked_per_whale) as total_NFT_minted,

avg (amount) as avg_MNDE_locked,

sum (MNDE_locked_per_whale) over (order by MNDE_locked_per_whale) as total_locked_MNDE

from solana.fact_transfers

where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey'

and index = 1

and block_timestamp >= '2022-04-04' and block_timestamp <= '2022-04-18'

and amount >= 250000

group by whales

order by MNDE_locked_per_whale desc