saadiqMythics Royalties by Platform
    Updated 2023-10-11
    -- forked from Moonbirds Royalties by Platform @ https://flipsidecrypto.xyz/edit/queries/753f55fa-e44e-4f0b-9c07-f37bffe4c9a6
    WITH txns AS (
    SELECT
    block_timestamp,
    platform_name,
    price,
    creator_fee,
    CASE
    WHEN price > 0 THEN ROUND(creator_fee / price * 100, 2)
    ELSE '0'
    END AS eff_royalty_rate,
    tx_hash
    FROM
    ethereum.nft.ez_nft_sales
    WHERE
    nft_address = LOWER('0xc0ffee8ff7e5497c2d6f7684859709225fcc5be8')
    AND tx_hash NOT IN (
    '0xe19b5cdc2c7d47ab5a8c711c5706a18afabf176907cd15fa2d88c43837882d23',
    '0xc68ed7081ff5417df4d59ba9ca97bff590de506d57ebbe1c343d05d1c8e8b27b',
    '0xdb6df0f9ab97a681a2a62c58f3f1011411d59017ecdd0157474c59d5756265a5',
    '0x9ab65d8c9a710a7f527287e7e82b4ab9f85c30d4f5d0c79ffc88117b488ec135',
    '0xb6b64790b6006124656911e0847a6e4ce1e788337986027c00a8db7f7b6f657a',
    '0x48e97a661f8139db1dd5cbcbf22b1fc9e448e03ad2f0c1dafdbb07caa0cd2377',
    '0xfcdd6c12d0e7ddbfffe2426fc45d7f8adb93f4cab50d74d7d57f03c548962fe3',
    '0x70c920480d533a260a4e0c83386292c8b730b256890d1be5d521dcd836f90793',
    '0x708801625dd366396f93add2808d4f09051ef8eb00d2b4b2f1fa48e8fcb65680',
    '0xfede37eb0c0dc73cdcd49b5ff1567e474c03e8b5430e1a69046e60a9eb05ab72',
    '0x3011d9990a6f1ed02e95119df1083e5e8e55c550e752ec8d1021e387851df108'
    )
    AND block_timestamp > DATEADD (DAY, -90, CURRENT_DATE) --AND block_timestamp < CURRENT_DATE
    AND block_timestamp < DATE_TRUNC ('week', CURRENT_DATE)
    )
    SELECT
    LEFT (DATE_TRUNC ('week', block_timestamp), 10) AS PERIOD
    -- LEFT (DATE_TRUNC ('day', block_timestamp), 10) AS PERIOD
    ,
    Run a query to Download Data