jackguyCEL token flows
Updated 2022-09-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
WITH tab1 as (
SELECT
DISTINCT address
FROM flipside_prod_db.crosschain.address_labels
WHERE address_name LIKE 'celsius wallet'
)
SELECT
date_trunc('week', block_timestamp),
CASE when symbol_in LIKE 'CEL' then 'CEL in' ELSE 'CEL out' END as token_flow,
platform,
sum(amount_out_usd) as volume,
count(*) as swaps
from ethereum.core.ez_dex_swaps
WHERE NOT origin_from_address IN (SELECT * FROM tab1)
AND (symbol_in LIKE 'CEL' or symbol_out LIKE 'CEL')
GROUP by 1,2,3
Run a query to Download Data