farid-c9j0VMUntitled Query
    Updated 2022-06-28
    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