adambalatp22
Updated 2022-10-02
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 traits as (
--query "Nouns Mints + Meta" by erics https://app.flipsidecrypto.com/velocity/queries/1ee22900-7e0a-464a-b9a4-707dab0dbc63
select TOKEN_ID as tokenid ,contract_address,
TOKEN_METADATA: background as Backgrounds ,
(TOKEN_METADATA:body) body ,--IS NOT NULL THEN TOKEN_METADATA:Clothes ELSE '0' END as Clothess,
TOKEN_METADATA:face face,-- IS NOT NULL THEN TOKEN_METADATA:Earring ELSE '0' END AS Earrings,
TOKEN_METADATA:hair as hair,
TOKEN_METADATA:head as head,
TOKEN_METADATA:piercing as piercing
from ethereum.core.dim_nft_metadata where lower(CONTRACT_ADDRESS) =lower('0x8a90CAb2b38dba80c64b7734e58Ee1dB38B8992e')
order by tokenid desc
),
mint_1 as (
SELECT
tx_hash,
tokenid
FROM ethereum.core.ez_nft_mints
WHERE lower(nft_address) =lower('0x8a90CAb2b38dba80c64b7734e58Ee1dB38B8992e')
),
mint_2 as (
select
tx_hash,
amount as mint_price_eth
from ethereum.core.ez_eth_transfers
where lower(eth_from_address) =lower('0x8a90CAb2b38dba80c64b7734e58Ee1dB38B8992e')
),
mint_price as (
select
mint_1.tx_hash,
mint_1.tokenid,
mint_2.mint_price_eth
from mint_1
Run a query to Download Data