SELECT DATE_TRUNC('day', block_timestamp) as day,

SUM(amount) as num_repaid

FROM ethereum.udm_events

WHERE contract_address = '0x6b175474e89094c44da98b954eedeac495271d0f'

AND to_address = '0x0000000000000000000000000000000000000000' and date_trunc('day', block_timestamp) >= '2022-04-01'

GROUP BY day

),

UST as (SELECT avg(price)avg_UST, date_trunc('day', hour) as day

FROM flipside_prod_db.ethereum_core.fact_hourly_token_prices

WHERE token_address = lower('0xa47c8bf37f92aBed4A126BDA807A7b7498661acD') and date_trunc('day', hour) >= '2022-04-01'

GROUP BY 2 )

SELECT d.num_repaid as dai_repaid, u.avg_ust as UST_price, d.day

FROM dai_repaid as d

JOIN UST as u on d.day = u.day