princefarzamNumber of transactions for USDT vs. USDC
Updated 2022-02-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
WITH USDT_TX AS (
SELECT
date_trunc('day',block_timestamp) AS day,
COUNT(DISTINCT tx_id) AS USDT_TRANSACTIONS
FROM algorand.asset_transfer_transaction
WHERE asset_id = 312769
AND day::date >= '2021-09-01' --since september
GROUP BY day
ORDER BY day ASC
),
USDC_TX AS (
SELECT
date_trunc('day',block_timestamp) AS day,
COUNT(DISTINCT tx_id) AS USDC_TRANSACTIONS
FROM algorand.asset_transfer_transaction
WHERE asset_id = 31566704
AND day::date >= '2021-09-01' --since september
GROUP BY day
ORDER BY day ASC
)
SELECT
USDT.day AS DAY,
USDT.USDT_TRANSACTIONS AS NUMBER_OF_USDT_TRANSACTIONS,
USDC.USDC_TRANSACTIONS AS NUMBER_OF_USDC_TRANSACTIONS
FROM USDT_TX USDT FULL OUTER JOIN USDC_TX USDC ON USDT.day= USDC.day
Run a query to Download Data