top 5 protocol - Last 6 month copy

Snehatop 5 protocol - Last 6 month copy

Updated 2024-02-08

-- forked from intensodefi / top 5 protocol - Last 6 month @ https://flipsidecrypto.xyz/intensodefi/q/aj9rHkrijAgy/top-5-protocol---last-6-month

select protocol, sum(revenue) as total_revenue,

sum(fees) as total_fee

from external.defillama.fact_protocol_fees_revenue

where chain like 'solana'

and date_trunc('month',date) >date_trunc('month',CURRENT_TIMESTAMP) - interval '6 months'

and protocol !='Solana'

group by 1

order by 2 desc

limit 5

Last run: over 1 year ago

146B