mucrypto BitDAO holdings over time 2023-05-23 08:58 PM
    Updated 2023-05-26
    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