2844THORChain $RUNE Upgrades
    Updated 2022-06-26
    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