nitsAverage Purchase Price
Updated 2022-06-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with nfd as
(SELECT *
from algorand.asset where
right(asset_url,10) = '}/nfd.json'),
txs as
( SELECT tx_group_id from
(SELECT * from algorand.transactions
WHERE asset_id in (Select asset_id from nfd) )
)
SELECT avg(amt) as avg_purchase_price,
median(amt) as med_purchase_price
from
(SELECT *, tx_message:txn:amt/pow(10,6) as amt
from algorand.transactions
where tx_group_id in
(SELECT * from txs )
and tx_type= 'pay' and tx_message:txn:amt is not NULL
and TX_MESSAgE:txn:rcv != 'EBE87MxYL4wTnQVFyJFQOames+plchQ1QZ5lARDMD+4='
)
limit 100
Run a query to Download Data