i_dansolid-bronze
Updated 2024-08-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
symbol_out
, symbol_in
, count(DISTINCT tx_hash) AS txs
, sum((amount_in_usd + amount_out_usd)/2) AS volume
FROM
base.defi.ez_dex_swaps
WHERE amount_in_usd IS NOT NULL
-- AND symbol_out NOT IN ('ETH', 'WETH', 'USDT', 'USDC', 'USDbC', 'USD+', 'DAI', 'cbETH')
-- AND symbol_in NOT IN ('ETH', 'WETH', 'USDT', 'USDC', 'USDbC', 'USD+', 'DAI', 'cbETH')
GROUP BY 1, 2
ORDER BY 4 DESC
LIMIT 1000
QueryRunArchived: QueryRun has been archived