saadiqMonthly Royalties Estimate
    Updated 2023-10-05
    SELECT
    CASE
    WHEN nft_address = '0x23581767a106ae21c074b2276d25e5c3e136a68b' THEN 'moonbirds'
    WHEN nft_address = '0x13303b4ee819fac204be5ef77523cfcd558c082f' THEN 'mythics eggs'
    WHEN nft_address = '0xc0ffee8ff7e5497c2d6f7684859709225fcc5be8' THEN 'mythics'
    ELSE 'dunno'
    END AS name,
    left(date_trunc('month', block_timestamp), 10) AS MONTH,
    --SUM(price) AS total_vol_eth,
    --SUM(creator_fee) AS total_royalties_eth,
    0.35 AS ls_perc,
    --total_royalties_eth *.35 AS ls_royalties_eth,
    --total_royalties_usd *.35 AS ls_royalties_usd,
    0.4 AS est_tax_rate,
    SUM(creator_fee) * ls_perc * (1 - est_tax_rate) AS after_taxes_eth
    FROM
    ethereum.core.ez_nft_sales
    WHERE
    nft_address IN (
    '0x23581767a106ae21c074b2276d25e5c3e136a68b',
    '0x13303b4ee819fac204be5ef77523cfcd558c082f',
    '0xc0ffee8ff7e5497c2d6f7684859709225fcc5be8'
    )
    /* MBs, Mythics Eggs, Mythics */
    AND block_timestamp >= '2023-03-01'
    AND MONTH < date_trunc('month', CURRENT_DATE)
    GROUP BY
    name,
    date_trunc('month', block_timestamp)
    ORDER BY
    MONTH DESC,
    name;
    Run a query to Download Data