mucrypto BitDAO holdings over time 2023-05-23 08:58 PM
Updated 2023-05-26
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 '2021-08-01' and current_date()
),
contract_address AS (
select
*
from
(
VALUES
('0x1a4b46696b2bb4794eb3d4c26f1c55f9170fa4c5'),
('ETH'),
('0x50d1c9771902476076ecfc8b2a83ad6b9355a4c9'),
('0xdac17f958d2ee523a2206206994597c13d831ec7'),
('0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48')
) t (address)
),
full_list as (
select
date_day,
address,
row_number() over (partition by address order by date_day asc) as row_number
from dates
cross join contract_address
),
balances as (
select
block_timestamp::date as day,
symbol,
iff(contract_address is null, 'ETH', contract_address) as contract_addresses,
current_bal_usd,
Run a query to Download Data