theericstonePre-stacking bars
Updated 2021-11-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with baseline as (
SELECT
date_trunc('day',block_timestamp) as date,
supplier,
supplied_symbol AS underlying_symbol,
sum(supplied_base_asset) AS token_supply_amount,
sum(supplied_base_asset_usd) AS supply_amount_usd
FROM compound.deposits
WHERE block_timestamp > getdate() - interval '30 days' AND
supplied_symbol = 'DAI'
GROUP BY 1, 2, 3
)
-- to confirm total is right
--select date, sum(token_supply_amount) as total_supplied from baseline where date > '2021-04-12' and date < '2021-04-18' group by 1
-- try just plotting top suppliers
select * from baseline where token_supply_amount > 100000;
Run a query to Download Data