with dates as (
select
date_day
from ethereum.core.dim_dates
where date_day between '2021-08-01' and current_date()
),
contracts as (
select *
from
(values
('0x1a4b46696b2bb4794eb3d4c26f1c55f9170fa4c5'), -- BIT
('ETH'),
('0x52a8845df664d76c69d2eea607cd793565af42b8'), --APEX
('0xdac17f958d2ee523a2206206994597c13d831ec7'), --USDT
('0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48')) --USDC
t (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