DevJacobicurrent-holding
    Updated 2022-07-21
    with usdt as (select count(distinct(address)) as address_usdt
    from algorand.account_asset
    where asset_closed = 'FALSE'
    and amount > 0
    and asset_id = '312769'),

    usdc as (select count(distinct(address)) as address_usdc
    from algorand.account_asset
    where asset_closed = 'FALSE'
    and amount > 0
    and asset_id = '31566704 ')

    select address_usdt,
    address_usdc, cast( getdate() as date ) as date_retrieved
    from usdt, usdc
    Run a query to Download Data