rellghentVANDOUGH_NFT_SALES
Updated 2022-11-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
SELECT DISTINCT
block_timestamp,
tx_id,
amount,
amount_usd,
SUM (amount) OVER (ORDER BY block_timestamp) as eth_spent_running_total,
SUM (amount_usd) OVER (ORDER BY block_timestamp) as usd_spent_running_total
FROM ethereum.udm_events
WHERE tx_id IN
(SELECT tx_id FROM ethereum.nft_events
WHERE event_from = '0x0f0eae91990140c560d4156db4f00c854dc8f09e')
AND amount IS NOT NULL
AND amount_usd IS NOT NULL
AND amount_usd > 1000 -- for some reason 'marketplace' was removed from the columns specified below, this is a quick workaround
--AND (to_address_name = 'marketplace' OR to_label_subtype = 'marketplace') -- just about all of their sales occur on open sea
ORDER BY block_timestamp DESC
-- SELECT * FROM ethereum.udm_events
-- WHERE tx_id = '0x085170818edb5a0ff812e1d60ba05b3a2d2b3e53a35703c2b50e5dc53fc982a2'