TOTAL_TRANSFERS | TOTAL_TRANSFER_VOLUME | TOTAL_TRANSFER_VOLUME_USD | AVG_DAILY_TRANSFER_VOLUME_USD | |
|---|---|---|---|---|
1 | 91800 | 45341942311.228 | 15159079.06 | 718058.51 |
feyikemiTransfer totals
Updated 2025-03-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
WITH daily_transfers AS (
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS transfer_day,
SUM(AMOUNT_USD) AS daily_volume_usd
FROM ronin.core.ez_token_transfers
WHERE CONTRACT_ADDRESS = '0xf988f63bf26c3ed3fbf39922149e3e7b1e5c27cb'
GROUP BY transfer_day
)
SELECT
COUNT(DISTINCT TX_HASH) AS total_transfers,
SUM(AMOUNT) AS total_transfer_volume,
SUM(AMOUNT_USD) AS total_transfer_volume_usd,
ROUND(AVG(d.daily_volume_usd), 2) AS avg_daily_transfer_volume_usd
FROM ronin.core.ez_token_transfers t
LEFT JOIN daily_transfers d
ON DATE_TRUNC('day', t.BLOCK_TIMESTAMP) = d.transfer_day
WHERE t.CONTRACT_ADDRESS = '0xf988f63bf26c3ed3fbf39922149e3e7b1e5c27cb'
Last run: 2 months ago
1
47B
3s