theericstoneTether on TRON
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT
date_trunc('month', balance_date) as month,
sum(balance) as total_balance
FROM (
SELECT
balance_date,
address,
balance,
row_number() over(partition by address order by balance_date desc) as rn
FROM
ethereum_token_balances
WHERE
contract_address = '0xdac17f958d2ee523a2206206994597c13d831ec7'
)
WHERE
rn = 1
GROUP BY month
Run a query to Download Data