TOTAL_TRANSFERS | TOTAL_VOLUME_USD | AVG_DAILY_VOLUME_USD | |
|---|---|---|---|
1 | 55882 | 15328155.98 | 464489.58 |
feyikemiTransfer totals main
Updated 2025-03-26
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 current_price AS (
SELECT
DATE_TRUNC('day', hour) AS price_day,
AVG(price) AS price
FROM ronin.price.ez_prices_hourly
WHERE token_address = LOWER('0xf988f63bf26c3ed3fbf39922149e3e7b1e5c27cb')
GROUP BY price_day
),
daily_volume AS (
SELECT
DATE_TRUNC('day', t.block_timestamp) AS day,
COUNT(DISTINCT t.tx_hash) AS daily_transfers,
SUM(t.amount) AS daily_amount
FROM ronin.core.ez_token_transfers t
WHERE t.contract_address = LOWER('0xf988f63bf26c3ed3fbf39922149e3e7b1e5c27cb')
GROUP BY DATE_TRUNC('day', t.block_timestamp)
)
SELECT
SUM(d.daily_transfers) AS total_transfers,
ROUND(SUM(d.daily_amount * p.price), 2) AS total_volume_usd,
ROUND(AVG(d.daily_amount * p.price), 2) AS avg_daily_volume_usd
FROM daily_volume d
JOIN current_price p ON d.day = p.price_day;
Last run: 2 months ago
1
31B
2s