adriaparcerisasThorchain upgrades 3
Updated 2022-01-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
WITH
ethrune as(
select
trunc(block_timestamp,'day') as date1,
count(distinct identified_id) as counts1
from thorchain.upgrades where burn_asset='ETH.RUNE-0X3155BA85D5F96B2D030A4966AF206230E46849CB'
group by 1
),
bnbrune as(
select
trunc(block_timestamp,'day') as date2,
count(distinct identified_id) as counts2
from thorchain.upgrades where burn_asset='BNB.RUNE-B1A'
group by 1
)
SELECT
date1 as days, counts1 as ethrune, counts2 as bnbrune
from ethrune,bnbrune where ethrune.date1=bnbrune.date2
group by 1,2,3
order by 1
Run a query to Download Data