rahulmaxLast Sold Price
Updated 2024-11-11
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 Mints AS (
SELECT
tokenid AS Day,
SUM(ERC1155_VALUE) AS Mints
FROM
base.nft.ez_nft_transfers
WHERE
nft_address = '0xba5e05cb26b78eda3a2f8e3b3814726305dcac83'
AND event_type = 'mint'
GROUP BY
tokenid
),
LastSoldPrices AS (
SELECT
tokenid,
price AS last_sold_price,
ROW_NUMBER() OVER (
PARTITION BY tokenid
ORDER BY
block_timestamp DESC
) AS rn
FROM
base.nft.ez_nft_sales
WHERE
nft_address = '0xba5e05cb26b78eda3a2f8e3b3814726305dcac83'
AND price > 0.002
),
StartDate AS (
SELECT DATE '2023-08-10' AS StartDay -- Starting date for Day 1
)
SELECT
m.Day,
DATEADD(day, m.Day - 1, StartDay) AS formatted_date, -- Calculate the date based on the start date and token ID
m.Mints, -- Keep Mints as is
COALESCE(lsp.last_sold_price * 200000, 0) AS normalized_last_sale -- Normalize last sale by multiplying by 10000
FROM
Auto-refreshes every 12 hours
QueryRunArchived: QueryRun has been archived