DevJacobidaily-transactions
Updated 2022-07-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with usdt as (select date_trunc('day',block_timestamp) as datum,
count(*) as usdt_transactions
from algorand.asset_transfer_transaction
where asset_id = '312769'
group by datum),
usdc as (select date_trunc('day',block_timestamp) as datum,
count(*) as usdc_transactions
from algorand.asset_transfer_transaction
where asset_id = '31566704'
group by datum)
select a.datum,
usdt_transactions,
usdc_transactions
from usdt a
join usdc b
on a.datum = b.datum
Run a query to Download Data