# Pool Discovery and Data Collection

## Discover ETH/WETH pools

```bash
cd /var/www/vps2.happyuser.info/top/top_1
source /var/www/vps2.happyuser.info/top/backtest_SK/.venv38/bin/activate
mkdir -p DEX_DATA/l2_pool_discovery

python3 dex_platform/data_collectors/discover_geckoterminal_l2_pools_v1.py \
  --symbols ETH,WETH,USDC,USDT \
  --networks base,eth,arbitrum,optimism \
  --out-csv DEX_DATA/l2_pool_discovery/eth_weth_usdc_usdt_candidates_$(date +%Y_%m_%d).csv \
  --out-json DEX_DATA/l2_pool_discovery/eth_weth_usdc_usdt_candidates_$(date +%Y_%m_%d).json \
  --min-tvl-usd 100000 \
  --min-volume-h24-usd 50000 \
  --sleep-s 8
```

Sort:

```bash
python3 scripts/sort_pool_candidates_v1.py \
  --csv DEX_DATA/l2_pool_discovery/eth_weth_usdc_usdt_candidates_$(date +%Y_%m_%d).csv \
  --out DEX_DATA/l2_pool_discovery/eth_weth_usdc_usdt_candidates_sorted_$(date +%Y_%m_%d).csv
```

## Candidate filters

Prefer:

```text
Base/Aerodrome Slipstream
WETH/USDC or WETH/USDT
TVL 100k-50M
volume/TVL > 0.2 useful, >1 strong
V3/CL-like pools only
```

Avoid initially:

```text
Uniswap V4
Pancake Infinity
V2 pools
BSC active pools without paid RPC/indexer
```

## Collect one month on Base

```bash
export BASE_RPC_URL="https://mainnet.base.org"
export DEX_POOL="PASTE_POOL_ADDRESS"
export DEX_POOL_NAME="base_WETH_USDC_candidate"
export TIME_FROM="2026-04-01T00:00:00Z"
export TIME_TO="2026-05-01T00:00:00Z"

bash scripts/collect_base_cl_pool_month_v1.sh
```

## Collect quarter if candidate passes one month

```bash
export TIME_FROM="2026-02-01T00:00:00Z"
export TIME_TO="2026-05-01T00:00:00Z"
export OUT_DIR="DEX_DATA/base_candidates/${DEX_POOL_NAME}_2026_02_05_v3"

bash scripts/collect_base_cl_pool_month_v1.sh
```
