mohamadreza221166Buyers Of Degods on Last Month
Updated 2022-07-18
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
›
⌄
SELECT
BLOCK_TIMESTAMP,
TX_ID,
purchaser,
sales_amount
FROM solana.fact_nft_sales b
JOIN solana.dim_nft_metadata a ON a.mint = b.mint
WHERE lower(contract_name) LIKE '%degods%'
AND BLOCK_TIMESTAMP::DATE >= DATEADD(MONTH, -1, CURRENT_DATE)
AND sales_amount > 0
SELECT
BLOCK_TIMESTAMP,
TX_ID,
l.LABEL,
sales_amount
FROM solana.fact_nft_sales b
JOIN solana.dim_nft_metadata a ON a.mint = b.mint
JOIN solana.core.dim_labels l on l.ADDRESS = b.PROGRAM_ID
WHERE lower(contract_name) LIKE '%degods%'
AND BLOCK_TIMESTAMP::DATE >= DATEADD(MONTH, -1, CURRENT_DATE)
AND sales_amount > 0
Run a query to Download Data