2844THORChain $RUNE Upgrades
Updated 2022-06-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with BNB_RUNE as
(
select date_trunc('day',BLOCK_TIMESTAMP::date) as "DTE", sum (RUNE_AMOUNT) as "BNB-RUNE", sum (RUNE_AMOUNT_USD) as "BNB-RUNE_USD", count (DISTINCT FROM_ADDRESS) as "number of wallets-BNB"
FROM flipside_prod_db.thorchain.upgrades
where BURN_ASSET ilike 'BNB.RUNE%'
and "DTE"> '2022-03-01'
group by "DTE"
),
ETH_RUNE as
(
select date_trunc('day',BLOCK_TIMESTAMP::date) as "DTE", sum (RUNE_AMOUNT) as "ETH-RUNE", sum (RUNE_AMOUNT_USD) as "ETH-RUNE_USD", count (DISTINCT FROM_ADDRESS) as "number of wallets-ETH"
FROM flipside_prod_db.thorchain.upgrades
where BURN_ASSET ilike 'ETH.RUNE%'
and "DTE"> '2022-03-01'
group by "DTE"
)
SELECT BNB_RUNE."DTE",BNB_RUNE."BNB-RUNE",BNB_RUNE."BNB-RUNE_USD",BNB_RUNE."number of wallets-BNB",
ETH_RUNE."ETH-RUNE",ETH_RUNE."ETH-RUNE_USD",ETH_RUNE."number of wallets-ETH"
FROM BNB_RUNE,ETH_RUNE
WHERE BNB_RUNE."DTE"=ETH_RUNE."DTE"
group by BNB_RUNE."DTE",2,3,4,5,6,7
ORDER by BNB_RUNE."DTE" DESC
Run a query to Download Data