mucrypto2023-05-23 11:45 PM
Updated 2023-05-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with dates as (
select
date_day
from ethereum.core.dim_dates
where date_day between '2022-05-01' and '2022-05-11'
),
contracts as (
select
lower('0x1A4b46696b2bB4794Eb3D4c26f1c55F9170fa4C5') as address),
full_list as (select
date_day,
address
from dates
cross join contracts),
balances as (
select
block_timestamp::date as day,
symbol,
iff(contract_address is null, 'ETH', contract_address) as contract_addresses,
current_bal_usd,
prev_bal_usd
from ethereum.core.ez_balance_deltas
where user_address = lower('0x78605Df79524164911C144801f41e9811B7DB73D') --BitDAO treasury
and (contract_address is null
or contract_address = lower('0x1A4b46696b2bB4794Eb3D4c26f1c55F9170fa4C5')) -- BIT
and block_timestamp::date between '2022-05-03' and '2022-05-04'
qualify row_number() over (partition by day, symbol order by block_timestamp desc) = 1),
symbols as (
select
distinct contract_addresses,
symbol
from balances)