AnalyticSagesIntro-Top-ethereum-projects
Updated 2023-12-15
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 eth_vol_in AS (
SELECT
label,
sum(amount_usd) as eth_in
FROM
ethereum.core.ez_eth_transfers
JOIN ethereum.core.dim_labels ON eth_from_address=address
WHERE ethereum.core.ez_eth_transfers.block_timestamp::date >= current_date -7
GROUP BY 1
),
eth_vol_out AS (
SELECT
label,
sum(amount_usd) as eth_out
FROM
ethereum.core.ez_eth_transfers
JOIN ethereum.core.dim_labels ON eth_to_address=address
WHERE ethereum.core.ez_eth_transfers.block_timestamp::date >= current_date -7
GROUP BY 1
),
token_vol_in AS (
SELECT
label,
sum(amount_usd) as token_in
FROM ethereum.core.ez_token_transfers
JOIN ethereum.core.dim_labels ON from_address=address
WHERE ethereum.core.ez_token_transfers.block_timestamp::date >= current_date -7
GROUP BY label
),
token_vol_out AS (
SELECT
label,
sum(amount_usd) as token_out
FROM ethereum.core.ez_token_transfers
JOIN ethereum.core.dim_labels ON to_address=address
WHERE ethereum.core.ez_token_transfers.block_timestamp::date >= current_date -7
Run a query to Download Data