SocioAnalyticaTotal supply over time
Updated 2024-04-18
999
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
34
35
36
›
-- with token_price as (
-- select
-- date_trunc('day', hour) as date,
-- symbol ,
-- median(price) as usd_price
-- from avalanche.price.ez_hourly_token_prices
-- group by 1 , 2
-- )
-- ,
-- supply as (
-- SELECT
-- date_trunc('day', block_timestamp) as date,
-- token_symbol,
-- sum(amount) as amount_supply
-- FROM avalanche.defi.ez_lending_deposits
-- WHERE platform = 'Benqi'
-- group by 1 , 2
-- )
-- , withdraw as (
-- SELECT
-- date_trunc('day', block_timestamp) as date,
-- token_symbol,
-- sum(amount) as amount_withdraw
-- FROM avalanche.defi.ez_lending_withdraws
-- WHERE platform = 'Benqi'
-- group by 1 , 2
-- )
-- ,
-- calender as (
-- select
-- date_trunc('d', block_timestamp) as date
-- from base.core.fact_transactions
-- where date >= '2021-08-13'
-- group by 1
-- )
QueryRunArchived: QueryRun has been archived