AVERAGE_SENT_AMOUNT | TOTAL_TRANSFERS | TOTAL_SENDERS | TOTAL_VOLUME_SENT | AVERAGE_DAILY_VOLUME | |
---|---|---|---|---|---|
1 | 6.310365706311 | 22747620 | 1403254 | 192428973.36775 | 248937.8698159767 |
crypto_gostgreat-plum
Updated 2024-11-29
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
AVG(amount / 1e8) AS average_sent_amount,
COUNT(DISTINCT tx_hash) AS total_transfers,
COUNT(DISTINCT account_address) AS total_senders,
SUM(amount / 1e8) AS total_volume_sent,
SUM(amount / 1e8) / COUNT(DISTINCT DATE_TRUNC('day', block_timestamp)) AS average_daily_volume,
FROM
aptos.core.fact_transfers
WHERE
token_address = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC';
Last run: 3 months ago
1
69B
17s