nitsUntitled Query
Updated 2022-04-06
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with swapping as
(SELECT date(block_timestamp) as day, sum(swap_to_amount) as asset_amt, count(DISTINCT swapper) as unique_users , 'swap' as action
from algorand.swaps
where swap_to_asset_id = '386192725' or swap_to_asset_id = '386195940'
GROUP by 1 )
SELECT * from algorand.asset_transfer_transaction
where asset_id = '38619275'
-- where asset_sender ilike 'ETGSQKACKC56JWGMDAEP5S2JVQWRKTQUVKCZTMPNUGZLDVCWPY63LSI3H4'
limit 100
-- limit 100
Run a query to Download Data