Nests · public
LP token holders on Ethereum
pharos-eth · ethereum
Every Transfer of two liquidity-pool tokens, LUSD3CRV and the Uniswap V2 USDC/USDT pair, about 109,000 rows since launch, so holders and supply can be replayed in SQL. Block times are not stored. SQL at /sql and MCP over HTTP at /mcp.
The copy we host
statusanswering on 2026-11-22
at block26,470,043
sealed through block26,469,979
from block10,000,000
nuthatch5.23.0
contract0xed279fdd11ca84beef15af5d39bb4d4bee23f0ca
nid371acb52fd498b3deca22e4ad8a95460839d1675b9058c1e747d1c3676a0226e
Read when this page was built, on 2026-11-22. If your browser can reach the nest, the status and block above are replaced with what it says now.
Query it
The stock binary behind a read-only proxy: queries only, no key, no admin. Stood up for pharos-watch.
https://nuthatch-indexer.com/nests/pharos-eth curl -sG 'https://nuthatch-indexer.com/nests/pharos-eth/sql' --data-urlencode 'q=SELECT count(*) FROM lusd3crv__transfer' Tables
One per contract event, as the nest listed them on 2026-11-22. Its schema describes the views as well.
| table | event |
|---|---|
| lusd3crv__transfer | Transfer(address,address,uint256) |
| univ2_usdc_usdt__transfer | Transfer(address,address,uint256) |
Limits of the hosted copy
- No uptime promise. It is one process on one box, and a nest you run yourself answers to nobody else’s outage.
- Read-only. Anything that would write, or spend the operator’s RPC, is refused at the proxy.