saadiqDown Bad Proof Distribution
    Updated 2023-02-22
    WITH
    all_txns AS (
    SELECT
    *,
    row_number() over (
    PARTITION BY
    nft_address,
    tokenid
    ORDER BY
    block_timestamp DESC,
    price DESC
    ) AS row_number
    FROM
    (
    SELECT
    project_name,
    nft_address,
    block_timestamp,
    event_type,
    tokenid,
    mint_price_eth AS price,
    mint_price_usd AS price_usd,
    tx_hash,
    nft_from_address AS from_address,
    nft_to_address AS to_address
    FROM
    ethereum.core.ez_nft_mints
    WHERE
    nft_address = lower('0x08d7c0242953446436f34b4c78fe9da38c73668d')
    UNION
    SELECT
    project_name,
    nft_address,
    block_timestamp,
    event_type,
    tokenid,
    Run a query to Download Data