STABLECOIN | Transfers | Senders | VOLUME_SENT | AVG_PER_DAY | |
---|---|---|---|---|---|
1 | USDC | 22747620 | 1403254 | 19242897334.617752 | 24893786.978806924 |
2 | USDT | 587212 | 98002 | 122098182.938211 | 157953.66486185123 |
3 | ceUSDC | 335041 | 27502 | 74409676.550094 | 96510.60512333852 |
crypto_gostarrogant-rose
Updated 2024-11-29
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
27
28
29
30
31
32
33
34
35
36
›
⌄
⌄
SELECT
'USDC' AS stablecoin,
COUNT(DISTINCT tx_hash) AS "Transfers",
COUNT(DISTINCT ACCOUNT_ADDRESS) AS "Senders",
SUM(AMOUNT / 1e6) AS volume_sent,
SUM(AMOUNT / 1e6) / COUNT(DISTINCT date_trunc('day', BLOCK_TIMESTAMP)) AS avg_per_day,
FROM
aptos.core.fact_transfers
WHERE
TOKEN_ADDRESS = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC'-----usdc (layer zero)
UNION ALL
SELECT
'USDT' AS stablecoin,
COUNT(DISTINCT tx_hash) AS "Transfers",
COUNT(DISTINCT ACCOUNT_ADDRESS) AS "Senders",
SUM(AMOUNT / 1e6) AS volume_sent,
SUM(AMOUNT / 1e6) / COUNT(DISTINCT date_trunc('day', BLOCK_TIMESTAMP)) AS avg_per_day,
FROM
aptos.core.fact_transfers
WHERE
TOKEN_ADDRESS = '0xa2eda21a58856fda86451436513b867c97eecb4ba099da5775520e0f7492e852::coin::T';----Tether USD (Wormhole)
UNION all
SELECT
'ceUSDC' AS stablecoin,
COUNT(DISTINCT tx_hash) AS "Transfers",
COUNT(DISTINCT ACCOUNT_ADDRESS) AS "Senders",
SUM(AMOUNT / 1e6) AS volume_sent,
SUM(AMOUNT / 1e6) / COUNT(DISTINCT date_trunc('day', BLOCK_TIMESTAMP)) AS avg_per_day,
FROM
aptos.core.fact_transfers
WHERE
TOKEN_ADDRESS = '0x8d87a65ba30e09357fa2edea2c80dbac296e5dec2b18287113500b902942929d::celer_coin_manager::UsdcCoin';
Last run: 3 months ago
3
181B
24s