with A as (

SELECT

date_trunc('{{Date_Trunc}}',block_timestamp) as date,

sum(ISSUED_TOKENS) as Amount_Token,

sum(SUPPLIED_USD) as Amount_USD,

'Supplied' as label

from ethereum.aave.ez_deposits

where SYMBOL='AAVE'

and block_timestamp>=CURRENT_DATE - {{Period_From_Current_Date}}

group by 1

),

B as(

SELECT

date_trunc('{{Date_Trunc}}',block_timestamp) as date,

sum(WITHDRAWN_TOKENS) as Amount_Token,

sum(WITHDRAWN_USD) as Amount_USD,

'Withdrawn' as label

from ethereum.aave.ez_withdraws

where SYMBOL='AAVE'

and block_timestamp>=CURRENT_DATE - {{Period_From_Current_Date}}

group by 1

),

C as(

select * from A

union all

select * from B

select

label,

sum(Amount_USD),

from C

group by 1