datavortexinflow/outflow
Updated 2024-12-16
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 weekly_token_inflows AS (
SELECT
DATE_TRUNC('week', block_timestamp) AS "week",
symbol,
contract_address,
SUM(amount_usd) AS amount_usd
FROM
arbitrum.vertex.ez_clearing_house_events
WHERE
event_name = 'ModifyCollateral'
AND block_timestamp >= TIMESTAMP '2023-04-26'
AND symbol NOT IN ('HARRISWIN', 'TRUMPWIN')
GROUP BY
DATE_TRUNC('week', block_timestamp),
symbol,
contract_address
ORDER BY
"week" DESC,
contract_address
)
SELECT
"week",
symbol,
contract_address,
amount_usd,
SUM(amount_usd) OVER (
PARTITION BY symbol
ORDER BY
"week"
) AS cum_amount_usd_by_token,
SUM(amount_usd) OVER (
ORDER BY
"week"
) AS tvl
FROM
weekly_token_inflows
QueryRunArchived: QueryRun has been archived