mucryptoTreasury balances
Updated 2023-04-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with daily as (select
block_timestamp::date as day,
token_name,
current_bal
from ethereum.core.ez_balance_deltas
where user_address = lower('0x0BC3807Ec262cB779b38D65b38158acC3bfedE10') -- Nouns DAO
and contract_address is null
and token_name = 'Native Ether'
qualify row_number() over (partition by day, token_name order by block_timestamp desc) = 1)
select
day,
token_name,
current_bal
from daily
-- select
-- current_bal,
-- token_name
-- from ethereum.core.ez_current_balances
-- where user_address = lower('0x0BC3807Ec262cB779b38D65b38158acC3bfedE10')
-- and token_name = 'Native Ether'
Run a query to Download Data