WEEK_START | TOTAL_INFLOW_AMOUNT_USD | TOTAL_OUTFLOW_AMOUNT_USD | TOTAL_NETFLOW_AMOUNT_USD | |
|---|---|---|---|---|
1 | 2025-03-03 00:00:00.000 | 94670255.3789154 | -55691054.1045853 | 38979201.2743301 |
2 | 2025-02-24 00:00:00.000 | 69483020.7692801 | -102513937.537449 | -33030916.7681693 |
3 | 2025-02-17 00:00:00.000 | 103374564.178394 | -101386711.719285 | 1987852.45910911 |
4 | 2025-02-10 00:00:00.000 | 161741011.508999 | -154754190.737477 | 6986820.77152272 |
5 | 2025-02-03 00:00:00.000 | 356049582.65757 | -111880684.442413 | 244168898.215157 |
6 | 2025-01-27 00:00:00.000 | 82163409.753135 | -50599815.7143007 | 31563594.0388343 |
7 | 2025-01-20 00:00:00.000 | 26584984.238892 | -27056290.8113431 | -471306.572451078 |
8 | 2025-01-13 00:00:00.000 | 310714487.931199 | -361092241.899747 | -50377753.9685475 |
9 | 2025-01-06 00:00:00.000 | 892365553.796643 | -1455079025.70339 | -562713471.90675 |
10 | 2024-12-30 00:00:00.000 | 776938762.177038 | -596912319.799401 | 180026442.377638 |
11 | 2024-12-23 00:00:00.000 | 52591082.410732 | -82031915.9910053 | -29440833.5802733 |
12 | 2024-12-16 00:00:00.000 | 20979679.2148841 | -10925440.2828957 | 10054238.9319884 |
datavortexweekly 1212
Updated 2025-03-09
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 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,
week_start
FROM
$query('1092b210-fc6c-4734-ad2a-b75afe08d90a')
)
SELECT
ut.week_start,
SUM((ut.INFLOW_AMOUNT / POWER(10, tp.decimals)) * tp.avg_price_usd) AS total_inflow_amount_usd,
SUM((ut.OUTFLOW_AMOUNT / POWER(10, tp.decimals)) * tp.avg_price_usd) AS total_outflow_amount_usd,
SUM((ut.NETFLOW_AMOUNT / POWER(10, tp.decimals)) * tp.avg_price_usd) AS total_netflow_amount_usd
FROM
UserTransfers ut
JOIN
token_price_and_decimal tp
ON
ut.TOKEN_ADDRESS = tp.token_address
GROUP BY
ut.week_start
ORDER BY
ut.week_start DESC;
Last run: about 2 months agoAuto-refreshes every 12 hours
12
961B
3s