binhachon2. [Easy]Volume of THORChain Bifrost Activity by Asset - Chart
    Updated 2021-10-24
    select date_trunc('week', block_timestamp) as blocktime, 'ETH-RUNE' as symbol, sum(RUNE_AMOUNT) as RUNE_AMOUNT from thorchain.upgrades
    where burn_asset = 'ETH.RUNE-0X3155BA85D5F96B2D030A4966AF206230E46849CB'
    group by blocktime, symbol
    union all
    select date_trunc('week', block_timestamp) as blocktime, 'BNB-RUNE' as symbol, sum(RUNE_AMOUNT) as RUNE_AMOUNT from thorchain.upgrades
    where burn_asset = 'BNB.RUNE-B1A'
    group by blocktime, symbol


    Run a query to Download Data