nitsAverage Age Stats
Updated 2022-04-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with mints as
(SELECT from_address as fa , max(block_timestamp) as last_mint from thorchain.swaps
where contains(to_asset , '/')
GROUP by 1 ),
burns as
(SELECT from_address , max(block_timestamp) as last_burn from thorchain.swaps
where contains(from_asset , '/')
GROUP by 1 )
SELECT avg(time_diff)/(60*60*24) as avg_time_in_days, median(time_diff/(60*60*24)) as median_time_in_days
from
(SELECT *, case when last_burn is NULL then abs(TIMESTAMPDIFF(SQL_TSI_SECOND, last_mint,CURRENT_TIMESTAMP)) else abs(TIMESTAMPDIFF(SQL_TSI_SECOND, last_mint,last_burn)) end as time_diff
from
(SELECT * from mints
left join burns on fa= from_address ))
-- where last_burn is NULL
-- LIMIT 100
-- GROUP by 1
Run a query to Download Data