rajsNouns Auction Settlement
Updated 2022-06-12
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
›
⌄
SELECT
-- settler,
count(*)
from
(
SELECT
tx_json:receipt:logs[4]:decoded:inputs:nounId::integer as token_id,
tx_json:receipt:logs[4]:decoded:inputs:amount / pow(10,18) as mint_price,
tx_json:receipt:logs[4]:decoded:inputs:winner as minter,
from_address as settler,
*
from flipside_prod_db.ethereum_core.fact_transactions
where tx_json:receipt:logs[4]:address = '0x830bd73e4184cef73443c15111a1df14e495c706'
and tx_json:receipt:logs[4]:decoded:eventName = 'AuctionSettled'
order by 1 desc
)
where minter <> settler
and settler not IN
(
select
tx_json:receipt:logs[0]:decoded:inputs:sender as bidder
from flipside_prod_db.ethereum_core.fact_transactions
-- where tx_hash = '0xdb2d4b89e7e79c0891cbcb56439d30e779d71983ea1ea467fcdc93bc8191cba0'
-- where tx_json:receipt:logs[0]:decoded:contractName = 'NounsAuctionHouseProxy'
where tx_json:receipt:logs[0]:address = '0x830bd73e4184cef73443c15111a1df14e495c706'
and tx_json:receipt:logs[0]:decoded:eventName = 'AuctionBid'
)
-- group by 1
-- order by 2 desc
Run a query to Download Data