PapasotCopy of Fifa secondary sales sample
Updated 2022-10-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
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
limit 10
Run a query to Download Data