NuveveCryptoArchivedTotal Value Deposited
Updated 2023-07-06
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 ethereum AS (
SELECT
month,
SUM(deposits_usd) OVER (ORDER BY month ASC) AS cumulative_deposits_usd
FROM
(SELECT
DATE_TRUNC('month', eth.block_timestamp) AS month,
SUM(eth.amount_usd + token.amount_usd) AS deposits_usd
FROM
ethereum.core.ez_eth_transfers AS eth
INNER JOIN ethereum.core.ez_token_transfers AS token ON eth.block_number = token.block_number
WHERE
eth.eth_to_address = '0xd152f549545093347a162dce210e7293f1452150'
AND token.to_address = '0xd152f549545093347a162dce210e7293f1452150'
GROUP BY
DATE_TRUNC('month', eth.block_timestamp)
) AS subquery
ORDER BY
month ASC
),
polygon AS (
SELECT
month,
SUM(deposits_usd) OVER (ORDER BY month ASC) AS cumulative_deposits_usd
FROM
(SELECT
DATE_TRUNC('month', matic.block_timestamp) AS month,
SUM(matic.amount_usd + token.amount_usd) AS deposits_usd
FROM
polygon.core.ez_matic_transfers AS matic
INNER JOIN polygon.core.ez_token_transfers AS token ON matic.block_number = token.block_number
WHERE
matic.matic_to_address = '0xd152f549545093347a162dce210e7293f1452150'
AND token.to_address = '0xd152f549545093347a162dce210e7293f1452150'
GROUP BY
DATE_TRUNC('month', matic.block_timestamp)
Run a query to Download Data