drone-mostafa2023-05-06 03:24 AM
Updated 2023-05-06
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
32
33
34
35
36
›
⌄
with usds as (
SELECT
TOKEN_IN,
sum ((AMOUNT_IN/pow(10,DECIMALS)) * PRICE_USD) as USD
FROM near.core.ez_dex_swaps
LEFT JOIN (SELECT date_trunc ('day',TIMESTAMP) as datea,SYMBOL,avg (PRICE_USD) as PRICE_USD FROM near.core.fact_prices GROUP BY 1,2) b
on (datea::date = date_trunc ('day',BLOCK_TIMESTAMP)
and SYMBOL = TOKEN_IN)
JOIN near.core.dim_token_labels on TOKEN_CONTRACT = TOKEN_IN_CONTRACT
LEFT JOIN near.core.fact_transactions using (TX_HASH)
WHERE TX_STATUS = 'Success'
GROUP BY 1)
SELECT
-- date_trunc ('day',BLOCK_TIMESTAMP) as date,
--PLATFORM,
--TOKEN_IN,
--TOKEN_OUT,
count (DISTINCT TX_HASH) as TXN,
count (DISTINCT TRADER) as Users,
--sum (AMOUNT_IN * PRICE_USD) as USD
sum (USD) as USD
FROM near.core.ez_dex_swaps
Run a query to Download Data