saadiqTreasury Moonbirds
    Updated 2023-06-08
    WITH
    all_txns AS (
    SELECT
    *,
    row_number() over (
    PARTITION BY
    nft_address,
    tokenid
    ORDER BY
    block_timestamp DESC
    ) AS row_number
    FROM
    (
    SELECT
    project_name,
    nft_address,
    block_timestamp,
    tokenid,
    token_metadata,
    tx_hash,
    nft_from_address AS from_address,
    nft_to_address AS to_address
    FROM
    ethereum.core.ez_nft_transfers
    WHERE
    nft_address in ('0x23581767a106ae21c074b2276d25e5c3e136a68b')
    and nft_to_address = lower('0x4863799d31d4c4A0F08857E7167BC3FCeFCe747f')
    )
    )
    SELECT
    tokenid,
    token_metadata:background::TEXT AS background,
    token_metadata:beak::TEXT AS beak,
    token_metadata:body::TEXT AS body,
    token_metadata:eyes::TEXT AS eyes,
    token_metadata:eyewear::TEXT AS eyewear,
    Run a query to Download Data