case

when amount >= 1000 and amount < 5000 then 'L1'

when amount >= 5000 and amount < 25000 then 'L2'

when amount >= 25000 and amount < 100000 then 'L3'

when amount >= 100000 and amount < 250000 then 'L4'

when amount >= 250000 then 'L5'

end as CHEF_NFT,

count (tx_id) as Number_of_NFT,

sum(Number_of_NFT) over (order by fecha) as Total_minted_per_day,

count (distinct tx_from) as unique_purchasers,

sum (unique_purchasers) over (order by fecha) as total_purchasers,

sum (unique_purchasers) over (partition by CHEF_NFT order by fecha) as total_purchasers_L,

avg (amount) as avg_MNDE_locked,

sum (amount) as MNDE_locked_per_day,

sum (MNDE_locked_per_day) over (order by fecha) as total_locked_MNDE

from solana.fact_transfers

where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey'

and index = 1

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

and amount >= 1000

group by fecha, CHEF_NFT

order by fecha desc, CHEF_NFT desc