drone-mostafaincr token out
Updated 2023-05-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
›
⌄
WITH
PRICES AS (
SELECT RECORDED_HOUR::DATE AS TIME,ID,TOKEN,AVG (CLOSE) AS PRICE
FROM flow.core.fact_hourly_prices
GROUP BY 1,2,3)
SELECT
P2.TOKEN AS Pair,
count (DISTINCT TX_ID) as Txn,
count (DISTINCT TRADER) as Users,
sum (TOKEN_IN_AMOUNT) as USD,
avg (TOKEN_IN_AMOUNT) as AVG_USD,
USD / Users as USD_Per_User,
Txn / Users as Txn_Per_User
FROM flow.core.ez_swaps t1
JOIN flow.core.fact_transactions using (TX_ID)
JOIN PRICES p1 ON TOKEN_IN_CONTRACT = P1.ID AND BLOCK_TIMESTAMP::DATE = P1.TIME::DATE
JOIN PRICES p2 ON TOKEN_OUT_CONTRACT = P2.ID AND BLOCK_TIMESTAMP::DATE = P2.TIME::DATE
WHERE (PAYER = '0x55ad22f01ef568a1' or PROPOSER = '0x55ad22f01ef568a1')
GROUP BY 1
Run a query to Download Data