TOKEN_SYMBOL | CIRCULATING_SUPPLY | TOTAL_UNIQUE_SENDERS | TOTAL_UNIQUE_RECEIVERS | TOTAL_TRANSFER_VOLUME | AVG_AMOUNT_PER_TX | AVG_DAILY_VOLUME | TOTAL_TRANSFER_COUNT | AVG_DAILY_TRANSFERS | |
|---|---|---|---|---|---|---|---|---|---|
1 | USDT | 992842.394352 | 1820 | 2296 | 95218012.254642 | 616.692976436 | 639047.062111691 | 154401 | 1036.248322 |
depinGetting Started
Updated 2025-04-10
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
›
⌄
with transfers AS (select
block_timestamp,
TX_HASH,
DECODED_LOG:from AS from_address,
DECODED_LOG:to AS to_address,
DECODED_LOG:value/1e18 AS amount
from swell.core.ez_decoded_event_logs where EVENT_NAME='Transfer'
and contract_address=lower('0x5d3a1Ff2b6BAb83b63cd9AD0787074081a52ef34')),
daily_metrics AS (
SELECT
DATE_TRUNC('day', block_timestamp) as date,
COUNT(DISTINCT from_address) as daily_senders,
COUNT(DISTINCT to_address) as daily_receivers,
SUM(amount) as daily_volume,
AVG(amount) as avg_amount_per_tx,
COUNT(*) as daily_transfers
FROM transfers
GROUP BY 1
),
current_supply AS (
SELECT
SUM(CASE
WHEN from_address = '0x0000000000000000000000000000000000000000' THEN amount
WHEN to_address = '0x0000000000000000000000000000000000000000' THEN -amount
ELSE 0
END) as circulating_supply
FROM transfers
),
overall_metrics AS (
SELECT
COUNT(DISTINCT from_address) as total_unique_senders,
COUNT(DISTINCT to_address) as total_unique_receivers,
SUM(amount) as total_transfer_volume,
AVG(amount) as avg_transfer_amount,
Last run: 23 days ago
1
100B
2s