RON Token Analysis copy

m3jiRON Token Analysis copy

Updated 1 day ago

-- forked from RON Token Analysis @ https://flipsidecrypto.xyz/studio/queries/c543c965-8123-4fd5-ba0a-ad150c91cd7f

-- RON Token Analysis - Overall Totals for 90-day period

WITH token_transfers AS (

SELECT

COUNT(*) AS total_transfers,

COUNT(DISTINCT from_address) AS sending_wallets,

COUNT(DISTINCT to_address) AS receiving_wallets,

SUM(amount) AS total_tokens_transferred,

SUM(amount_usd) AS total_usd_transferred

FROM ronin.core.ez_native_transfers

WHERE from_address != LOWER('0x0000000000000000000000000000000000000000') -- Filter out minting transactions

AND block_timestamp >= CURRENT_DATE - 90

daily_holder_changes AS (

SELECT

to_address AS wallet,

SUM(amount) AS total_inflow,

SUM(amount_usd) AS total_inflow_usd,

0 AS total_outflow,

0 AS total_outflow_usd

FROM ronin.core.ez_native_transfers

WHERE from_address != LOWER('0x0000000000000000000000000000000000000000') -- Filter out minting transactions

AND block_timestamp >= CURRENT_DATE - 90

GROUP BY wallet

UNION ALL

SELECT

from_address AS wallet,

0 AS total_inflow,

0 AS total_inflow_usd,

SUM(amount) AS total_outflow,

SUM(amount_usd) AS total_outflow_usd

FROM ronin.core.ez_native_transfers

WHERE from_address != LOWER('0x0000000000000000000000000000000000000000') -- Filter out minting transactions

AND block_timestamp >= CURRENT_DATE - 90

Last run: 1 day ago

	TOTAL_TRANSFERS	SENDING_WALLETS	RECEIVING_WALLETS	TOTAL_TOKENS_TRANSFERRED	TOTAL_USD_TRANSFERRED	ACTIVE_WALLETS	ACCUMULATING_WALLETS	REDUCING_WALLETS	NET_ACCUMULATION_WALLETS	PCT_ACCUMULATING	TOTAL_ACCUMULATION_USD	TOTAL_REDUCTION_USD	NET_ACCUMULATION_USD	AVG_TRANSFER_SIZE_USD
1	23494763	646105	1713743	1672376843.80875	1015675388.62757	1776133	1658269	111457	1546812	93.36401	713267597.682913	307532990.764009	405734606.918904	43.229863124

165B