saadiqOwnership Duration in Days (Loyalty?)
    Updated 2023-06-20
    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 IN (
    '0x23581767a106ae21c074b2276d25e5c3e136a68b',
    '0x8a90cab2b38dba80c64b7734e58ee1db38b8992e',
    '0xed5af388653567af2f388e6224dc7c4b3241c544',
    '0x49cf6f5d44e70224e2e23fdcdd2c053f30ada28b',
    '0x1792a96e5668ad7c167ab804a100ce42395ce54d',
    '0x08d7c0242953446436f34b4c78fe9da38c73668d'
    )
    Run a query to Download Data