nitsSandbox Holding Time stats
Updated 2022-11-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with buyer as
(SELECT buyer_address,tokenid as id , block_timestamp as purchase_time
from
ethereum.core.ez_nft_sales
where (nft_address ilike '0x5cc5b05a8a13e3fbdb0bb9fccd98d38e50f90c38' )),
seller as
(SELECT seller_address,tokenid , block_timestamp as sale_time
from
ethereum.core.ez_nft_sales
where (nft_address ilike '0x5cc5b05a8a13e3fbdb0bb9fccd98d38e50f90c38' ))
SELECT * from
( SELECT date(purchase_time) as day , avg(time_diff_days) as avg_holder_time from
(SELECT *, timestampdiff(sql_tsi_minute,purchase_time,sale_time )/(60*24) as time_diff_days from buyer
inner join seller
on seller_address = buyer_address and tokenid = id and purchase_time < sale_time)
GROUP by 1 )
where day >= CURRENT_DATE - {{n}}
-- LIMIT 10
Run a query to Download Data