theericstonePre-stacking bars
    Updated 2021-11-10
    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