Query editor
WITH Subjects AS (SELECT DISTINCTsubject AS Subject,MIN(evt_block_time) AS first_dateFROM friendtech_base.FriendtechSharesV1_evt_TradeWHERE isBuy = TRUE AND shareAmount > CAST(0 as uint256)GROUP BY 1 ),uniq_Subject AS (SELECTDATE_TRUNC('day',first_date) AS DATE, COUNT(Subject) OVER (ORDER BY DATE_TRUNC('day',first_date)) AS cumulative_unique_subjectsFROM Subjects )SELECT DATE , cumulative_unique_subjectsFROM uniq_SubjectGROUP BY 1,2ORDER BY 1 DESC