nitsUntitled Query
    Updated 2022-04-06
    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