Flipside Team365D Inflation % Over Time
Updated 2024-11-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
-- forked from 2023-07-20 11:44 AM copy @ https://flipsidecrypto.xyz/edit/queries/63b41105-d5f2-4ebd-9dfb-5641f340e0da
WITH supply_data AS (
SELECT
date_trunc('day', BLOCK_TIMESTAMP) AS date,
avg(TOTAL_SUPPLY / 1e24) AS total_supply
FROM near.core.fact_blocks
GROUP BY 1
)
select a.date, 100*(a.total_supply-b.total_supply)/a.total_supply as "365D Inflation %"
from supply_data a
join supply_data b
on a.date=b.date+ interval '365 day'
WHERE a.date >= '{{starting_date}}'
Auto-refreshes every 24 hours
QueryRunArchived: QueryRun has been archived