nitsDaily swaps on Tinyman
Updated 2022-02-11
9
1
2
3
4
›
⌄
SELECT date(block_timestamp) as day, sum(asset_amount)/pow(10,6) as total_amount, max(asset_amount)/pow(10,6) as max_amount, avg(asset_amount)/pow(10,6) as avg_amt, count(*) as total_txs, sum(total_amount) over (order by day) as cumulative_vol, sum(total_txs) over(order by day) as cumulative_txs from algorand.asset_transfer_transaction
where asset_id = '470842789' and (sender = 'XLNMBK3GMC4YEF562DMEOZEYTNDWJLQRN2GFQ3MGLVNIJTOTVGVD75DVKM' or asset_receiver = 'XLNMBK3GMC4YEF562DMEOZEYTNDWJLQRN2GFQ3MGLVNIJTOTVGVD75DVKM')
GROUP by 1
LIMIT 1000
Run a query to Download Data