adriaparcerisasLiquidity by Label
Updated 2021-11-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
WITH clean_data AS (
SELECT
date,
address,
CASE WHEN address_label_type IS NULL THEN 'small wallet' ELSE address_label_type END AS address_label_type,
CASE WHEN address_label_subtype IS NULL THEN 'small wallet' ELSE address_label_subtype END AS address_label_subtype,
address_label,
address_name,
balance,
CASE WHEN balance_usd IS NULL THEN 0 ELSE balance_usd END AS balance_usd,
balance_type,
currency
FROM terra.daily_balances
WHERE date >= CURRENT_DATE - 7
)
SELECT
date,
address_label_type,
SUM(balance_usd) AS balance_usd
FROM clean_data
GROUP BY 1,2
ORDER BY 1 DESC
Run a query to Download Data