Ali3NAverage Holding Time (in Day) Before Selling Aopanda Party vs CryptoNinja Partners
Updated 2022-11-05
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 purchaset as (
select buyer_address,
case when nft_address = '0x845a007d9f283614f403a24e3eb3455f720559ca' then 'CryptoNinja Partners'
when nft_address = '0xc7e4d1dfb2ffda31f27c6047479dfa7998a07d47' then 'Aopanda Party' end as Project_name,
nft_address,
tokenid,
min (block_timestamp::date) as purchase_date
from ethereum.core.ez_nft_sales t1
where nft_address in ('0x845a007d9f283614f403a24e3eb3455f720559ca','0xc7e4d1dfb2ffda31f27c6047479dfa7998a07d47')
and price_usd > 0
group by 1,2,3,4),
salet as (
select seller_address,
case when nft_address = '0x845a007d9f283614f403a24e3eb3455f720559ca' then 'CryptoNinja Partners'
when nft_address = '0xc7e4d1dfb2ffda31f27c6047479dfa7998a07d47' then 'Aopanda Party' end as Project_name,
t1.nft_address,
t1.tokenid,
min (block_timestamp::date) as sale_date
from ethereum.core.ez_nft_sales t1
where nft_address in ('0x845a007d9f283614f403a24e3eb3455f720559ca','0xc7e4d1dfb2ffda31f27c6047479dfa7998a07d47')
and price_usd > 0
and seller_address in (select buyer_address from purchaset)
and tokenid in (select tokenid from purchaset)
and nft_address in (select nft_address from purchaset)
group by 1,2,3,4),
maintable as (
select datediff (day,purchase_date, sale_date) as Holding_Time,
buyer_address,
seller_address,
t1.project_name,
t1.nft_address,
t1.tokenid
from salet t1 join purchaset t2 on t1.seller_address = t2.buyer_address and t1.nft_address = t2.nft_address and t1.tokenid = t2.tokenid
where Holding_Time >= 0)
Run a query to Download Data