adam1044 uni v3 lp top
Updated 2021-08-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
token0_symbol,
token1_symbol,
CONCAT(token0_symbol,'-',token1_symbol) as concat_pair,
SUM(ABS(amount1_usd)) as swapped_amount_usd,
date_trunc('week',block_timestamp) as week,
COUNT(DISTINCT tx_id) as transaction_count
FROM uniswapv3.swaps
WHERE
amount1_usd<>0
AND block_timestamp >= getdate() - interval '30 days'
GROUP BY 1,2,5
ORDER BY 4 DESC
LIMIT 30
Run a query to Download Data