adambaladoodles treasury
Updated 2022-09-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
WITH treasury as (
select sum(USD_VALUE_NOW ) as "$USD Amount", sum(CURRENT_BAL) as "ETH Balance" ,BLOCK_TIMESTAMP::date as date
from ethereum.core.ez_balance_deltas
where lower(user_address) =lower('0xDcd382bE6cC4f1971C667ffDa85C7a287605afe4')
and BLOCK_TIMESTAMP::date > CURRENT_DATE-60
--and SYMBOL= 'ETH'
group by 3
)
SELECT
treasury.date,
"ETH Balance",
"$USD Amount"
FROM treasury
GROUP BY 1,2,3
ORDER BY date DESC
Run a query to Download Data