Query editor
WITHsuper_repaid AS (SELECT DISTINCTrepayment_tx_id,CAST(repaid_date AS DATE) AS day,liquidium_fee_sats AS fee_satsFROM dune.liquidiumwtf.liquidium_repaid_feeWHERE repaid_date IS NOT NULL),super_activation AS (SELECT DISTINCTtx_id,DATE(from_iso8601_timestamp(start_date)) AS day,activation_fee_sats AS fee_satsFROM dune.liquidiumwtf.liquidium_act_feeWHERE TRY(from_iso8601_timestamp(start_date)) IS NOT NULL),ranges AS (SELECT DATE '2025-08-25' AS start_date, DATE '2025-09-21' AS end_date UNION ALLSELECT DATE '2025-09-22', DATE '2025-10-19' UNION ALLSELECT DATE '2025-10-20', DATE '2025-11-16' UNION ALLSELECT DATE '2025-11-17', DATE '2025-12-14' UNION ALLSELECT DATE '2025-12-15', DATE '2026-01-11' UNION ALLSELECT DATE '2026-01-12', DATE '2026-02-08' UNION ALLSELECT DATE '2026-02-09', DATE '2026-03-08' UNION ALLSELECT DATE '2026-03-09', DATE '2026-04-05' UNION ALLSELECT DATE '2026-04-06', DATE '2026-05-03' UNION ALLSELECT DATE '2026-05-04', DATE '2026-05-31' UNION ALLSELECT DATE '2026-06-01', DATE '2026-06-28' UNION ALLSELECT DATE '2026-06-29', DATE '2026-07-26'),act_by_range AS (SELECTr.start_date,r.end_date,CAST(SUM(sa.fee_sats) AS DOUBLE) / 100000000 AS activation_fee_btcFROM ranges rLEFT JOIN super_activation saON sa.day BETWEEN r.start_date AND r.end_dateGROUP BY r.start_date, r.end_date),rep_by_range AS (SELECTr.start_date,r.end_date,CAST(SUM(sr.fee_sats) AS DOUBLE) / 100000000 AS repaid_fee_btcFROM ranges rLEFT JOIN super_repaid srON sr.day BETWEEN r.start_date AND r.end_dateGROUP BY r.start_date, r.end_date)SELECTr.start_date AS "Start",r.end_date AS "End",ROUND(COALESCE(a.activation_fee_btc, 0), 5) AS "Activation Fee BTC",