SELECT block_timestamp::date as date, from_address, rune_amount, rune_amount_usd,

CASE

WHEN burn_asset LIKE 'BNB%' THEN 'BNB'

ELSE 'ETH'

END AS upgrade_from,

CASE

WHEN burn_asset LIKE 'BNB%' THEN rune_amount

ELSE 0

END AS rune_from_bnb,

CASE

WHEN burn_asset LIKE 'ETH%' THEN rune_amount

ELSE 0

END AS rune_from_eth,

CASE

WHEN burn_asset LIKE 'BNB%' THEN rune_amount_usd

ELSE 0

END AS usd_from_bnb,

CASE

WHEN burn_asset LIKE 'ETH%' THEN rune_amount_usd

ELSE 0

END AS usd_from_eth

FROM flipside_prod_db.thorchain.upgrades

--WHERE date > CURRENT_DATE - 30

SELECT

date,

COUNT(DISTINCT from_address) AS wallets,

sum(rune_from_bnb) AS "$RUNE From BNB",

sum(rune_from_eth) AS "$RUNE From ETH",

sum(usd_from_bnb) AS "USD From BNB",

sum(usd_from_eth) AS "USD From ETH",

date_trunc('MONTH', date) AS monthly

FROM all_upgrades

GROUP BY date