PapasotCopy of Fifa secondary sales sample
    Updated 2022-10-27
    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