DevJacobicurrent-holding
Updated 2022-07-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
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