nsa2000Total Block Rewards USD
Updated 2022-10-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
SELECT
-- date_trunc('week', day),
sum(block_rewards * rune_price)
FROM flipside_prod_db.thorchain.block_rewards
LEFT outer JOIN (
SELECT
date_trunc('day', block_timestamp) as day1,
median(LIQ_FEE_RUNE_USD/LIQ_FEE_RUNE) as rune_price
FROM flipside_prod_db.thorchain.swaps
where not LIQ_FEE_RUNE = 0
GROUP BY 1
) ON day = day1
--GROUP BY 1
Run a query to Download Data