farid-c9j0VMUntitled Query
Updated 2022-06-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
WITH bnb_upgrades AS
(SELECT block_timestamp, rune_amount_usd,from_address
FROM thorchain.upgrades
WHERE burn_asset like '%BNB%'
and date>='2022-01-01'),
eth_upgrades AS (SELECT block_timestamp, rune_amount_usd,from_address
FROM thorchain.upgrades
WHERE burn_asset like '%ETH%')
SELECT DATE_TRUNC('day', a.block_timestamp) as date, count(distinct a.from_address) as addresses ,
SUM(a.rune_amount_usd) as vol_usd_bnb_upgrades, count(distinct b.from_address) as addresses ,
SUM(b.rune_amount_usd) as vol_usd_eth_upgrades
FROM bnb_upgrades a FULL JOIN eth_upgrades b ON a.block_timestamp = b.block_timestamp
GROUP BY date
Run a query to Download Data