barbodDaily Number of (DAI Minted - DAI Repaid)
Updated 2022-05-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
WITH dai_minted AS (
SELECT DATE_TRUNC('DAY', block_timestamp) as week,
SUM(amount) as num_minted, SUM(amount_usd) as vol_usd_minted
FROM ethereum.udm_events
WHERE contract_address = '0x6b175474e89094c44da98b954eedeac495271d0f'
AND from_address = '0x0000000000000000000000000000000000000000'
GROUP BY week
),
dai_repaid AS (
SELECT DATE_TRUNC('DAY', block_timestamp) as week,
SUM(amount) as num_repaid
FROM ethereum.udm_events
WHERE contract_address = '0x6b175474e89094c44da98b954eedeac495271d0f'
AND to_address = '0x0000000000000000000000000000000000000000'
GROUP BY week
)
SELECT a.week, num_minted, num_repaid,
num_minted - num_repaid as daily_change, vol_usd_minted
FROM dai_minted a INNER JOIN dai_repaid b
ON a.week = b.week
WHERE a.week BETWEEN '2021-11-19' AND '2022-05-19'
Run a query to Download Data