MetiocreAdded DAI vs BTC Price
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
26
27
28
29
30
31
32
33
›
⌄
WITH mint_dai AS(SELECT
date_trunc('day', block_timestamp) as date,
sum(amount) as mint_amount
FROM ethereum.udm_events
WHERE
event_name = 'transfer' AND FROM_address='0x0000000000000000000000000000000000000000' AND
symbol = 'DAI' AND
amount > 0 AND block_timestamp >= GETDATE() - interval'365 days'
GROUP BY date),
burn_dai AS(
SELECT
date_trunc('day', block_timestamp) as date,
sum(amount) as burn_amount
FROM ethereum.udm_events
WHERE
event_name = 'transfer' AND To_address='0x0000000000000000000000000000000000000000' AND
symbol = 'DAI' AND
amount > 0 AND block_timestamp >= GETDATE() - interval'365 days'
GROUP BY date),
btc_price AS(
SELECT
date_trunc('day', hour) as date, avg(price) AS btc_price
FROM ethereum.token_prices_hourly
where symbol = 'WBTC'
AND date >= GETDATE() - interval'365 days'
GROUP BY date)
SELECT mint_dai.date, mint_amount, burn_amount, ( mint_amount-burn_amount) AS added_dai, btc_price,
sum(added_dai) over(order by mint_dai.date) AS cumulative_added_dai
FROM mint_dai
INNER JOIN burn_dai
INNER JOIN btc_price
ON mint_dai.date=burn_dai.date AND mint_dai.date=btc_price.date
Run a query to Download Data