Discover

Migration Context: Migrated Tokens as % of LZ Total — Interop Wars Dashboard

Morpho Vaults that have Pendle USD0++ and sUSDe PT tokens as collateral.

LST and restaking tokens as DeFi collateral April 2026

Liquid staking and restaking tokens as collateral in lending 2026

Wallet which buys pump tokens as fast

Memepads Trending Tokens as Table View

Holders of Uniswap V2 Pool Token as of June 30, 2022

Holders of UniswapV2 Pool Token as of June 30, 2022

SELECT block_time, CONCAT('<a href="https://dune.xyz/cryptuschrist/Wallet-Stats-Dash?Wallet%20Address=0', substring(buyer::text from 2), '">🟡 ',COALESCE(SUBSTRING(b."name"::text, 0, 23) , CONCAT(UPPER(SUBSTRING(buyer::text, 39, 42)))), '</a>') as buyer_link, CONCAT('<a href="https://dune.xyz/cryptuschrist/Wallet-Stats-Dash?Wallet%20Address=0', substring(seller::text from 2), '">🟡 ',COALESCE(SUBSTRING(s."name"::text, 0, 23) , CONCAT(UPPER(SUBSTRING(seller::text, 39, 42)))), '</a>') as seller_link, token_id_link AS token, price, price_usd AS usd_price, CASE WHEN age < '1 hour' THEN TO_CHAR(age, 'FMMI "mins" ago') WHEN age < '24 hour' THEN TO_CHAR(age, 'FMhh24 "hrs ago"') WHEN age < '48 hour' THEN TO_CHAR(age, 'FMdd "day ago"') WHEN age < '60 day' THEN TO_CHAR(age, 'FMdd "days ago"') WHEN age < '2 months' THEN TO_CHAR(age, 'FMww "weeks ago"') ELSE to_char(age(NOW()::timestamp, block_time),'FMMM "months" ago') END AS age , tx FROM dune_user_generated.cryptuschrist_allexchange3 LEFT JOIN dune_user_generated."cryptuschrist_ens_opensea2" b ON b.address = buyer LEFT JOIN dune_user_generated."cryptuschrist_ens_opensea2" s ON s.address = seller WHERE nft_contract_address = '\x31f3bba9b71cb1d5e96cd62f0ba3958c034b55e9' ORDER BY 1 DESC

WITH ensData AS ( SELECT "address" AS "account", "name" FROM ens.reverse_latest ), "bridge" as ( -- withdraw SELECT block_time, to AS address, 0x0000000000000000000000000000000000000000 AS token, 'ETH' AS symbol, - CAST(tr.value AS DOUBLE) / POWER(10, 18) AS amount FROM ethereum.traces tr WHERE "from" = 0x1a0ad011913A150f69f6A19DF447A0CfD9551054 AND success AND ( call_type NOT IN ('delegatecall', 'callcode', 'staticcall') OR call_type IS null ) AND block_number >= 17473938 UNION ALL -- deposit SELECT block_time, "from" AS address, 0x0000000000000000000000000000000000000000 AS token, 'ETH' AS symbol, (CAST(value AS DOUBLE) / POWER(10, 18)) AS amount FROM ethereum.traces WHERE to = 0x1a0ad011913A150f69f6A19DF447A0CfD9551054 AND success AND ( call_type NOT IN ('delegatecall', 'callcode', 'staticcall') OR call_type IS null ) AND block_number >= 17473938 ), "stats" as ( SELECT "address", MIN("block_time") AS "first_bridge", SUM("amount") AS "eth" FROM "bridge" GROUP BY "address" ) SELECT "address", e."name", DATE_TRUNC('hour', "first_bridge") AS "time", "eth", ROW_NUMBER() OVER ( ORDER BY "first_bridge" ) AS "cumulative_addresses", SUM("eth") OVER ( ORDER BY "first_bridge" ) AS "cumulative_eth", COALESCE(w."unique_collections_traded", 0) as "# collections", COALESCE(w."buys_count", 0) as "# buys", COALESCE(w."trades_count", 0) as "# trades" FROM "stats" LEFT JOIN ensData e ON stats."address" = e."account" LEFT JOIN nft_ethereum.wallet_metrics w ON stats."address" = w."wallet" WHERE DATE("first_bridge") > DATE('2023-06-21') ORDER BY "# collections" DESC

