Discover

Day 7: Liquidity Added and Removed & LPs Over Time (USDC/WETH v3 Uniswap)

Blobscription

ARB top signatures for the date

Kaia DeFi tx

Farcaster Checkin Usage

checkin counter

Token bought amount per day

Stables vs Yield-bearing Stables MoM holder addy count

Day 8: Finding Liquidity Provider diversity (concentration) in Uniswap v3 pool

Day 4: Identify MEV bot volume in Uniswap V3 Trades

Daily SUM of tx_count and gas_used(ETH)

Top Contracts by gas fee

Top Initiator by gas fee

OP Proposal Keywords

Bonus Q) Day 3: (Volume added)How to find top routing paths that use a USDC/WETH in Uniswap v3

Web3 SQL Weekly #4: Getting New and Old Users (Wallets) for a Protocol

Web3 SQL Weekly #3: Finding all NFTs (ERC721) held by an address

Day 2: Volume and Frequency of Swaps (USDC/WETH v3 Uniswap)

Day 3: How to find top routing paths that use a USDC/WETH in Uniswap v3

Day 1: How to find all pairs for ERC20 tokens in Uniswap v3