saadiqMythics Eggs Transactions Aggregated
    Updated 2023-04-21
    SELECT
    date_trunc('day', block_timestamp) AS DAY,
    platform_name,
    platform_exchange_version,
    CASE
    WHEN creator_fee = 0 THEN '0 - none'
    WHEN creator_fee / price >.0499999 THEN '2 - full'
    ELSE '1 - partial'
    END AS royalties_paid,
    COUNT(1) AS sales,
    SUM(price) AS total_price,
    SUM(creator_fee) AS total_creator_fee,
    CASE
    WHEN SUM(price) > 0 THEN CONCAT(
    ROUND(SUM(creator_fee) / SUM(price) * 100, 2),
    '%'
    )
    ELSE '0'
    END AS eff_royalty_rate_percentage,
    SUM(price) *.05 AS expected_creator_fee
    FROM
    ethereum.core.ez_nft_sales
    WHERE
    nft_address = lower('0x13303b4EE819FAc204be5eF77523cfCd558c082f')
    GROUP BY
    platform_name,
    platform_exchange_version,
    royalties_paid,
    date_trunc('day', block_timestamp)
    ORDER BY
    date_trunc('day', block_timestamp) DESC,
    platform_name DESC,
    platform_exchange_version DESC,
    royalties_paid DESC;
    Run a query to Download Data