PapasotRand Gallery Algorand volume
    Updated 2023-01-03
    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