zpencerETH-nft-helper
Updated 2022-10-18Copy Reference Fork
999
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
›
⌄
⌄
-- select platform_name as marketplaces,
-- platform_exchange_version,
-- count(distinct tx_hash) as transactions,
-- count(distinct nft_address) as collections,
-- count(distinct tokenid) as nfts,
-- count(distinct buyer_address) as buyers,
-- count(distinct seller_address) as sellers,
-- sum(price_usd) as volume,
-- avg(price_usd) as price
-- from
-- ethereum.core.ez_nft_sales
-- where
-- block_timestamp::date between '2022-09-01' and '2022-09-30'
-- and origin_function_signature = '0x9a2b8115'
-- group by 1, 2
select *
from ethereum.core.ez_nft_sales
where tx_hash = '0xfa7f95f9197c00589612f15b8da7f26402bdeef358838c50ecda9bed9baa978a'
;with txns as (
select BLOCK_NUMBER, BLOCK_TIMESTAMP, PROJECT_NAME,
TX_HASH, TOKENID, PRICE, CURRENCY_SYMBOL, PRICE_USD,
ORIGIN_TO_ADDRESS, platform_name, platform_exchange_version, ORIGIN_FUNCTION_SIGNATURE,
ROW_NUMBER() OVER(PARTITION BY tx_hash ORDER BY tokenid) as rownum
from ethereum.core.ez_nft_sales
where block_timestamp::date between '2022-09-17' and '2022-09-18'
and origin_function_signature = '0x9a2b8115'
and price_usd > 0
and project_name != 'dreadfulz'
and platform_name = 'sudoswap'
)
select *
from txns
where rownum > 1
Run a query to Download Data