cheeyoung-kekMean Finance Opening Positions
99
1
2
3
4
5
6
7
8
9
10
›
⌄
-- Q2. Compare users terminating vs increasing positions over the last 30 days. By how much are they increasing positions? How much are they receiving back after terminating?
with in_flow as (
SELECT sum(amount) as o_amount from ethereum.core.ez_token_transfers where TO_ADDRESS=lower('0x19b3eb3af5d93b77a5619b047de0eed7115a19e7')
),
out_flow as(
SELECT sum(amount) as a_amount from ethereum.core.ez_token_transfers where FROM_ADDRESS=lower('0x19b3eb3af5d93b77a5619b047de0eed7115a19e7')
)
select * from in_flow join out_flow
Run a query to Download Data