datavortexnetflow of tokens
Updated 2025-01-12
999
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 token_price_and_decimal AS (
SELECT
token_address,
symbol,
decimals,
avg_price_usd
FROM
$query('eb8c7a0a-f771-4e55-9140-8aeb5f2e7c45')
),
UserTransfers AS (
SELECT
ACCOUNT_ADDRESS,
INFLOW_AMOUNT,
OUTFLOW_AMOUNT,
NETFLOW_AMOUNT,
TOKEN_ADDRESS
FROM
$query('bcb0a7d3-612f-4e13-9cdc-835fb48b153a')
)
SELECT
tp.symbol,
CASE
WHEN ABS(SUM((ut.INFLOW_AMOUNT / POWER(10, tp.decimals)) * tp.avg_price_usd)) >= 1000000000 THEN
CONCAT('$',
CASE
WHEN SUM((ut.INFLOW_AMOUNT / POWER(10, tp.decimals)) * tp.avg_price_usd) < 0 THEN '-'
ELSE ''
END,
ROUND(ABS(SUM((ut.INFLOW_AMOUNT / POWER(10, tp.decimals)) * tp.avg_price_usd) / 1000000000), 2), 'B')
WHEN ABS(SUM((ut.INFLOW_AMOUNT / POWER(10, tp.decimals)) * tp.avg_price_usd)) >= 1000000 THEN
CONCAT('$',
CASE
WHEN SUM((ut.INFLOW_AMOUNT / POWER(10, tp.decimals)) * tp.avg_price_usd) < 0 THEN '-'
ELSE ''
END,
ROUND(ABS(SUM((ut.INFLOW_AMOUNT / POWER(10, tp.decimals)) * tp.avg_price_usd) / 1000000), 2), 'M')
QueryRunArchived: QueryRun has been archived