kaibladeValue of Stolen NFTs - BAYC Discord Hack (April 1)
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 = '0xad7f0a2427f93bc8fc178a73ae0d2d188682884f'
AND block_timestamp::date = '2022-04-01')
,
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