Query editor
WITH btc_weekly_tx AS (SELECT COUNT(*) AS vFROM bitcoin.transactionsWHERE block_date >= CURRENT_DATE - INTERVAL '7' DAY),btc_weekly_active AS (SELECT COUNT(DISTINCT address) AS vFROM (SELECT addressFROM bitcoin.inputsWHERE block_date >= CURRENT_DATE - INTERVAL '7' DAYAND address IS NOT NULLUNIONSELECT addressFROM bitcoin.outputsWHERE block_date >= CURRENT_DATE - INTERVAL '7' DAYAND address IS NOT NULL) t),eth_weekly_tx AS (SELECT COUNT(*) AS vFROM ethereum.transactionsWHERE block_date >= CURRENT_DATE - INTERVAL '7' DAY),eth_weekly_active AS (SELECT COUNT(DISTINCT "from") AS vFROM ethereum.transactionsWHERE block_date >= CURRENT_DATE - INTERVAL '7' DAY),eth_staking_tvl_eth AS (SELECT SUM(amount_staked- COALESCE(amount_full_withdrawn, 0)- COALESCE(amount_partial_withdrawn, 0)) AS vFROM staking_ethereum.flows),btc_etf_addresses AS (SELECT DISTINCT addressFROM dune.hildobby.dataset_bitcoin_etf_addresses),btc_etf_out AS (SELECT COALESCE(SUM(o.value), 0) AS vFROM bitcoin.outputs oJOIN btc_etf_addresses a ON o.address = a.addressWHERE o.block_date >= DATE '2023-01-01'),btc_etf_in AS (SELECT COALESCE(SUM(i.value), 0) AS vFROM bitcoin.inputs iJOIN btc_etf_addresses a ON i.address = a.addressWHERE i.block_date >= DATE '2023-01-01'),btc_etf_holdings_btc AS (SELECT (o.v - i.v) AS vFROM btc_etf_out oCROSS JOIN btc_etf_in i),eth_price AS (SELECT price