kaibladeValue of Stolen NFTs - BAYC Instagram Hack (April 25)
    Updated 2023-04-13
    WITH nft_transfer AS
    (SELECT *
    FROM ethereum.core.ez_nft_transfers
    WHERE nft_to_address = '0x8c7934611b6ad70fbea13a1593de167a4689b9a9'
    AND block_timestamp::date = '2022-04-25')
    ,
    all_sales AS
    (SELECT sales.*
    FROM ethereum.core.ez_nft_sales sales
    JOIN nft_transfer transfer
    ON sales.nft_address = transfer.nft_address
    AND sales.event_type = 'sale'

    ORDER BY block_timestamp DESC)
    ,
    latest_nft_price AS (
    SELECT *,
    ROW_NUMBER() OVER (PARTITION BY nft_address ORDER BY block_timestamp DESC) AS row_number
    FROM all_sales
    )
    ,
    nft_prices AS
    (SELECT nft_address,project_name, price, price_usd
    FROM latest_nft_price
    WHERE row_number = 1)
    ,
    joined_prices AS
    (
    SELECT prices.nft_address, transfer.tokenid, prices.project_name, prices.price, prices.price_usd
    FROM nft_prices prices
    JOIN nft_transfer transfer
    ON prices.nft_address =transfer.nft_address
    )

    SELECT SUM(price) AS total_price_eth, SUM(price_usd) AS total_price_usd
    FROM joined_prices
    Run a query to Download Data