drone-mostafabuy USDT DAILY
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
›
⌄
WITH TOPS AS (
SELECT
CONCAT (TOKEN_IN,'=>',TOKEN_OUT) AS PATH,
count (DISTINCT TX_HASH) as txn,
count (DISTINCT TRADER) as users,
sum (AMOUNT_IN) as Volume
FROM near.core.ez_dex_swaps
WHERE TOKEN_IN ilike '%usdt%'
AND TOKEN_OUT NOT IN (SELECT TOKEN_OUT FROM near.core.ez_dex_swaps WHERE TOKEN_OUT ilike '%usdt%')
AND BLOCK_TIMESTAMP >= CURRENT_DATE -30
GROUP BY 1
ORDER BY VOLUME DESC
LIMIT 5)
SELECT
DATE_TRUNC ('DAY',BLOCK_TIMESTAMP) AS DATE,
CONCAT (TOKEN_IN,'=>',TOKEN_OUT) AS PATH,
count (DISTINCT TX_HASH) as txn,
count (DISTINCT TRADER) as users,
sum (AMOUNT_IN) as Volume,
SUM (txn) OVER (PARTITION BY PATH ORDER BY DATE) AS CUM_TXN,
SUM (users) OVER (PARTITION BY PATH ORDER BY DATE) AS CUM_users,
SUM (Volume) OVER (PARTITION BY PATH ORDER BY DATE) AS CUM_Volume
FROM near.core.ez_dex_swaps
WHERE TOKEN_IN ilike '%usdt%'
AND PATH IN (SELECT PATH FROM TOPS)
AND BLOCK_TIMESTAMP >= CURRENT_DATE -30
GROUP BY 1,2
Run a query to Download Data