SELECT block_timestamp::date as date, platform_name,
sum(creator_fee_usd) as total_royalties_usd
FROM ethereum.core.ez_nft_sales
WHERE block_timestamp::date >= '2022-01-01'
and platform_name in ('opensea', 'looksrare', 'x2y2')
GROUP BY date, platform_name