adambala123.
Updated 2022-11-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
›
⌄
⌄
/*Art Gobblers is a pre-reveal NFT project that generates "goo" when you feed it (upload) art you've created. Some say the project is revitalizing NFTs in the bear market - Compare various metrics across NFT activity to support or oppose that idea. Then evaluate how the project's metrics stack up to other top NFT collections before their art reveals.
Art Gobblers is a pre-reveal NFT project that generates "goo" when you feed it (upload) art you've created. Some say the project is revitalizing NFTs in the bear market - Compare various metrics across NFT activity to support or oppose that idea. Then evaluate how the project's metrics stack up to other top NFT collections before their art reveals.*/
with xc as (
select NFT_TO_ADDRESS ,TOKENID ,(MINT_PRICE_ETH)/NFT_COUNT as MINT_PRICE_ETH ,(MINT_PRICE_USD)/NFT_COUNT as MINT_PRICE_USD ,tx_hash ,BLOCK_TIMESTAMP::DATE AS MINT_TIME
from ethereum.core.ez_nft_mints
where NFT_ADDRESS='0x60bb1e2aa1c9acafb4d34f71585d7e959f387769'
and NFT_FROM_ADDRESS='0x0000000000000000000000000000000000000000'
),
xce as (
select MIN(BLOCK_TIMESTAMP) AS DATE
,seller_address, tx_hash, tokenid, price_usd,price
FROM ethereum.core.ez_nft_sales
WHERE EVENT_TYPE = 'sale'
and CURRENCY_SYMBOL = 'ETH'
and lower(NFT_ADDRESS)=lower('0x60bb1e2aa1c9acafb4d34f71585d7e959f387769')
and price_usd > 0 and price > 0 GROUP BY 2,3,4,5,6 ORDER BY DATE )
select avg("hold time ") as "average hold time for traders in day"
from (select
NFT_TO_ADDRESS ,
xcedf.tokenid ,
datediff('day',MINT_TIME,date) as "hold time "
from xc xcedf join xce xcedfg on NFT_TO_ADDRESS = seller_address and xcedf.tokenid = xcedfg.tokenid
WHERE MINT_TIME < DATE
order by 3 asc
)
Run a query to Download Data