KaskoazulMonke DAO - sales after voting - sale price
Updated 2022-04-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH PURCHASERS AS (
select block_timestamp as fecha,
purchaser,
sales_amount,
concat_ws('#', 'SMB', token_id),
marketplace,
tx_id
from solana.dim_nft_metadata md
left join solana.fact_nft_sales sale
on md.mint = sale.mint
where contract_address = ('9uBX3ASjxWvNBAD1xjbVaKA74mWGZys3RGSF7DdeDD3F') --contract_name = ('Solana Monkey Business')
--and program_id in ('J7RagMKwSD5zJSbRQZU56ypHUtux8LRDkUpAPSKH4WPp', 'M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K', 'MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8')
and succeeded = 'TRUE'
and fecha >= '2022-02-15'
and sales_amount < 1000
)
select *
from PURCHASERS
Run a query to Download Data