kaibladeValue of Stolen NFTs - BAYC Instagram Hack (April 25)
Updated 2023-04-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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