PapasotFifa secondary sales
Updated 2023-01-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
SELECT
date_trunc('day', block_timestamp) as date,
count (distinct (tx_group_id)) as secondary_sales,
sum (asset_amount/1000000) as usd_volume,
sum(usd_volume) over(ORDER by date ) as cum_total_USD_secondary
FROM
algorand.asset_transfer_transaction
WHERE
asset_receiver = 'ZG54ZBZ5LVWV3MTGOPDSKCBL5LEQTAPUTN5OQQZUMTAYV3JIICA7G3RJZE'
and
block_timestamp >= '2022-10-06'
and asset_id = 31566704
and asset_amount <> 4990000
and tx_group_id is not null
and sender <> '77IPD6CDSXKROQ62NRRVRGXE357ISY4GITQODBSB6EPW4MJY55XQXLUOMQ'
and asset_amount < 100000*1000000
group by date
order by date
Run a query to Download Data