date_trunc('day', block_timestamp) as block_day

, contract_address

, event_name

, event_inputs:asset as asset

, event_inputs:emission/1e18 as emission_per_second

, event_inputs:emission/1e18 * 60 * 60 * 24 as emission_per_day

from ethereum.core.fact_event_logs

where contract_address in ('0x4da27a545c0c5b758a6ba100e3a049001de870f5', '0xa1116930326d21fb917d5a27f1e9943a9595fb47') -- stkAAVE, stkABPT

and event_name = 'AssetConfigUpdated'

, dates as (

select distinct

date_trunc('day', b.block_timestamp) as block_day

, e.contract_address

from ethereum.core.fact_blocks b

cross join (select distinct contract_address from emission_config) e

where b.block_timestamp > '2020-10-01'

, staked as (

select

date_trunc('day', block_timestamp) as block_day

, contract_address

, sum(event_inputs:amount) / 1e18 as amount_staked

from ethereum.core.fact_event_logs

where contract_address in ('0x4da27a545c0c5b758a6ba100e3a049001de870f5', '0xa1116930326d21fb917d5a27f1e9943a9595fb47')

and event_name = 'Staked'

-- and block_timestamp > '2022-07-20'

group by block_day, contract_address

, redeemed as (

select