jackguyCelsius Swaps 2
Updated 2022-06-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
WITH tab1 as (
SELECT
DISTINCT address
FROM flipside_prod_db.crosschain.address_labels
WHERE address_name LIKE 'celsius wallet'
)
SELECT
origin_from_address,
count(*) as swaps,
SUM(amount_out_usd) as volume
from ethereum.core.ez_dex_swaps
WHERE origin_from_address IN (SELECT * FROM tab1)
GROUP by 1
Run a query to Download Data