select *

from ethereum.core.ez_nft_sales

where block_timestamp::date >= '2022-06-01' and platform_name = 'looksrare'

select

date_trunc('day', block_timestamp) as date,

sum(creator_fee_usd) as royalty,

avg(creator_fee_usd) as avg_royalty,

median(creator_fee_usd) as median_royalty,

max(creator_fee_usd) as max_royalty,

min(creator_fee_usd) as min_royalty,

(select sum(creator_fee_usd) from looksrare) as total_royalty,

(select avg(creator_fee_usd) from looksrare) as total_avg_royalty,

avg(royalty) over (order by date rows between 7 preceding and 0 following) as ma_7_royalty,

sum(royalty) over (order by date) as cumulative_royalty

from looksrare

group by 1