adambalaUntitled Query
Updated 2022-09-09
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
30
31
32
33
34
35
36
›
⌄
with eth as
(select
PRICE as volume ,
PRICE_USD AS USD,
NFT_ADDRESS ,
SELLER_ADDRESS as sellers ,
BUYER_ADDRESS as buyers ,
TX_HASH as sale_tx ,
BLOCK_TIMESTAMP ::date as date ,
PLATFORM_NAME as platform,
TOKENID
from
ethereum.core.ez_nft_sales where CURRENCY_ADDRESS='ETH' and EVENT_TYPE='sale' and
NFT_ADDRESS=('0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d')
)
, eth_metadata as (
select eth.*,
TOKEN_METADATA:Background as Backgrounds ,
TOKEN_METADATA:Clothes as Clothess,
TOKEN_METADATA:Earring as Earrings,
TOKEN_METADATA:Eyes as Eyess,
TOKEN_METADATA:Fur as Furs,
TOKEN_METADATA:Hat as Hats,
TOKEN_METADATA:Mouth as Mouths
from ethereum.core.dim_nft_metadata right join eth on NFT_address = CONTRACT_ADDRESS
)
select
platform ,
Backgrounds,
Clothess,
Earrings,
Eyess,
Furs,
Hats,
Run a query to Download Data