Discover

Polymarket open interest by market

WITH staked AS ( SELECT DATE_TRUNC('day', evt_block_time) AS period, SUM(TRY_CAST(value AS DOUBLE)) / 1e6 AS staked_amount FROM erc20_arbitrum.evt_Transfer WHERE contract_address IN ( 0xaf88d065e77c8cc2239327c5edb3a432268e5831 -- USDC -- 0xFd086bC7CD5C481DCC9C85ebE478A1C0b69FCbb9, -- USDT -- 0xFF970A61A04b1cA14834A43f5dE4533eBDDB5CC8 -- USDC.e ) AND "to" = 0x2df1c51e09aecf9cacb7bc98cb1742757f163df7 GROUP BY 1 ), redeemed AS ( SELECT DATE_TRUNC('day', evt_block_time) AS period, -- contract_address, SUM(TRY_CAST(value AS DOUBLE)) / 1e6 AS redeemed_amount FROM erc20_arbitrum.evt_Transfer WHERE contract_address IN ( 0xaf88d065e77c8cc2239327c5edb3a432268e5831 -- USDC -- 0xFd086bC7CD5C481DCC9C85ebE478A1C0b69FCbb9, -- USDT -- 0xFF970A61A04b1cA14834A43f5dE4533eBDDB5CC8 -- USDC.e ) AND "from" = 0x2df1c51e09aecf9cacb7bc98cb1742757f163df7 GROUP BY 1 ), combined AS ( SELECT s.period, (s.staked_amount - COALESCE(r.redeemed_amount, TRY_CAST(0 AS DOUBLE))) AS amount FROM staked s LEFT JOIN redeemed r ON s.period = r.period ) SELECT period, amount, SUM(amount) OVER (ORDER BY period) / 1e9 AS cumulative_amount_b, SUM(amount) OVER (ORDER BY period) AS cumulative_amount, usdc_arb.total_amount as usdc_on_arb, usdc_arb.total_amount - SUM(amount) OVER (ORDER BY period) as usdc_non_hype, SUM(amount) OVER (ORDER BY period) / usdc_arb.total_amount * 100 as percentage FROM combined left join query_4430461 usdc_arb using(period) order by 1 desc

Accumulative Traders Of Tokens On Clanker & Pump Fun

vvaifu all actions scratch

Net amount of USDC deposited on Hyperliquid

Hyperliquid Hourly Net & Cumulative Inflow

AVA Top Holder

btc eth price

Polymarket positions TRUMPWIN by bucket size

Arbitrum's TVL used for Hyperliquid

Top 100 Holders USD00+

$Anon Daily Volume per chain(30d)

Solana Shitcoin Smart Wallet Tracker

MegaETH NFT - The Fluffle

cookie_daily

Lombard LBTCv Vault TVL

Hyperliquid Hourly Net & Cumulative Inflow

Open Interest per outcome in Presidential election market

DEX by volume 🏦

DEX by volume 🏦