Query editor
WITH norm AS (SELECTDISTINCT tx_id,DATE(from_iso8601_timestamp(start_date)) AS day,activation_fee_sats,collateraltype,typeFROM dune.liquidiumwtf.liquidium_act_feeWHERE TRY(from_iso8601_timestamp(start_date)) IS NOT NULL)SELECTday,collateraltype,type,SUM(activation_fee_sats) AS total_activation_fee_satsFROM normGROUP BY day, collateraltype, typeORDER BY day;