mhmdntewithdraws
Updated 2022-10-14
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
pool_name,
COUNT(tx_hash) AS cnt_tx,
SUM(
CASE WHEN token0_amount_usd IS NOT NULL THEN token0_amount_usd
ELSE token1_amount_usd
END
) AS amount_usd
FROM optimism.velodrome.ez_lp_actions
WHERE block_timestamp >= CURRENT_DATE - 6
AND lp_action = 'withdraw'
GROUP BY pool_name
Run a query to Download Data