PapasotRand Gallery Algorand volume
Updated 2023-01-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with nft_txns as (
select distinct tx_group_id
from algorand.payment_transaction
where
receiver = 'RANDGVRRYGVKI3WSDG6OGTZQ7MHDLIN5RYKJBABL46K5RQVHUFV3NY5DUE'
)
select date,
sum(amount) as sale_volume,
sum(sale_volume) over (order by date asc rows between unbounded preceding and current row) as cum_sale_volume
from (
select
block_timestamp::date as date,
rank() over (partition by t1.tx_group_id order by intra asc ) as rank,
tx_message:txn:amt/1e6 as amount,
t1.*
from algorand.transactions t1 join nft_txns t2 on t1.tx_group_id = t2.tx_group_id
where amount > 0
-- tx_group_id in (select distinct tx_group_id from nft_txns)
qualify rank = 1
) group by date
Run a query to Download Data