bababaoyu38Avalanche 3
Updated 2022-07-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
WITH ALL_A AS (
SELECT
address,address_name,project_name
FROM avalanche.core.dim_labels
WHERE label_type = 'cex'
)
SELECT
block_timestamp::date AS date,address_name,project_name,SUM ( AMOUNT ) AS outflow_avax
FROM avalanche.core.ez_avax_transfers x
JOIN ALL_A y
ON eth_from_address = address
WHERE block_timestamp::date >= CURRENT_DATE - 30
GROUP BY date,address_name,project_name
Run a query to Download Data