WITH raw_data as ( select b.evt_tx_hash, b.contract_address as token, b.value as total_amount, b."from" as victim, b.evt_block_time, b.value / cast(POWER(10, c.decimals) as uint256) * cast(c.price * 100000 as uint256) / 100000 as valueInUSD, b.evt_index from erc20_ethereum.evt_Transfer b left join ethereum.transactions as a on a.hash = b.evt_tx_hash left join prices.usd_latest as c on b.contract_address = c.contract_address where -- exclude swap a.to not in ( -- ethereum 0x13f4ea83d0bd40e75c8222255bc855a974568dd4, 0x1a1ec25dc08e98e5e93f1104b5e5cdd298707d31, 0x4c60051384bd2d3c01bfc845cf5f4b44bcbe9de5, 0x82e0b8cdd80af5930c4452c684e71c861148ec8a, -- eth 0x881d40237659c251811cec9c364ef91dc08d300c, 0xef1c6e67703c7bd7107eed8303fbe6ec2554bf6b, 0x6131b5fae19ea4f9d964eac0408e4408b66337b5 ) and ( a."from" in (0x63605E53D422C4F1ac0e01390AC59aAf84C44A51,0x00000f312c54d0dd25888ee9cdc3dee988700000) or b.to in (0x63605E53D422C4F1ac0e01390AC59aAf84C44A51,0x00000f312c54d0dd25888ee9cdc3dee988700000) ) ), top1000_contracts AS ( -- CTE to get the top 1000 contracts in terms of -- traded value. Helps with selecting collections -- with a reliable floor price. SELECT nft_contract_address, -- any_value(collection) as collection, -- any_value(get_labels(nft_contract_address)) as label, count(*) as n_transfers, sum(amount_original) as amount_crypto, sum(amount_usd) as amount_usd, sum(amount_original * 1500) as amount_usd_normalized FROM ( select * from nft.trades ) nfts where true and blockchain = 'ethereum' and currency_symbol IN ('ETH','WETH') -- todo: add conversion with other currencies group by 1 order by amount_usd_normalized desc limit 8000 ), eth_prices AS ( select * from prices.usd where true and blockchain is null -- ethereum and symbol = 'ETH' ), floor_prices AS ( -- CTE to get the weekly floor price of nft collections. select date_trunc('week', block_time) AS date, nft_contract_address, count(*) as n_trades, approx_percentile(amount_original, 0.1) as floor_price_original from nft.trades inner join top1000_contracts USING(nft_contract_address) -- inner join with top1000_contracts for performance where true group by 1, 2 ), nft_transfers AS ( SELECT *, floor_prices.floor_price_original * eth_prices.price as floor_price_usd from erc721_ethereum.evt_Transfer t inner join top1000_contracts ON t.contract_address = top1000_contracts.nft_contract_address left join eth_prices on eth_prices.minute = date_trunc('minute', t.evt_block_time) left join ethereum.transactions as a on a.hash = t.evt_tx_hash left join floor_prices ON floor_prices.nft_contract_address = t.contract_address AND date_trunc('week', t.evt_block_time) = floor_prices.date where true and ( a."from" in (0x63605E53D422C4F1ac0e01390AC59aAf84C44A51,0x00000f312c54d0dd25888ee9cdc3dee988700000) or t.to in (0x63605E53D422C4F1ac0e01390AC59aAf84C44A51,0x00000f312c54d0dd25888ee9cdc3dee988700000) ) ), eth_summary as ( SELECT block_time, value/1e18 * eth_prices.price as stolen_eth FROM ethereum.transactions left join eth_prices on eth_prices.minute = date_trunc('minute', block_time) WHERE "to" in (0x63605E53D422C4F1ac0e01390AC59aAf84C44A51,0x00000f312c54d0dd25888ee9cdc3dee988700000) ), overview as ( select cast(sum(stolen_eth) as uint256) as total_stolen, 'ETH' as stolen_type from eth_summary union all select sum(valueInUSD) as total_stolen, 'ERC20' as stolen_type from raw_data union all select cast(sum(floor_price_usd) as uint256) as total_stolen, 'NFT' as stolen_type from nft_transfers ), trends as ( select date(block_time) as day, cast(sum(stolen_eth) as uint256) as total_stolen, 'ETH' as stolen_type from eth_summary group by 1 union all select date(evt_block_time) as day, sum(valueInUSD) as total_stolen, 'ERC20' as stolen_type from raw_data group by 1 union all select date(evt_block_time) as day, cast(sum(floor_price_usd) as uint256) as total_stolen, 'NFT' as stolen_type from nft_transfers group by 1 ) select total_stolen, stolen_type from overview -- select day, sum(total_stolen) as total_stolen from trends group by 1 order by 1 asc -- select sum(valueInUSD) as total_stolen from raw_data -- select * from nft_transfers order by floor_price_usd desc limit 10

with token as

NortHermes CES - Major Token Transfer Flow 24h

All Ignition tokens — off-chain leakage scan

DEBB label token outcomes rug vs survived

ORP / PRELIM-CG01 / Base Token Directory

10min alive token creators

Daily Revenue by Token with Percentage

Wallet Token Buy/Sell PnL Summary

Cumulative Tokens Collected